ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

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

Updated on August 6, 2016
lovebuglena profile image

Lena Kovadlo is a writer for various content sharing websites. She's an author of 9 books and helps other authors publish their books.


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


    0 of 8192 characters used
    Post Comment

    • profile image

      noevie berou 3 years ago

      this keyboard shortcuts is very useful .

    • lovebuglena profile image

      Lena Kovadlo 5 years ago from Staten Island, NY

      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

      Taleb AlDris 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"


    • lovebuglena profile image

      Lena Kovadlo 5 years ago from Staten Island, NY

      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!

    Click to Rate This Article