Web Tutorials

</>   HTML Tutorial

Menus

Practicals

Ms Excel

Shortcuts

Introduction

In Windows, most shortcut keys for Word use the Ctrl key combined with a letter.

TO DO THISShortcut
To create a new workbookCtrl + N
To open a saved workbookCtrl + O
To save a workbookCtrl + S
To select all the contents in a workbookCtrl + A
To turn highlighted cells boldCtrl + B
To copy cells that are highlightedCtrl + C
To fill the selected cell with the content of the cell right aboveCtrl + D
To search for anything in a workbookCtrl + F
To jump to a certain area with a single commandCtrl + G
To find and replace cell contentsCtrl + H
To italicise cell contentsCtrl + I
To insert a hyperlink in a cellCtrl + K
To open the create table dialog boxCtrl + L
To print a workbookCtrl + P
To fill the selected cell with the content of the cell on the leftCtrl + R
To underline highlighted cellsCtrl + U
To paste anything that was copiedCtrl + V
To close your current workbookCtrl + W
To undo the last actionCtrl + Z
To format the cell contentsCtrl + 1
To put a strikethrough in a cellCtrl + 5
To show the outline symbolsCtrl + 8
To hide a rowCtrl + 9
To hide a columnCtrl + 0
To enter the current time in a cellCtrl + Shift + :
To enter the current date in a cellCtrl + ;
To change the view from displaying cell values to formulasCtrl + `
To copy the formula from the cell aboveCtrl + ‘
To delete columns or rowsCtrl + -
To insert columns and rowsCtrl + Shift + =
To switch between displaying Excel formulas or their values in cellCtrl + Shift + ~
To apply time formattingCtrl + Shift + @
To apply comma formattingCtrl + Shift + !
To apply currency formattingCtrl + Shift + $
To apply date formattingCtrl + Shift + #
To apply percentage formattingCtrl + Shift + %
To place borders around the selected cellsCtrl + Shift + &
To remove a borderCtrl + Shift + _
To delete a selected row or columnCtrl + -
To select an entire columnCtrl + Spacebar
To select an entire workbookCtrl + Shift + Spacebar
To redirect to cell A1Ctrl + Home
To switch to the previous workbookCtrl + Shift + Tab
To open the fonts menu under format cellsCtrl + Shift + F
To select the cells containing commentsCtrl + Shift + O
To drag and copy a cell or to a duplicate worksheetCtrl + Drag
To drag and insert copyCtrl + Shift + Drag
To go to the top most cell in a current columnCtrl + Up arrow
To jump to the last cell in a current columnCtrl + Down arrow
To go to the last cell in a selected rowCtrl + Right arrow
To jump back to the first cell in a selected rowCtrl + Left arrow
To go to the last cell in a workbookCtrl + End
To move the screen towards the rightAlt + Page down
To move the screen towards the leftAlt + Page Up
To open the print preview windowCtrl + F2
To expand or collapse the ribbonCtrl + F1
To open the access keysAlt
Move to the next cellTab
To open the optionsAlt + F + T
To activate filters for cellsAlt + Down arrow
To edit a cellF2
To paste a cell name if the cells have been namedF3
To add or edit a cell commentShift + F2
To select a fill colourAlt + H + H
To add a borderAlt + H + B
To hide the selected rowsCtrl + 9
To hide the selected columnsCtrl + 0
To cancel an entryEsc
To complete the entry in a cell and move to the next oneEnter
To extend the cell selection to the rightShift + Right arrow
To extend the cell selection to the leftShift + Left arrow
To select the entire rowShift + Space
To move the screen up or downPage up/ down
To go to the Home tab in RibbonAlt + H
To go to the Insert tab in RibbonAlt + N
To go to the Page Layout tab in RibbonAlt + P
To go to the Formulas tab in RibbonAlt + M
To go to the Data tab in RibbonAlt + A
To go to the Review tab in RibbonAlt + R
To go to the View tab in RibbonAlt + W
To open the Help tab in RibbonAlt + Y
To quickly jump to searchAlt + Q
To start a new line in a current cellAlt + Enter
To open the Insert function dialog boxShift + F3
To calculate workbooksF9
To calculate an active workbookShift + F9
To force calculate all workbooksCtrl + Alt + F9
To open the name managerCtrl + F3
To create names from values in rows and columnsCtrl + Shift + F3
To zoom in inside a workbookCtrl + Alt + +
To zoom out inside a workbook Ctrl + Alt +
To turn on AutosaveAlt + 1
To save a workbookAlt + 2
To export your workbookAlt + F + E
To share your workbookAlt + F + Z
To close and save your workbookAlt + F + C
To turn key tips on or offAlt or F11
To know what's new in Microsoft ExcelAlt + Y + W
To open Microsoft Excel helpF1
To close Microsoft ExcelCtrl + F4