Excel Shortcuts

Cursor Movement
Control+RightArrowRight-hand side of block
Control+LeftArrowLeft-hand side of block
Control+DownArrowBottom of the Block
Control+HomeGo to cell A1
Control+EndBottom right-hand-side of used area
(Hold down Shift when you do these to select a range)
Sheet/Book Movement
Control+PgUpNext sheet
Control+PgDownPrevious sheet
Control+TabNext workbook
Formula Editing
Control+ ~Display formulae
F2Edit cell formula
Control+RFill right
Control+DFill down
Insertion/Deletion
Control++Insert
Control+-Delete
Selection
Shift+SpaceSelect row
Control+SpaceSelect column
(Shift + arrows selects more rows or columns)
Undo/Redo
Control+ZUndo
Control+YRedo
File Operations
Control+NNew workbook
Control+PPrint
Control+SSave
Format
Control+BBold
Control+UUnderline
Control+IItalic
File Operations
Control+F4Close workbook
Control+TabNext workbook
Shift+F11New sheet
Selection
Control+*Select current region
Control+SpaceSelect column
Shift+SpaceSelect row
(Arrow keys select different items in charts)
Insertion and Movement
Control+PlusInsert cells (or row/column)
Control+Drag Selection Copy (overwrite)Copy (overwrite)
Control+Shift+DragCopy (insert)
Shift+DragMove (inserting)
Concealment
Control+9Hide row
Control+0Hide column (Add shift to unhide)
Cell/Range Naming and Commenting
Control+F3Define/delete names
F3Paste name (in formula)
Shift+F2Edit cell comment
Moving the Cursor Within a Selection
EnterDown
Shift+EnterUp
TabRight
Shift+TabLeft
Control+.Clockwise corners
Miscellaneous
Control+;Current date
Control+HFind & Replace

4 Comments

  1. Joe
    Posted November 14, 2014 at 11:09 am | Permalink

    Thanks for teaching strangers
    This adds to your good karma bank 🙂

    • karen
      Posted November 14, 2014 at 3:29 pm | Permalink

      Happy to hear that these helped you, Joe 🙂

  2. Posted November 8, 2013 at 10:09 am | Permalink

    I actually blog too and I am writing a little something
    very close to this specific blog, “Excel Shortcuts”.
    Do you really mind in case I reallyuse a lot of of
    your own tips? I appreciate it -Adriene

    • karen
      Posted November 8, 2013 at 10:15 am | Permalink

      Hi Heather! I am glad that you found these Excel shortcuts helpful. You are certainly more than welcome to re-use these tips! Thanks for asking.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*