I have used Excel 2003 for many years, and always formatted my pivot tables using the auto report function.
I am now using Excel 2007, and would like to use the same auto reports -
Rather intriguingly, I somehow managed to bring up the 2003 menu (using keystrokes), but immediately forgot the keys I had pressed.
I have seen the 2007 formats, but would like to continue with the 2003 ones,
Thank you in advance,
Tom
Replies (3)
Please login or register to join the discussion.
Excel 2007 pivot table wizard/autoformat keystrokes
Hi Tom
The old Pivot Table wizard can be brought up in Excel 2007 by using the 2003 keystrokes Alt+D,P. You should be able to bring up the old AutoFormats again using the 2003 accelerator keys, in this case Alt O,A when a cell within the pivot table is selected.
Hope it works
A few more navigational aids
Thanks for stepping into the breach with the specific commands, Simon.
I just thought I would add a few more places for people experiencing similar disorientation with Excel 2007.
First up is The ExcelZone Compendium section on Excel 2007, which has links to tips from Simon Hurst and David Carter about finding your way around the system, plus a reference to Microsoft's own interactive guide to the new layout (there's also a downloadable worksheet).
Our Focus on Excel 2007, meanwhile, includes a couple of other links to sites such as Microsoft's Excel 2007 migration guide, plus official and unofficial lists of keyboard shortcuts and function keys.
Hope some of this material will be helpful.
__________________________
John Stokdyk, Technology editor