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.
|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 key combination in Microsoft Excel. These 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. With the help of these given navigation 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 [email protected]|
|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/td>||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 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.