Select Pivot Table

G

Guest

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
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table source table 1
Pivot Table Format 2
Pivot table filter list - listing irrelevant subcategorys 1
Clear row label data in pivot table 2
how do i refresh a pivot with new data 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table Variance 2
Pivot table grand total location 1

Top