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

Enjoy!

 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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: