T Tiffany Mar 5, 2009 #1 hi, i am using office 2007. How to highlight the whole pivot table? Kindly advise.
A Ashish Mathur Mar 5, 2009 #2 Hi, Use Ctrl+Shift+8 -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
T Tiffany Mar 6, 2009 #3 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.
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.