Shortcut Keys For Excel

 

 MICROSOFT EXCEL SHORTCUT KEYS

There are total 222 excel shortcuts for Windows and Mac. Here I am going to explain and making you familiar with some important keys. Following keys you should know to upscale yourself. Now, does anyone expect you to memorize all these keyboard combos? of course not! Everyone's needs are different, so some will be more useful to you than others. And even if you pick up a few new trick's, it's worth it. I have also tried to keep the list clean and simple, so you can do practice from it and take a print out also for further.

My following shortcuts list is also too long. But all king of a complete list of every keyboard combo available in Excel. You can also try it yourself in your data sheet to practice it. Whatever version of Excel you are using this keys certainly useful and will work for it.

  Common Program Shortcuts:-

With the help of below keys you can manipulating workbooks, getting help, and a few other interface-related actions.

• Ctrl+N  :- Create a new workbook
• Ctrl+O  :- Open an existing workbook
• Ctrl+S   :- Save a workbook
• F12       :- Open the Save As dialog box
• Ctrl+W  :- Close a workbook
• Ctrl+F4   :- Close Excel
• F4             :- Repeat the last command or action.
• Shift+F11 :- Insert a new worksheet
• Ctrl+Z     :- Undo an action
• Ctrl+Y     :- Redo an action 
• Ctrol+F2  :- Switch to Print Preview
• F1            :- Open the help page
•  Alt+Q     :- Go to the "Tell me what you want to do" box
• F7             :- Check Spelling
• F9             :- Calculate all work sheets in all open workbooks
• Shift+F9   :- Calculate active worksheets
• Alt or F10 :- Turn key tips on or off
• Ctlr+F1     :- Show or hide the ribbon
• Ctrl+Shift+U :- Expand or collapse the formula bar
• Ctrl+F9  :- Minimize the workbook window
• F11        :- Create a bar chart based on selected date (on a separate sheet)
• Alt+F1  :- Create an embedded bar chart based on select data (same sheet)
• Ctrl+F   :- Search in a spreadsheet, or use Find and Replace
• Alt+F    :- Open the File tab menu
• Alt+H    :- Go to the Home tab
• Alt+N    :- Open the Insert tab
• Alt+P     :- Go to the Page Layout tab
• Alt+M   :-  Go to the Formulas tab
• Alt+A    :- Go to the Data tab
• Alt+R    :- Go to the Review tab
• Alt+W   :- Go to the View tab
• Alt+X    :- Go to the Add-ins tab
• Alt+Y    :- Go to the Help tab
• Ctrl+Tab:- Switch between open workbooks
• Shift+F3 :- Insert a function
• Alt+F8    :-Create, run, edit, or delete a macro 
• Alt+F11  :- Open the Microsoft Visual Basic For Applications Editor

  For Worksheets and Cell:-

With the help of these kind of keyboard shortcuts you can navigate quickly with the workbooks or cell. This will surely increase your typing speed.  

• Left/Right Arrow :- Move one cell to the left or right
• Ctrl+Left/Right Arrow :- Move to the farthest cell left or right in the row
• Up/Down Arrow :- Move one cell up or down
• Ctrl+Up/Down Arrow :- Move to the top or bottom cell in the column
• Tab  :- Go to the next cell
• Shift+Tab :-  Go to the previous cell
• Ctrl+End   :-  Go to the most bottom right used cell
• F5    :- Go to any cell by pressing F5 and typing the cell coordinate or cell name.
• Home :- Go to the left most cell in the current row ( or go to the beginning of the cell if editing a cell)
• Ctrl+Home :- Move to the beginning of a worksheet 
• Page Up/Down :- Move one screen up or down in a work book
• Alt+Page Up/Down :- Move one screen to the right or left in a worksheet
• Ctrl+Page Up/Down :- Move to the previous or next worksheet

Selectin Cells:-

You may have noticed from the previous section you use the arrow key to move between cells, and the Ctrl key to modify that movement. Using the Shift key to modify the arrow keys let you extend your selected cells.

• Shift+Left/Right Arrow :- Extend the cell selection to the left or right
• Shift+Space  :- Select the entire row
• Ctrl+Space   :- Select the entire column
• Ctrl+Shift+Space :- Select the entire worksheet

Editing Cells:- 

Excel also provides some keyboard shortcuts for editing cells.

• F2  :- Edit a cell
• Shift+F2 :- Add or edit a cell comment
• Ctrl+X    :- Cut contents of a cell, selected data, or selected range
• Ctrl+C or Ctrl+Insert :-  Copy contents of a cell, selected data, or selected cell range
• Ctrl+V or Shift+Insert :- Paste contents of a cell, selected data, or selected cell range
• Ctrl+Alt+V  :- Open the Paste Special dialog box
• Delete  :-  Remove the contents of a cell, selected data, or selected cell range
• Alt+Enter  :- Insert a hard return within a cell (while editing a cell)
• F3  :-  Paste a cell name (if cells are named in the worksheet)
• Alt+H+D+C  :- Delete column
• Esc  :- Cancel an entry in a cell or the formula bar
• Enter :- Complete an entry in a cell or the formula bar

Formatting Cells :- 

These keyboard shortcuts will make your work easy and fast. You should practice these keys as much as you can for doing work fast.

• Ctrl+B  :- Add or remove bold to the contents of a cell, selected data, or selected range
• Ctrl+I   :- Add or remove italics to the contents of a cell, selected data, or selected range
• Ctrl+U  :- Add or remove underline to the contents of a cell, selected data, or selected range
• Alt+H+H:- Select a fill color
• Alt+H+B :- Add a border
• Ctrl+Shift+& :- Apply outline border
• Ctrl+Shift+_ (underline)  :- Remove outline border
• Ctrl+9  :- Hide the selected rows
• Ctrl+0 :- Hide the selected columns
• Ctrl+1  :- Open the format Cells dialog box
• Ctrl+5   :- Apply or remove strikethrough
• Ctrl+Shift+$   :- Apply currency format
• Ctrl+Shift+%  :- Apply percent format    

You should use shortcuts to do work fast. More you do practice, you will get upskilled. Hopefully, you've found a few new ones you can use to make your life in Excel a little better. 

If you need some more help you can simply press F1. This opens a help pane and allows you to search for help on any topic.