Shortcut keys for MS Excel 2013

3:32 PM
These are some shortcuts that nice to know in MS Excel 2013. Some are really helpful as previously when I wanted to Save as, I would press Alt + F + A. However in 2013, I need to press Alt + F + A + C (for Computer); So it's really nice to know that Alt + F2 or F12 is save as.



Below is a list of shortcuts in MS Excel 2013 for your reference which you might find it helpful ;)


FUNCTION Shortcut keys for MS Excel 2013


F1
Help for excel
F2
Makes a cell in editable mode. This is helpful if we want to paste only text from a website
F5
This will populate the ‘Go To’ box. Enter the cell address (B23, HH1234...) you want to enter and that particular cell will be highlighted.
F7
Spell checker – can be used to verify spellings of the text in an excel workbook
F8
Once pressed ‘extended selection’ is enabled. Just by pressing arrow key we can select required area. Provides Same features as ‘SHIFT’ is pressed while selecting using arrow key
F9
Recalculate all the formulas in all workbook. Especially useful if we are using UDF in excel sheet
F12
Gives the ‘Save As’ dialog box. Very helpful in saving excel file with some other name/ format ( same feature as ALT+F2)


SHIFT Shortcut keys for MS Excel 2013


Shift +F2
Insert or edit comment. It is difficult to edit comment if ‘show comment’ is disabled in an excel sheet. ‘shift+F2′ will helps to edit the comment easily
Shift +F4
Helps to repeat the last find without opening the find window. 
Shift + F8
Once Pressed ‘Add to selection’ is enabled. Just click the cells you want to select and all the selection is preserved. Provides same feature as ‘CONTROL’ key while doing multiple selection
Shift + F9
Recalculation of excel formulas only on the active sheet of excel
Shift +F11
Inserts a new worksheet in to the active workbook
SHIFT + ENTER
Data entered is stored to the current cell and selection moves to the next cell Above it
SHIFT + TAB
Data entered is stored to the current cell and selection moves to the next cell Left to it
SHIFT + SPACE BAR
Select current row


ALT Shortcut keys for MS Excel 2013


ALT+F2
Display ‘Save As’ dialog box.  Very helpful in saving excel file with some other name/ format ( same feature as F12)
ALT+F4
This will close all the workbooks. It will prompt if contains any unsaved data. If we want to close only active workbook, we should use CTRL+F4.
ALT +F8
Populated the macro window. We can choose any macro and run it. Very helpful running  macro
ALT +F11
Open Visual Basic editor. We can write Macros using VBA code in visual basic editor
ALT + ENTER
Enter a new row in a single cell. Very helpful if we want to write data paragraph  by paragraph
ALT + ‘Page Up’
Moves the active area of a sheet to right side by a screen width
ALT + ‘Page Down’
Moves the active area of a sheet to Left side by a screen width


CONTROL Shortcut keys for MS Excel 2013


