Microsoft Excel

Microsoft Excel 100 Most Useful Shortcut Keys:

Across the globe, Microsoft Excel is being used to analyze a huge vary of data. It is one of the information analytical equipment in the market that is being used with the aid of huge companies, small firms, college & college students, and different users.

Data in Excel is on the whole in the shape of rows and columns. This device is normally used to document and analyze data, function mathematical operations, and visualize structured statistics in charts and graphs. The purpose at the back of its recognition is that it has several in-built surfaces which make it less difficult for customers to arrange their data.

Microsoft Excel one hundred Most Useful Shortcut Keys

While running Excel, you will get many keyboard shortcuts that will assist in growing effectivity and productivity. Instead of gaining access to the toolbar with a mouse, you can operate substantial features with two or three keystrokes. Here is a complete listing of the most beneficial shortcut keys in Microsoft Excel that can assist you end up a Spreadsheet Master:

Ctrl + N

 To create a new workbook.

Ctrl + O

 To open a saved workbook.

Ctrl + S

 To save a workbook.

Ctrl + A

 To select all the contents in a workbook.

Ctrl + B

 To turn highlighted cells bold.

Ctrl + C

 To copy cells that are highlighted.

Ctrl + D

 To fill the selected cell with the content of the cell right above.

Ctrl + F

 To search for anything in a workbook.

Ctrl + G

 To jump to a certain area with a single command.

Ctrl + H

 To find and replace cell contents.

Ctrl + I

 To italicise cell contents.

Ctrl + K

 To insert a hyperlink in a cell.

Ctrl + L

 To open the create table dialog box.

Ctrl + P

 To print a workbook.

Ctrl + R

 To fill the selected cell with the content of the cell on the left.

Ctrl + U

 To underline highlighted cells.

Ctrl + V

 To paste anything that was copied.

Ctrl + W

 To close your current workbook.

Ctrl + Z

 To undo the last action.

Ctrl + 1

 To format the cell contents.

Ctrl + 5

 To put a strikethrough in a cell.

Ctrl + 8

 To show the outline symbols.

Ctrl + 9

 To hide a row.

Ctrl + 0

 To hide a column.

Ctrl + Shift + :

To enter the current time in a cell.

Ctrl + ;

 To enter the current date in a cell.

Ctrl + `

 To change the view from displaying cell values to formulas.

ALSO READ : youtube earning of a vedio : how much youtuber earn in a month?


Ctrl + ‘

 To copy the formula from the cell above.

Ctrl + –

 To delete columns or rows.

Ctrl + Shift + =

 To insert columns and rows.

Ctrl + Shift + ~

 To switch between displaying Excel formulas or their values in cell.

Ctrl + Shift + @

 To apply time formatting.

Ctrl + Shift + !

 To apply comma formatting.

Ctrl + Shift + $

 To apply currency formatting.

Ctrl + Shift + #

 To apply date formatting.

Ctrl + Shift + %

 To apply percentage formatting.

Ctrl + Shift + &

 To place borders around the selected cells.

Ctrl + Shift + _

 To remove a border.

Ctrl + –

 To delete a selected row or column.

Ctrl + Spacebar

 To select an entire column.

Ctrl + Shift + Spacebar

 To select an entire workbook.

Ctrl + Home

 To redirect to cell A1.

Ctrl + Shift + Tab

 To switch to the previous workbook.

Ctrl + Shift + F

 To open the fonts menu under format cells.

Ctrl + Shift + O

 To select the cells containing comments.

Ctrl + Drag

 To drag and copy a cell or to a duplicate worksheet.

Ctrl + Shift + Drag

 To drag and insert copy.

Ctrl + Up arrow

 To go to the top most cell in a current column.

Ctrl + Down arrow

 To jump to the last cell in a current column.

Ctrl + Right arrow

 To go to the last cell in a selected row.

Ctrl + Left arrow

 To jump back to the first cell in a selected row.

Ctrl + End

 To go to the last cell in a workbook.

Alt + Page down

 To move the screen towards the right.

Alt + Page Up

 To move the screen towards the left.

Ctrl + F2

 To open the print preview window.

ALSO VISIT :Perfection Base

Ctrl + F1

 To expand or collapse the ribbon.


 To open the access keys.


 Move to the next cell.

Alt + F + T

 To open the options.

Alt + Down arrow

 To activate filters for cells.


 To edit a cell.


 To paste a cell name if the cells have been named.

Shift + F2

 To add or edit a cell comment.

Alt + H + H

 To select a fill colour.

Alt + H + B

 To add a border.

Ctrl + 9

 To hide the selected rows.

Ctrl + 0

 To hide the selected columns.


 To cancel an entry.


 To complete the entry in a cell and move to the next one.

Shift + Right arrow

 To extend the cell selection to the right.

Shift + Left arrow

 To extend the cell selection to the left.

Shift + Space

 To select the entire row.

Page up/ down

 To move the screen up or down.

Alt + H

 To go to the Home tab in Ribbon.

Alt + N

 To go to the Insert tab in Ribbon.

Alt + P

 To go to the Page Layout tab in Ribbon.

Alt + M

 To go to the Formulas tab in Ribbon.

Alt + A

 To go to the Data tab in Ribbon.

Shift + F9

 To calculate an active workbook.

Ctrl + Alt + F9

 To force calculate all workbooks.

Ctrl + F3

 To open the name manager.

Ctrl + Shift + F3

 To create names from values in rows and columns.

Ctrl + Alt + +

 To zoom in inside a workbook.

Ctrl + Alt +

 To zoom out inside a workbook.

Alt + 1

 To turn on Autosave.

Alt + 2

 To save a workbook.

Alt + F + E

 To export your workbook.

Alt + F + Z

 To share your workbook.

Alt + F + C

 To close and save your workbook.

Alt or F11

 To turn key tips on or off.

Alt + Y + W

 To know what’s new in Microsoft Excel.


 To open Microsoft Excel help.

Ctrl + F4

 To close Microsoft Excel.

Alt + R

 To go to the Review tab in Ribbon.

Alt + W

 To go to the View tab in Ribbon.

Alt + Y

 To open the Help tab in Ribbon.

Alt + Q

 To quickly jump to search.

Alt + Enter

 To start a new line in a current cell.

Shift + F3

 To open the Insert function dialog box.


 To calculate workbooks.

SO here is Microsoft Excel100+ shortcut keys



By admin

One thought on “Microsoft Excel 1OO+ Most Useful Shortcut Keys”

Leave a Reply

Your email address will not be published. Required fields are marked *