In this tutorial, we introduce you to our top 10 most useful keyboard shortcuts in Excel to save you time. These Are:
1) To sum a column of numbers, Alt + =
2) To select the entire spreadsheet, Ctrl + A
3) To select a Column, Ctrl + Space
To select a Row, Shift + Space
4) To move to the start of the spreadsheet, Ctrl + Home
To move to the end of the spreadsheet, Ctrl + End
5) To hide a column, Ctrl + 0 while a cell in that column is selected
To un-hide a column, Alt + H - O - U - L
6) To insert the date, Ctrl + ;
7) To insert the time, Ctrl + Shift + ;
8) To view the formula in the selected cells, Ctrl + `
9) To move to the Worksheet on the right, Ctrl + PgDn
To move to the Worksheet on the left, Ctrl + PgUp
10) To enter Data into multiple cells at the same time, Ctrl + Enter
That's all of our favourite 10 keyboard shortcuts in Excel 2013.
Enjoy!
10 Most Useful Excel Keyboard Shortcuts Tutorial
Теги
Keyboard ShortcutComputer KeyboardkeyboardExcelMicrosoft Excel (Software)usefulkeyboard shortcutsspreadsheetcolumnviewformulaworsheetmultiplecellsexcel shortcutsexcel keyboard shortcutsexcel tutorialmicrosoft excel tutorialmicrosoft excel keyboard shortcutsexcel shortcutexcel time saving tricksExcel topexcel top 10 formulaexcel top shortcut keysexcel basics for beginnersmicrosoft excel shortcut keysexcel 2013learn excelexcel 2016