Excel Shortcuts to Speed up Calculations

Posted: May 2, 2013 by MaxFraudy in Excel, General Tips

Although it may sound cumbersome to remember keyboard shortcuts for Excel actions, it really does save a lot of time that is otherwise spent on moving between menus and finding various options. Also, once you get started, then you realise that you had been wasting precious time with the mouse. Why don’t you memorise some of the shortcuts below and see if you still disagree.Person typing on a keyboard

Action Shortcut
Select entire column of active cell [Ctrl] + [Space]
Select entire row of active cell [Shift] + [Space]
Edit the active cell (without losing previous value) [F2]
Move to the beginning of the worksheet [Ctrl] + [Home]
Move to the last cell on the worksheet [Ctrl] + [End]
Paste a name into a formula [F3]
Paste a function into a formula [Shift] + [F3]
Alternate value/formula view [Ctrl] + [`] (on key [1])
Calculate all sheets in all open workbooks [F9]
Display the Go To dialog box [F5]
Display the Find dialog box [Shift] + [F5]
Display the Format Cells dialog box [Ctrl] + [1]
Create a chart [F11]
Insert a new sheet [Alt] + [Shift] + [F1]
Repeat the last action [F4]
Repeat Find [Shift] + [F4]
Open [Ctrl] + [F12]
Exit [Ctrl] + [F4]
Check spelling of current cell [F7]
Activate the menu bar [F10]
Display the Macro dialog box [Alt] + [F8]
Apply outline to active cell [Ctrl] + [Shift] + [&]
Convert to a percentage [Ctrl] + [Shift] + [%]
Select all filled cells around active cell [Ctrl] + [Shift] + [*]
Move to next sheet [Ctrl] + [Page Down]
Move to previous sheet [Ctrl] + [Page Up]
Complete a cell entry and move up [Shift] + [Enter]
Complete a cell entry and move right [Tab]
Complete a cell entry and move left [Shift] + [Tab]
Edit a cell comment [Shift] + [F2]

Share your thoughts/feedback

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