Useful Microsoft Excel Keyboard Shortcuts: CTRL, ALT, SHIFT & Others

Source

Microsoft Excel Keyboard Shortcuts

Just like Microsoft Word, Microsoft Excel has many keyboard shortcuts that can be used when working with workbooks and worksheets. These shortcuts are easy to use and are great for those who want to save time, or prefer to work with the keyboard rather than the mouse. Below you will find a list of Microsoft Excel keyboard shortcuts that utilize CTRL, ALT, SHIFT, and other commands.

Microsoft Excel Keyboard Shortcuts - CTRL Commands

  • CTRL + A Select All
  • CTRL + B Bold text
  • CTRL + C Copy text
  • CTRL + D Fill Down
  • CTRL + F Open “Find” dialogue box
  • CTRL + G Open “Go To” dialogue box
  • CTRL + H Open “Replace” dialogue box
  • CTRL + I Italicize text
  • CTRL + K Open “Insert Hyperlink” dialogue box
  • CTRL + L Create a list
  • CTRL + N Open a new workbook
  • CTRL + O Open an existing workbook
  • CTRL + P Print a worksheet
  • CTRL + R Fill to the right
  • CTRL + S Save a workbook
  • CTRL + U Underline text
  • CTRL + V Paste text
  • CTRL + W Close a workbook
  • CTRL + X Cut text
  • CTRL + Y Redo an action
  • CTRL + Z Undo an action
  • CTRL + Page Down Move to next sheet in workbook
  • CTRL + Page Up Move to previous sheet in workbook
  • CTRL + Home Move to beginning of worksheet
  • CTRL + End Move to last cell on worksheet

Microsoft Excel Keyboard Shortcuts - ALT Commands

  • ALT + O, H, R Rename a worksheet
  • ALT + E, N Delete current sheet
  • ALT + E, M Move or copy current sheet
  • ALT + Page Down Move one screen to the right
  • ALT + Page Up Move one screen to the left

Microsoft Excel Keyboard Shortcuts - SHIFT Commands

  • SHIFT + F11 Insert New Worksheet
  • SHIFT + Tab Move one cell to the left
  • SHIFT + CTRL + Page Down Select current and next sheet in workbook
  • SHIFT + CTRL + Page Up Select current and previous sheet in workbook
  • SHIFT + F5 Display the Find dialog box
  • SHIFT + F4 Find Next OR Repeat the last find action.

Microsoft Excel Keyboard Shortcuts - Other Shortcuts

  • TAB Move one cell to the right

Other Microsoft Office Shorcuts

Having learned some useful Microsoft Excel shortcuts you may be interested in learning some Microsoft Word and Microsoft Access shortcuts.

© 2011 Lena Kovadlo

More by this Author


Comments 5 comments

noevie berou 3 years ago

this keyboard shortcuts is very useful .


lovebuglena profile image

lovebuglena 5 years ago from Staten Island, NY Author

Taleb80 - Thanks for your feedback.

Also, thanks for pointing out End + Enter. Will have to check it out.

To answer your question... Well, if you want to delete the current sheet you have to use ALT + E, L. I tried using ALT + E, N and nothing happened...


Taleb80 profile image

Taleb80 5 years ago

As an accountant Excel is part of my daily life.

Thanks for this useful hub.

I would like to add just one more which one time I wasted one hour to search for, It is (End + Enter) it move you to the last active cell in the raw.

This very helpful when you have a huge data.

Could you please, check this (ALT + E, N Delete current sheet), it is not working, may be there is misspelling.

I voted "Useful" & "Up"

Taleb80


lovebuglena profile image

lovebuglena 5 years ago from Staten Island, NY Author

Thanks for your feedback and for voting up!


Shawn Scarborough profile image

Shawn Scarborough 5 years ago from The Lone Star State

Cool hub. These are some great keyboard shortcuts which are some much faster to use than a mouse. Voted up!

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working