close

I do in fact have one more question. In my PivotTable, as a last step to make
it a little easier on the eye, I normally drag one column head (Data) to the
right onto another column head (Total), which leaves me with Data as a quot;mainquot;
column field heading, the names of the relative fields under it (like
quot;subheadingsquot;), and the values from Total arranged in neat columns directly
under those quot;subheadingsquot;). Again I have looked through the application
on-line help and the help posted at
office.microsoft.com/en-us/as...037811033.aspx, but I can't
find a way to essentially drag that column head right and drop it on its
neighbor.

And again, and hopefully finally, any assistance will be most appreciated.

Debra Dalgleish has some pictures that may help:
contextures.com/xlPivot02.html
wrote:
gt;
gt; I do in fact have one more question. In my PivotTable, as a last step to make
gt; it a little easier on the eye, I normally drag one column head (Data) to the
gt; right onto another column head (Total), which leaves me with Data as a quot;mainquot;
gt; column field heading, the names of the relative fields under it (like
gt; quot;subheadingsquot;), and the values from Total arranged in neat columns directly
gt; under those quot;subheadingsquot;). Again I have looked through the application
gt; on-line help and the help posted at
gt; office.microsoft.com/en-us/as...037811033.aspx, but I can't
gt; find a way to essentially drag that column head right and drop it on its
gt; neighbor.
gt;
gt; And again, and hopefully finally, any assistance will be most appreciated.

--

Dave Peterson

Oopsie. You wanted the keystroke equivalent.

Sorry.
wrote:
gt;
gt; I do in fact have one more question. In my PivotTable, as a last step to make
gt; it a little easier on the eye, I normally drag one column head (Data) to the
gt; right onto another column head (Total), which leaves me with Data as a quot;mainquot;
gt; column field heading, the names of the relative fields under it (like
gt; quot;subheadingsquot;), and the values from Total arranged in neat columns directly
gt; under those quot;subheadingsquot;). Again I have looked through the application
gt; on-line help and the help posted at
gt; office.microsoft.com/en-us/as...037811033.aspx, but I can't
gt; find a way to essentially drag that column head right and drop it on its
gt; neighbor.
gt;
gt; And again, and hopefully finally, any assistance will be most appreciated.

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()