Just another knowledge sharing place

  • Join 1 other follower

  • Read Counter

    • 426 hits

Smart Excel Keyboard Shortcuts

Posted by sqlnow on June 1, 2010

Here are some frequently used keyboard shortcuts to speedup the daily work.

Key Combination Purpose
SHIFT+F11 or ALT+SHIFT+F1 To Insert a new worksheet
CTRL+SHIFT+PLUS SIGN To Insert blank cells
F11 or ALT+F1 To Create a chart that uses the current range
ALT+DOWN ARROW To Display the AutoComplete list
CTRL+; (semicolon) To Enter the current date
CTRL+SHIFT+: (colon) To Enter the current time
CTRL+ENTER To Fill the selected cell range with the current entry
SHIFT+F5 To Display the Find dialog box
SHIFT+F4 To Repeat the last Find action
F5 To Display the Go To dialog box
CTRL+1 To Display the Format Cells dialog box


Work smart !!! enjoy the day…

Please leave your valuable comments.


One Response to “Smart Excel Keyboard Shortcuts”

  1. IUser said

    Nice post

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: