Top 100 Shortcut Keys in MS Excel 2013

MS Excel is mainly used for preparing tables and doing various kinds of numeric calculations. But I think it would be a plus point for you if you know all the MS Excel shortcuts. So in this article, I’ll tell you various shortcut keys in MS Excel 2013 so that you can save your time and effort.

Why should you use a keyboard and mouse combination when you can do everything with the keys? So there are many shortcuts which can help you to do your task easily.

I am going to segment the shortcut keys according to their usage.

File Shortcuts

  1. Create a New Workbook- Ctrl + N.
  2. Open a Workbook- Ctrl + O.
  3. Save a Workbook- Ctrl + S.
  4. Save as Workbook- F12.
  5. Print a File- Ctrl + P.
  6. Open Print Preview- Ctrl + F2.
  7. Close Current Workbook- Ctrl + F4.
  8. Close Excel- Alt + F4.

Ribbon Shortcut Keys

  1. Collapse or Expand Ribbon- Ctrl + F1.
  2. Activate Access Keys- Alt.
  3. Move to Next Ribbon Control- Tab.
  4. Open or Activate Selected Control- Space.
  5. Confirm Control Change- Enter.
  6. Get Help on Selected Control- F1.

General Shortcut Keys

  1. Create Chart in New Worksheet- F11.
  2. Create an Embedded Chart- Alt + F1.
  3. Find Previous Match- Ctrl + Shift + F4.
  4. Find Next Match- Shift + F4.
  5. Open Find and Replace- Ctrl + F.
  6. Open Find and Replace and Replace Selected- Ctrl + H.
  7. Open Options- Alt + F + T.
  8. Open Help- F1.
  9. Undo Last Command- Ctrl + Z.
  10. Redo Last Command- Ctrl + Y.
  11. Copy Selected Cells- Ctrl + C.
  12. Cut Selected Cells- Ctrl + X.
  13. Paste Clipboard Content- Ctrl + V.
  14. Open Paste Special Dialogue Box- Ctrl + Alt + V.
  15. Repeat Last Action- F4.

Shortcuts for Tables and Filters

  1. Insert a Table- Ctrl + T.
  2. Toggle Auto Filter- Ctrl + Shift + L.
  3. Activate Filter- Alt + Down Arrow.
  4. Select Table Row- Shift + Space.
  5. Select table Column- Ctrl + Space.
  6. Select All Cells- Ctrl + A.
  7. Clear Slicer Filter- Alt + C.
  8. Toggle table All Rows- Ctrl + Shift + T.

Drag and Drop Shortcuts

  1. Cut Cells- Click + Drag.
  2. Copy Cells- Ctrl + Click + Drag.
  3. Insert Cells- Shift + Click + Drag.
  4. Insert Copy- Ctrl + Shift + Click + Drag.
  5. Drag Worksheet- Alt + Click + Drag.
  6. Drag Duplicate Workbook- Ctrl + Drag.

Now, let’s move on to some more shortcut keys in MS Excel 2013.

You May Also Read- Repair Excel File Manually

Navigation Shortcuts

  1.  Right Cell Movement- Right Arrow Key.
  2. Left Cell movement- Left Arrow Key.
  3. Upward Cell Movement- Up Arrow Key.
  4. Downward Cell Movement- Down Arrow Key.
  5. Right Screen Movement- Alt + Page Down.
  6. Left Screen Movement- Alt + Page Up.
  7. Up Screen Movement- Page Up Key.
  8. Down Screen Movement- Page Down Key.
  9. Right Edge Cell Movement- Ctrl + Right Arrow Key.
  10. Left Edge Cell Movement- Ctrl + Left Arrow Key.
  11. Top Edge Cell Movement- Ctrl + Up Arrow Key.
  12. Down Edge Cell Movement- Ctrl + Down Arrow Key.
  13. Move to Begin Row- Home Button.
  14. Move to the Last Cell of the Sheet- Ctrl + End Key.
  15. Move to First Cell of the Sheet- Ctrl + Home Key.
  16. Turn on End Mode- End.
  17. Go Back to Hyperlink- Ctrl + G + Enter.

Selection Shortcuts

  1. Select Entire Row- Shift + Space.
  2. Select Entire Column- Ctrl + Space.
  3. Select Whole Worksheet- Ctrl + A.
  4. Select Adjacent Cells- Shift + Click.
  5. Select Non- Adjacent Cells- Ctrl + Click.
  6. Move Rightwards Between Non-Adjacent Cells- Ctrl + Alt + Right Arrow Key.
  7. Move Leftwards Between Non-Adjacent Cells- Ctrl + Alt + Left Arrow Key.
  8. Toggle Add to Selection Mode- Shift + F8.
  9. Cancel Selection- F8.

Active Cells Shortcuts

  1. Select Active Cell only- Shift + Backspace.
  2. Show the active cell on the worksheet- Ctrl + Backspace.
  3. Move Active Cell Clockwise in Selection- Ctrl + Full Stop key.
  4. Move Active Cell Downward in Selection- Enter.
  5. Movement of Active Cell Upwards- Shift + Enter.
  6. Movement of Active Cell to the Right- Tab Key.
  7. Move Active Cell to the left- Shift + Tab Key.

Formulas Shortcuts Keys

  1. Open Absolute and Relative References- F4.
  2. Open Insert Function Dialogue Box- Shift + F3.
  3. Autosome Selected Cells- Alt + “=”.
  4. Toggle Formula On or Off- Ctrl + ` “Grave mark”.
  5. Insert Function Arguments- Ctrl + Shift + A.
  6. Apply Array Formula- Ctrl + Shift + Enter.
  7. Calculate Worksheet- F9.
  8. Calculate Active Worksheet- Shift + F9.
  9. Force Calculate All Worksheet- Ctrl + Alt + F9.
  10. Evaluate Part of a Formula- F9.
  11. Collapse or Expand the Formula bar- Ctrl + Shift + U.
  12. Open Function Arguments Dialogue Box- Ctrl + A.
  13. Define Name– Ctrl + F3.
  14. Define Name in Rows and Column labels- Ctrl + Shift + F3.
  15. Paste Name into Formula- F3.
  16. Accept Function Without Auto Complete- Tab.

Pivot Table Shortcuts

  1. Select Pivot Table- Ctrl + A.
  2. Open Pivot Table Filed Checkbox- Space.
  3. Group Pivot Table Contents- Alt + Shift + Right Arrow Key.
  4. Ungroup Pivot Table Contents- Alt + Shift + Left Arrow Key.
  5. Hide Pivot Table Item- Ctrl + – (Hyphen)
  6. Create Pivot Table Chart on the same Worksheet- Alt + F1.
  7. Create Pivot Table Chart on New Worksheet- F11.
  8. Open Pivot Table Wizard- Alt + D + P.

Conclusion

Well, I have told you the various shortcut keys in MS Excel 2013 and it is totally up to you to apply them according to the requirement. I can guarantee that these shortcuts will save a lot of time and energy. In the beginning, it will be quite difficult to memorize the shortcut keys but once you start applying it on a daily basis while preparing the excel sheet then you will get used to it.

If you are facing any kind of error while applying shortcut then your Excel file is corrupted. Try to repair it using an Excel Repair Tool. You have to download the software and upload the excel file. In no time it will repair your file and then you can easily apply all the shortcuts.

About The Author:

Related Post

© Copyrights 2014-2024 Recovery & Management is an Affiliate Partner of Sysinfo Tools Software Pvt. Ltd.