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.

Shortcut keys of Microsoft Excel

These shortcut keys 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?

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.

To Create a new workbook: Press Ctrl+N
To Open an existing workbook: Press Ctrl+O
To Save a workbook: Press Ctrl+S
To Save as a workbook: Press F12
To Print a file: Press Ctrl+P
To Print preview active worksheet: Press Ctrl+F2
To Close active workbook: Press Ctrl+W or Press Ctrl+F4
To Close Microsoft Excel: Press 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.

To Expand or collapse ribbon bar: Press Ctrl+F1
To active hot keys of ribbon bar: Press Alt
To Move next ribbon control: Press Alt then press Tab
To Get help: Press 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.

To Move one cell right: Press right arrow key
To Move one cell left: Press left arrow key
To Move one cell down: Press down arrow key
To Move one cell up: Press up arrow key
To Move one screen left: Press Alt+Page Down
To Move one screen right: Press Alt+Page Up
To Move one screen up: Press Page Up
To Move one screen down: Press Page Down
To Move top edge of data: Press Ctrl+top arrow key
To Move bottom edge of data: Press Ctrl+down arrow key
To Move right edge of data: Press Ctrl+left arrow key
To Move left edge of data: Press Ctrl+right arrow key
To Active next worksheet: Press Ctrl+Page Down
To Active previous worksheet: Press Ctrl+Page Up
To Unhide selected rows: Press Ctrl+Shift+(
To Apply outline border on selected range of cells: Press Ctrl+Shift+&
To Remove outline border on selected range of cells: Press Ctrl+Shift+_
To Apply general format of selected range of cells: Press Ctrl+Shift+~
To Apply currency format of selected range of cells: Press Ctrl+Shift+$
To Apply percentage format of selected range of cells: Press Ctrl+Shift+%
To Apply date format of selected range of cells: Press Ctrl+Shift+#
To Apply time format of selected range of cells: Press Ctrl+Shift+@
To Show current time: Press Ctrl+Shift+:
To Show current date: Press Ctrl+:
To Open insert box: Press Ctrl+Shift++
To Open delete box: Press Ctrl+-
To Open format cell dialogue box: Press Ctrl+1
To Set or remove bold formatting: Press Ctrl+2
To Set or remove italic formatting: Press Ctrl+3
To Set or remove underline formatting: Press Ctrl+4
To Set or remove strikethrough formatting: Press Ctrl+5
To Hide selected rows: Press Ctrl+9
To Hide selected columns: Press Ctrl+0
To Select entire worksheet: Press Ctrl+A
To Open the find dialog box: Press Ctrl+F
To Open the replace dialog box: Press Ctrl+H
To Open the Go To dialog box: Press Ctrl+G or Press F5
To Displays the insert hyperlink dialog box: Press Ctrl+K
To Copy the content with format of the leftmost cell: Press Ctrl+R
To Open the table dialog box: Press Ctrl+T
To Create chart in new worksheet: Press F11
To Turn on or off filter command: Press 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 *