CTRL + F1
Used to hide / open the Ribbon in excel 2013.
CTRL + F2
Print preview. CTRL +P for printing active page
CTRL +F3
Opens the name manager. This short cut is not commonly used as we deal rarely with name managers
CTRL+F4
Close the active workbook. Same as ALT+F4 ( This is a windows shortcut for closing any open window)
CTRL+F6
Moves to next active excel workbook. Same functionality as ALT+ TAB ( a windows shortcut for choosing between all active windows )CTRL+F6 selects only excel windows
CTRL+F9
Minimize the active workbook. ( excel window will be opened and only the active workbook will be minimized )
CTRL+F10
Maximize the active workbook. ( excel window will be opened and only the active workbook will be maximized )
CTRL +0
Hide the columns in current selection. Very helpful shortcut while designing an excel template
CTRL +1
Pop ups the formatting window. Very helpful in formatting a selected cell.
CTRL +2
Helpful in making a cell BOLD ( same feature as CTRL+B )
CTRL+8
If we are using grouping for certain rows, There will be an outline near row header. CTRL+8 can be used to view/hide this outline
CTRL+9
Hides rows in current selection. Column equivalent of same feature is CTRL+0
CTRL+SHIFT+0 
Used to unhide the columns if any under selected columns ( hiding columns can be done by CTRL+0 )
CTRL+SHIFT+8
Can be used to identify current region around the active cell. I don’t know what is the use of this shortcut
CTRL+SHIFT+9
Used to unhide the rows if any under selected rows ( hiding rows can be done by CTRL+9 )
CTRL+A
Select all the cells in the excel sheet
CTRL+B
Convert selected text in to bold letter
CTRL+C 
Copy selected content into clipboard
CTRL+D
Fill the content of the top most row in to all the selected cells below that respectively.
CTRL+F
Display the Find box in an excel sheet
CTRL+G
Display the ‘GO TO’ Box. Can be used to navigate to any cell by providing cell address. Same functionality as F5 and very helpful in navigating in a big excel sheet
CTRL+H
Display the ‘Find and Replace’ Dialog box in active sheet
CTRL +I
Convert selected text in to italic letter
CTRL+K
Display the hyperlink window. Whenever a cell needs to be hyperlinked to other sheets/workbook, This shortcut becomes handy
CTRL+N
Can be used to Create a new workbook 
CTRL+O
Opens the ‘open dialog’ Box. Can be used to open an existing workbook by browsing to that file
CTRL+P
Fire a Print command of the active sheet .CTRL+F2 gives a Print preview and CTRL+P prints the file
CTRL+S
Saves the active workbook. Very helpful in preventing data modifications while working on a file
CTRL+V
Paste the data from the clipboard to selected sheet
CTRL+W
Close the active workbook window.
CTRL+X
Cut selected cells. This will cut all features of excel cell including formatting and formula 
CTRL +Y
To Undo an Undo made by “
CTRL+Z
To undo the last update made to an excel file
CTRL + ;
Enters Date stamp to the cell. Only Date is entered.
CTRL + SHIFT + ;
Enters Time to the cell. Only Time is entered.
CTRL + SHIFT + ENTER
Used to enter array formula. Not used in normal cases. Used only when dealing with array formulas.
CTRL + Delete
Delete the entire content to the right of current selection. Very Helpful in deleting row by row instead of deleting character by character
CTRL + /
Used to find out the current range of array around active cell. Not useful if arrays are not used and very helpful while working with a sheet containing arrays and array formulas
CTRL + [
Highlights the cells directly referred by the formula in the selected cell. Same functionality as the 'Trace Precedents' feature in the 'Formula' Tab. 'Trace Precedents' is more useful than this shortcut since it is giving 'arrows' to trace the connections
CTRL + SHIFT + [
Highlights the cells directly or indirectly referred by the formula in the selected cell. Same functionality as Double clicking the 'Trace Precedents' feature in the 'Formula' Tab. 'Trace Precedents' is more useful than this shortcut since it is giving 'arrows' to trace the connections to any levels
CTRL + ]
Highlights the cells directly referred to the formula in the selected cell. Same functionality as the ‘Trace Dependents’ feature in the ‘Formula’ Tab. ‘Trace Dependents’ is more useful than this shortcut since it is giving ‘arrows’ to trace the connections
CTRL + SHIFT + [
Highlights the cells directly or indirectly referred to the formula in the selected cell. Same functionality as Double clicking the ‘Trace Precedents’ feature in the ‘Formula’ Tab. ‘Trace Precedents’ is more useful than this shortcut since it is giving ‘arrows’ to trace the connections to any levels
CTRL + SPACE BAR
Select current column
CTRL + SHIFT + END
Extends the selection to the last used cell on the worksheet From active cell
CTRL + SHIFT + ARROW
Extends the selection to a used cell before a blank cell on the worksheet From active cell
CTRL + SHIFT + 7
Apply border to selected data. Useful shortcut while designing templates in excel
CTRL + SHIFT + -
Remove border to selected data. Useful shortcut while designing templates in excel
CTRL + TAB
Moves to next workbook window. Same functionality as CTRL+F6
CTRL + ARROW
Moves to the next non empty cell in that direction. Same feature as END + Arrow keys
CTRL + ‘Page Up’
Move to next sheet in same workbook
CTRL + “Page Down’
Move to previous sheet in same workbook
CTRL + ~
Displays the Formula in the cell instead of result of the formula



Thanks,
Jo.

Share this :

Previous
Next Post »
1 Comments
avatar

In my lenivo laptop F2 key not warking for editing in excel office 2013

Reply

Leave a comment