ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Select Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/150578-select-pivot-table.html)

Wanna Learn

Select Pivot Table
 
Hi I know that ctr+shift+* selects the entire pivot table. I do not want to
select the headers... Is there a fast way to do this besides ctrl+shift then
arrow right and down

Peo Sjoblom

Select Pivot Table
 
You can use ctrl + * if you use the asterisk on the numpad, saves you one
shift key press

I don't think there is a shortcut for selecting everything but the headers



--
Regards,

Peo Sjoblom



"Wanna Learn" wrote in message
...
Hi I know that ctr+shift+* selects the entire pivot table. I do not want
to
select the headers... Is there a fast way to do this besides ctrl+shift
then
arrow right and down





All times are GMT +1. The time now is 03:43 AM.

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