Excel Pivot Table auto format

Excel Pivot Table auto format

Didn't find your answer?

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.

Simon Hurst
By Simon Hurst
18th Aug 2009 13:24

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

Thanks (0)
John Stokdyk, AccountingWEB head of insight
By John Stokdyk
18th Aug 2009 13:47

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
 

Thanks (0)
Routemaster image
By tom123
19th Aug 2009 08:35

It works
Thank you, that is just what I needed,

Regards

Tom

Thanks (0)