ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need keystrokes equivalent to dragging one column heading onto ano (https://www.excelbanter.com/excel-discussion-misc-queries/70101-need-keystrokes-equivalent-dragging-one-column-heading-onto-ano.html)

[email protected]

Need keystrokes equivalent to dragging one column heading onto ano
 
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 "main"
column field heading, the names of the relative fields under it (like
"subheadings"), and the values from Total arranged in neat columns directly
under those "subheadings"). Again I have looked through the application
on-line help and the help posted at
http://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.

Dave Peterson

Need keystrokes equivalent to dragging one column heading onto ano
 
Debra Dalgleish has some pictures that may help:
http://contextures.com/xlPivot02.html

wrote:

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 "main"
column field heading, the names of the relative fields under it (like
"subheadings"), and the values from Total arranged in neat columns directly
under those "subheadings"). Again I have looked through the application
on-line help and the help posted at
http://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.


--

Dave Peterson

Dave Peterson

Need keystrokes equivalent to dragging one column heading onto ano
 
Oopsie. You wanted the keystroke equivalent.

Sorry.

wrote:

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 "main"
column field heading, the names of the relative fields under it (like
"subheadings"), and the values from Total arranged in neat columns directly
under those "subheadings"). Again I have looked through the application
on-line help and the help posted at
http://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.


--

Dave Peterson


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com