The VBScript Network and Systems Administrator's Cafe

May 19 2009   3:35PM GMT

Excel Shortcuts: Quickly format your excel documents like a pro without using the mouse

Jerry Lees Jerry Lees Profile: Jerry Lees

Like I mentioned in an earlier post I’ve been working quite a bit in Microsoft Office recently, in this post (and the next one) I’ll bring you a series of quick short cut keys to help you format your Microsoft Excel documents quickly and easily.

The following shortcuts come in quite handy when you are formatting a document and need to do some pretty standard things like research why a cell looks a particular way, place the time or date in a cell or change formatting in a cell.

Enter the date Ctrl + ; (semicolon)
Enter the time Ctrl + Shift + : (colon)
Find out about the style within the cell ALT + ‘ (apostrophe)
Display the Format Cells dialog box Ctrl + 1


 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: