Oct 8 2008

Excel Keyboard Shortcuts

Using these Microsoft Excel shortcuts will greatly decrease your time spent doing simple operations. This is not an exhaustive list of available shortcuts, only commands that I have found useful through my experiences.  I’ve found that the best way to see if any of them will work for me, is to try a couple at a time and get used to using them.  Over time, they can gradually increase your productivity if you give them a chance.


[ad#in-post-ad]
 

Shortcut Keys

Action

F1

Display the Assistant Balloon or Turns on Assistant

CTRL+P or CTRL+SHIFT+F12

Print
ALT+F then press V
Print Preview
SHIFT+F11 or ALT+SHIFT+F1
Move to the next Sheet
CTRL+PAGE UP
Move to the previous sheet
Arrow Keys
Move one cell in that direction
CTRL+arrow keys
Move to the edge of the data region
HOME
Move to the beginning of the row
CTRL+HOME
Move to the beginning of the worksheet
CTRL+END
Move to the last cell on the worksheet (inside data region)
PAGE DOWN
Move down one screen
PAGE UP
Move up one screen
ALT+PAGE DOWN
Move one screen to the right
ALT+PAGE UP
Move one screen to the left.
F5
Display the GO TO box.
CTRL F or SHIFT+F5
Display the FIND box.
SHIFT+F4
Repeat the last FIND action
End+arrow key
Move by one block of data within a row or column
END+HOME
Move to the last cell in the worksheet (inside data region)
END+ENTER
Move to the rightmost nonblank cells in the current row.
CTRL+SPACEBAR
Select the entire column
SHIRT+SPACEBAR
Select the entire row
CTRL+A
Select Entire Worksheet
CTRL+SHIFT+*
Select the entire PivotTable Report
CTRL+SHIRT+O
Select all cells that contain comments
CTRL+[
Select all cells directly references by formulas in the selection
CTRL+]
Select cells that contain formulas that directly reference the active cell
F8
Turn the Extend Mode on/off
SHIFT+arrow key
Extend the selection by one cell
CTRL+SHIRT+arrow key
Extend the selection to the last nonblank cell in the same column or row.
SHIFT+HOME
Extend the selection to the beginning of the row
CTRL+SHIFT+HOME
Extend the selection to the beginning of the worksheet
CTRL+SHIFT+END
Extend the selection to the last used cell on the worksheet
ENTER
Complete a cell entry and select the cell below.
ALT+ENTER
Start a new line in the same cell
TAB
Complete a cell entry and select the next cell to the right.
SHIFT+TAB
Complete a cell entry and select the previous cell to the left.
ESC
Cancel a cell entry
Arrow Key (within cell entry)
Move one character up, down, left, right
CTRL+D
Fill Down
CTRL+R
Fill Right
CTRL+K
Insert a Hyperlink
CTRL+;
Enter the Date
CTRL+SHIFT+:
Enter the time
CTRL+Z
Undo your last action
=
Start a formula
CTRL+SHIFT+ENTER
Enter a formula as an array formula
SHIFT+F3
In a formula, display the Insert Function
ALT+=
Insert an autosum formula
CTRL+’
Alternate between displaying cell values and displaying formulas
F9
Calculate all worksheets in all open workbooks
SHIFT+F9
Calculate the active worksheet
F7
Spellcheck
SHIFT+F2
Edit a cell comment
CTRL+C
Copy the selected cells
CTRL+X
Cut the Selected Cells
CTRL+V
Paste Copied Cells
DELETE
Clear the contents of the selected cells
CTRL+1
Display the Format Cells dialog box
CTRL+SHIFT+~
Apply the General Number format
CTRL+SHIFT+$
Apply the Currency format with 2 decimal places
CTRL+SHIFT+%
Apply the Percentage format
CTRL+SHIFT+^
Apply the Exponential number format
CTRL+SHIFT+#
Apply the Date format
CTRL+SHIFT+@
Apply the time format
CTRL+SHIFT+!
Apply the Number format with 2 decimal places
CTRL+B
Apply Bold formatting
CTRL+I
Apply Italic formatting
CTRL+U
Apply Underline formatting
CTRL+5
Apply strikethrough formatting
CTRL+9
Hide selected rows
CTRL+SHIFT+(
Unhide any hidden rows with selection
CTRL+9
Hide selected columns
CTRL+SHIFT+)
Unhide any hidden columns with selection
ALT+down arrow
Displays the auto-filter list in the current column

** Excel Hints provides Excel Tips and Excel Help for All Levels.

More Excel Tips

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          
TAGS:

12 Comments on this post

Trackbacks

  1. Writing a Custom Function | Excel Hints wrote:

    [...] Basic editor.  A quick way to get to the VBA editor is to hit the Alt+F11 key sequence (Additional keyboard shortcuts).  Once you get into the VBA editor, from the menu bar – select Insert–>Module.  This is [...]

    February 22nd, 2009 at 6:24 pm
  2. Excel Keyboard Shortcuts from Microsoft wrote:

    [...] few years ago, I wrote a post listing many of the keyboard shortcuts that are available in Microsoft Excel. They included anything from copy & paste shortcuts to [...]

    July 26th, 2011 at 10:52 am
  1. Sammie said:

    This is very useful to me and I have printed it out for quick reference. I have just started usign excel and these are going to be great to help me learn the product quickly. Great site you have here.

    November 15th, 2008 at 12:09 pm
  2. john said:

    I’m glad you’ll be able to use some of those. I don’t use them all, but I slowly try to add more every so often to make the work quicker.

    November 15th, 2008 at 5:23 pm
  3. Icon said:

    Nice post, John!
    It would be easier and faster with keyboard shortcut.
    Thanks.

    November 30th, 2008 at 11:35 pm
  4. serdarb said:

    very nice post…

    January 7th, 2009 at 9:46 am
  5. Shtanto said:

    Neat!

    I know CTRL+PgUp and CTRL+PgDn can move me between sheets. Is there a keyboard shortcut to take me to the first/last sheet of a workbook?

    Cheers,
    Shtan

    January 11th, 2009 at 4:56 pm
  6. john said:

    Hi Shtanto – I’m not sure of a shortcut that can handle that (I’ll look around to see if I can find it). You could always write your own macro and keyboard shortcut to handle this in VBA ;-)

    January 13th, 2009 at 1:21 am
  7. Shtanto said:

    Thanks John

    I was sort of hoping there was a built in shortcut. I guess I’m stuck with holiding down a button for a few seconds :p

    If it were there, I’d expect it to be something like ctrl+shift+pgdn. That’d make sense.

    Cheers,
    Shtan

    January 13th, 2009 at 10:01 am
  8. sunil kumar said:

    nice

    March 19th, 2013 at 6:45 am
  9. Azhar said:

    Excellent and fruitfull.!

    April 11th, 2013 at 2:25 pm
  10. genesis today pure green coffee bean extract capsules reviews said:

    Hey there! I understand this is sort of off-topic but I had to ask.
    Does building a well-established website like yours take a large amount of work?

    I am brand new to operating a blog however I
    do write in my journal on a daily basis. I’d like to start a blog so I can share my personal experience and views online. Please let me know if you have any suggestions or tips for brand new aspiring bloggers. Thankyou!

    April 14th, 2013 at 4:33 am

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives