SPACEBAR In a dialog box, performs the action for the selected button, or selects or clears a check box.

Sometimes you want to see the full name of the month Excel. As normal there is more than one way.

Use a custom number format:

To open the Format Cells dialog, in Excel 2007, on the Home tab, click the small (almost invisible) arrow on the bottom right corner of the Number group. In Excel 2000-2003, from the Format menu select Cells and click the Number tab. If you like keyboard shortcuts, CTRL+1 in either version of Excel will bring up the Format Cells dialog. Now, click the Custom category on the left and enter mmmm in the Type field. To display just the first three letters of the month, type mmm instead.

Use function TEXT():

=TEXT(B2,”mmmm”) will return the month’s full name as a text string from a date in cell B2. If you want just the first three letters of the month name, use mmm instead. Also try other combinations of d=day, m=month and y=year (i.e. mmmm d, yyyy).

Also try other combinations of d=day, m=month and y=year (i.e. mmmm d, yyyy) in both the custom date format and the TEXT function.

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.