The VBScript Network and Systems Administrator's Cafe

May 22 2009   3:44PM GMT

Excel Shortcuts: More useful Excel shortcuts to quickly format Excel like a pro

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 numbers or need to place a border on a particular cell.

Apply the general number format Ctrl + Shift + ~
Turn numbers into dollars Ctrl + Shift + $
Make numbers a percentage Ctrl + Shift + %
Apply a border Ctrl + Shift + &

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: