Top MS Excel Shortcut Keys for Beginners
(Part-2)
|
By using shortcuts keys we will reduce our work-time and make it easier to work in any application. We can do all the tasks with mouse also, but it reduces our productivity and also it takes more time to complete the work. So, here we will discuss about shortcut keys of MS Excel. If you are a beginner of MS Excel, these shortcut keys are definitely helpful for you. These MS Excel shortcut keys works with all the versions MS Excel 2003, MS Excel 2007, MS Excel 2010 and MS Excel 2013.
In this blog, we will see some basic MS Excel shortcut keys and their uses.
MS Excel Shortcut Keys :
Click here : Top MS Excel Shortcut Keys (Part-1)
| MS Excel Keyboard Shortcut | Work of this shortcut |
|---|---|
Ctrl+Tab
|
Move between two or more open excel files.
|
Ctrl+Shift+Tab
|
Actives the previous workbook.
|
Ctrl+Shift+A
|
Insert argument names into a formulas.
|
Ctrl+Shift+F
|
Opens the Dropdown menu for fonts.
|
Ctrl+Shift+O
|
Selects all of the cells that contains comments.
|
Ctrl+Shift+P
|
Opens the Dropdown menu for point size.
|
Shift+Insert
|
Paste the content that is stored on the clipboard.
|
Shift+PageUp
|
In a single column, it highlights all the cell above that which are selected.
|
Shift+Home
|
To highlight all text to the left of the cursor in the current line.
|
Shift+End
|
To highlight all text to the right of the cursor in the current line.
|
Shift+UpArrow
|
It extends the highlighted area to up one cell.
|
Shift+DownArrow
|
It extend the highlighted area to down one cell.
|
Shift+LeftArrow
|
It extends the highlighted area to left side by one character.
|
Shift+RightArrow
|
It extend the highlighted area to right side by one character.
|
Alt+Spacebar
|
It Opens the system menu.
|
Alt+BackSpace
|
To do undo.
|
Alt+Enter
|
While typing text in a cell, to move in the next line press Alt+Enter.
|
ALt+=
|
It creates the formula to calculate sum of all the above cells.
|
Alt+'
|
Allows formatting on a dialog box.
|
Ctrl+F3
|
To open excel name manager.
|
Ctrl+F4
|
To close current window.
|
Ctrl+F5
|
To Restore window size.
|
Ctrl+F6
|
Move to next workbook.
|
Ctrl+Shift+F6
|
Move to previous workbook.
|
Ctrl+F7
|
It moves the window.
|
Ctrl+F8
|
It resizes the window.
|
Ctrl+F9
|
To minimize current window.
|
Ctrl+F10
|
To maximize currently selected window.
|
Ctrl+F11
|
It inserts a macro sheet.
|
Ctrl+F12
|
It opens a file.
|
Ctrl+Shift+F3
|
Create names by using those of either row or column levels.
|
Ctrl+Shift+F6
|
It moves to the previous worksheet window.
|
Ctrl+Shift+F12
|
To print the current worksheet.
|
Alt+F1
|
To insert a chart.
|
Alt+F2
|
To perform 'Save as' action.
|
Alt+F4
|
To exit from Ms Excel.
|
Alt+F8
|
It opens the Macro DialogBox.
|
Alt+F11
|
It opens the Visual Basic editor.
|
Alt+Shift+F1
|
It creates a new worksheet.
|
Alt+Shift+F2
|
To save the current worksheet.
|
F1
|
It opens the Help menu.
|
F2
|
To Edit the selected cell.
|
F3
|
To paste names.
|
F4
|
It repeats last action for example- if you change the color of text in another cell, pressing F4 will change the text in the current cell to the same color.
|
F5
|
Go to a specific cell.
|
F6
|
To move to the next pane.
|
F7
|
To spell check of selected text or documents.
|
F8
|
Enters Extends Mode.
|
F9
|
Recalculates every workbook.
|
F10
|
To activates the menu bar.
|
F11
|
It creates a chart from the selected data.
|
F12
|
To perform 'Save as' action.
|
Shift+F1
|
It opens the "What's This?" window.
|
Shift+F2
|
It allows the users to Edit a cell comment.
|
Shift+F3
|
To open the Excel formula window.
|
Shift+F5
|
It brings up a 'SearchBox'.
|
Shift+F6
|
To move to previous pane.
|
Shift+F8
|
Add to Selection.
|
Shift+F9
|
It performes calculates function on active sheet.
|
Click here : Top MS Excel Shortcut Keys (Part-1)
Go to my YouTube channel and watch more interesting Technical Tips & Tricks Videos
Click Here : My YouTube Channel
No comments:
Post a Comment