What? A Keyboard Shortcut For Print Preview !? (XL2007)

Everyone uses Print Preview – a lot. If you've been using Excel for some time and if you've been getting my newsletter for some time, I would like to think you've taken my advice and created a custom toolbar(s) to hold your favourite (yes, in Canada favourite contains a U) and frequently-used Excel commands.

Also, you've probably often heard me harping on the benefits of learning a 'mouse method' and a 'keyboard method' for your frequently used commands. If you're two hands are on the keyboard, a keyboard shortcut is often quicker than reaching for your mouse. And the reverse is true for when you are in 'mouse mode'.

Rather than clicking the Print Preview button, if you've added it to your Quick Access Toolbar or going through the Office Button, Print, Print Preview (if you haven't), in Excel 2007 you can simply press CTRL+F2 to open the Print Preview window.

When I recently discovered this shortcut, I wondered if I had been overlooking this for all those years. However, as far as I can figure, it became available only with the release of Excel 2007.

via Microsoft Excel Tips.