Important Shortcut keys of Microsoft Excel

Hi, friends today we are knowing important shortcut keys of Microsoft Excel. During working on the Microsoft Excel if you need to improve your performance then you have to use shortcut keys of Microsoft Excel. Shortcut keys not only improve your performance but also reduce extra working time. In this article we have to discuss important shortcut keys of Microsoft Excel.

Microsoft Excel is an important application software which is used to solve different numeric problems, data analysis, modelling. You can easily represent numerical data interm of 2D or 3D charts. If you want to do work faster than other professionals then you have to use shortcut keys of Microsoft Excel.

These shortcut keys of Excel provide quick way to execute different commands. There are different type of shortcut keys which not only reduce extra working time but also enhance your performance. You have to improve your working performance with the help of these given shortcut keys of Microsoft Excel.

Must Read: What is Keyboard Shortcuts in Microsoft Word?

Important Shortcut keys of Microsoft Excel

If you want to do faster working on Excel sheet then you must have to know about these given Excel shortcut keys. Different important keys are categories in different sections, have a look.

File Menu Shortcut keys

You can use these given shortcut keys of Microsoft Excel which is related to the file menu. If you want to do any task which is related to file menu then you have to take help of these given shortcut keys.

PARTICULARSHORTCUT KEY
To Create a new workbookPress Ctrl+N
To Open an existing workbookPress Ctrl+O
To Save a workbookPress Ctrl+S
To Save as a workbookPress F12
To Print a filePress Ctrl+P
To Print preview active worksheetPress Ctrl+F2
To Close active workbookPress Ctrl+W or Press Ctrl+F4
To Close Microsoft ExcelPress Alt+F4

Ribbon Bar Shortcut keys

If you have to use ribbon bar icons without using the mouse then you have to use given shortcut keys of Microsoft Excel. These shortcut keys is applicable only for Ribbon bar in MS Excel.

PARTICULARSHORTCUT KEY
To Expand or collapse ribbon barPress Ctrl+F1
To active hot keys of ribbon barPress Alt
To Move next ribbon controlPress Alt then press Tab
To Get helpPress F1

Must Read: How to Assign Shortcut Key to open any program

Navigation Shortcut keys Excel

If you want to navigate in active worksheet or workbook then you just have to take help of following given shortcut keys. With the help of these given navigation shortcut keys of Microsoft Excel you can quickly navigation in the worksheet or workbook.

PARTICULARSHORTCUT KEY
To Move one cell rightPress right arrow key
To Move one cell leftPress left arrow key
To Move one cell downPress down arrow key
To Move one cell upPress up arrow key
To Move one screen leftPress Alt+Page Down
To Move one screen rightPress Alt+Page Up
To Move one screen upPress Page Up
To Move one screen downPress Page Down
To Move top edge of dataPress Ctrl+top arrow key
To Move bottom edge of dataPress Ctrl+down arrow key
To Move right edge of dataPress Ctrl+left arrow key
To Move left edge of dataPress Ctrl+right arrow key
To Active next worksheetPress Ctrl+Page Down
To Active previous worksheetPress Ctrl+Page Up
To Unhide selected rowsPress Ctrl+Shift+(
To Apply outline border on selected range of cellsPress Ctrl+Shift+&
To Remove outline border on selected range of cellsPress Ctrl+Shift+_
To Apply general format of selected range of cellsPress Ctrl+Shift+~
To Apply currency format of selected range of cellsPress Ctrl+Shift+$
To Apply percentage format of selected range of cellsPress Ctrl+Shift+%
To Apply date format of selected range of cellsPress Ctrl+Shift+#
To Apply time format of selected range of cellsPress Ctrl+Shift+@
To Show current timePress Ctrl+Shift+:
To Show current datePress Ctrl+:
To Open insert boxPress Ctrl+Shift++
To Open delete boxPress Ctrl+-
To Open format cell dialogue boxPress Ctrl+1
To Set or remove bold formatting/td>Press Ctrl+2
To Set or remove italic formattingPress Ctrl+3
To Set or remove underline formattingPress Ctrl+4
To Set or remove strikethrough formattingPress Ctrl+5
To Hide selected rowsPress Ctrl+9
To Hide selected columnsPress Ctrl+0
To Select entire worksheetPress Ctrl+A
To Open the find dialog boxPress Ctrl+F
To Open the replace dialog boxPress Ctrl+H
To Open the Go To dialog boxPress Ctrl+G or Press F5
To Displays the insert hyperlink dialog boxPress Ctrl+K
To Copy the content with format of the leftmost cellPress Ctrl+R
To Open the table dialog boxPress Ctrl+T
To Create chart in new worksheetPress F11
To Turn on or off filter commandPress Ctrl+Shift+L

Must Read: Cool interesting windows 8 keyboard shortcuts to impress anyone

Selection Shortcut keys Excel

If you want to select cells, row or columns in quick way then you have two choices either you have to use Mouse or use given shortcut keys.

To Select active row: Press Shift+Spacebar
To Select active column: Press Ctrl+Spacebar
To Extend selection up one screen: Press Shift+Page Up
To Extend selection down one screen: Press Shift+Page Down
To Turn-on extend selection mode: Press F8
To Select one cell right side: Press Shift + Right arrow key
To Select one cell left side: Press Shift + Left arrow key
To Select one cell upward : Press Shift + Up arrow key
To Select one cell downward : Press Shift + Down arrow key
To Select adjacent cells continuously: Press and hold Shift + Click on any cell
To Select adjacent cells non-continuously: Press and hold Ctrl + Click on any cell

General Shortcut keys Excel

There are lot of general shortcut keys are used in Ms Excel. In this guide we have to discuss few top most important general shortcut keys of Microsoft Excel.

To Edit active cell contents: Press F2
To Copy the select cell contents: Press Ctrl+C
TO Paste the copied cell contents: Press Ctrl+V
To Delete active cell contents: Press DEL or Backspace
To Copy formula from above cell: Press Ctrl+’
To Copy values from above cell: Press Ctrl+Shift+”

Must Read: How to use Important Facebook Shortcut Key

I hope after reading this guide you can use increase the working speed with the help of shortcut keys of Microsoft Excel. These shortcut keys not only provide the knowledge but also increase the working performance also. If you have any suggestion regarding this article please write us in the comment box. Thanks to all.

Leave a Reply

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