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
- Oct 18 Sat 2008 20:46
Need keystrokes equivalent to dragging one column heading onto ano
close
全站熱搜
留言列表
發表留言