ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   pivot table (https://www.excelbanter.com/excel-worksheet-functions/223160-pivot-table.html)

Tiffany

pivot table
 
hi,

i am using office 2007. How to highlight the whole pivot table?

Kindly advise.

Ashish Mathur[_2_]

pivot table
 
Hi,

Use Ctrl+Shift+8

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tiffany" wrote in message
...
hi,

i am using office 2007. How to highlight the whole pivot table?

Kindly advise.



Tiffany

pivot table
 
it doesn't work because it only highlight the data, column and row fields but
it didn't capture the page field. What I mean is to copy to whole pivot
table. Kindly advise.

Thank you.

"Ashish Mathur" wrote:

Hi,

Use Ctrl+Shift+8

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tiffany" wrote in message
...
hi,

i am using office 2007. How to highlight the whole pivot table?

Kindly advise.





All times are GMT +1. The time now is 08:38 AM.

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