Microsoft Excel is one of the most widely used programs in the world, yet many people are unaware of its full potential or are unable to get beyond the basics. Introduced in 1985, the tool that allows you to edit spreadsheets has continued to evolve. Want to get the most out of it? We leave you with a series of shortcuts that will turn you into a true Excel expert.
Full screen
Basic Excel shortcuts Ctrl+A: Select allCtrl+B: Applies bold formatting to selected textCtrl+C: Copy selected cellsCtrl+D: Fill down from cell aboveCtrl+F: Find and replaceCtrl+H: Find and replace cell contentsCtrl+I: Italicize the selected textCtrl+K: Insert Hyperlink in a cellCtrl+N: New workbookCtrl+O: Open a saved workbookCtrl+P: Displays the Print dialog boxCtrl+R: Fill right from cell leftCtrl+S: SaveCtrl+U: Underline selected textCtrl+V: Paste clipboard contentsCtrl+W: Close the workbookCtrl+X: Cuts the selected cellsCtrl+Y: Redoes the last undone actionCtrl+Z: Undo the last undone actionCtrl+1: Open the Format Cells dialog boxCtrl+2: Applies bold formatting to selected textCtrl+3: Make the selected text italicCtrl+4: Underline the selected textCtrl+5: Strikethrough the selected textCtrl+6: Show or hide objects on the sheetCtrl+8: Show outline symbols on the sheetCtrl+9 : Hides a rowsCtrl+0 : Hide selected columnsExcel Function keys shortcuts F1 : Open Microsoft Excel HelpF2 : Enters edit mode for the active cell.F3 : If a name is defined, displays the Paste Name dialog box.F4 : Repeats the last action and toggles between relative, absolute and mixed references when entering a formula.F5 : Shows the Go To dialog box.F6 : Move between sheets in a split workbookF7 : Shows the Spelling dialog boxF8 : Enables Enlarge Selection mode, which allows you to use the arrow keys to increase the size of the selected area.F9 : Calculates the result of the formulas in all sheets of the open workbooksF10 : Activates the menu barF11 : Creates a chart sheet with the selected range of cellsF12 : Shows the ‘Save As’ dialog box