ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

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

Updated on July 28, 2017
lovebuglena profile image

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


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.

CTRL Shortcuts

  • 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

ALT Shortcuts

  • 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

SHIFT Shortcuts

  • 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.

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 4 years ago

      this keyboard shortcuts is very useful .

    • lovebuglena profile image

      Lena Kovadlo 6 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 6 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 6 years ago from Staten Island, NY

      Thanks for your feedback and for voting up!

    • Shawn Scarborough profile image

      Shawn Scarborough 6 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!