The Excel software was born to facilitate calculations. However, when the data to be input is large, using the mouse to perform operations will make the work efficiency longer. Therefore, the use of keyboard shortcuts in excel will be the solution to help users get the job done faster.

Use keyboard shortcuts to speed up data entry

The most basic keyboard shortcuts in Excel

Every office worker should “pocket” the basic Excel shortcuts below to perform faster operations:

Some basic keyboard shortcuts in Excel

• Ctrl+A: used to black out the whole worksheet

• CTRL+B: go bold

• Ctrl+I: italicize

• Ctrl+U: underline selected values

• CTRL+C: used to copy/copy data

• Ctrl+X: cut data

• Ctrl+V: to paste copied or cut data

• CTRL+S: save open file

• Ctrl+W and Alt+F4: to close the document

• Ctrl+Z: return to previous action

• Ctrl+Y: restore a canceled order

• CTRL+F: used to search for content or value

• Ctrl+H: both to find and replace terms/values

• Ctrl+O: open saved file

• CTRL+N: open a new file

• CTRL+P: print order

• CTRL+R: used to copy cell contents from left to right

• CTRL+1: Displays the Format Cells dialog box

• CTRL+0: used to hide the selected column

• Ctrl + Shift + 0: to show hidden columns

• CTRL+9: to hide the selected row

• Ctrl + Shift + 9: to show hidden rows

• Control + (-): used to delete selected cells, blocks of cells

• Ctrl + Shift + (+): to insert more empty cells

• CTRL+F4: to close the current workbook

• Alt+F4: Quit the Excel software

Keyboard Shortcuts in Excel to Edit Data

To edit Excel table data, use the following function keys:

Keyboard Shortcuts in Excel to Edit Data in Cells

• F2: edit selected cell

• Alt+Enter: used to enter a line break in the same Excel cell.

• Going back : to delete the character to the left of the mouse or clear the selections.

• DELETE: to clear content to the right of the cursor or clear selections.

• Ctrl + Del: delete text to end of line.

• Enter: scroll down to the box below.

• Shift + Enter: Move to the upper cell.

• Tab/Shift+Tab: move to right/left cell.

• Esc: undo editing in a cell.

• Ctrl+Shift+: Used to insert the current time.

• Alt+H+F+C: used for coloring in Excel

Keyboard shortcuts in Excel for navigation

To navigate through cells in a spreadsheet, we often use the ▽◁▷△ arrow keys to move up, down, left, or right. Additionally, we can use the following Excel keyboard shortcuts:

Navigation keys in Excel

• Pgdn/Pgup: to move up or down in the worksheet.

• Alt+Pgdn/Alt+Pgup: to move the screen right or left in a worksheet.

• Ctrl+Tab, Ctrl+F6: Move back and forth between open workbooks.

• Ctrl + Shift + 0: Show hidden columns in selected area.

• Ctrl + PgUp (like Page Up): to jump to the sheet immediately to the left before the open sheet.

• Ctrl + PgDn (i.e. Page Down): to jump to the sheet immediately to the right after the open sheet.

• CTRL+F: Access the Find and Replace dialog box.

• Ctrl+H: to open the Find and Replace dialog box

• Shift + F4: repeat the previous search operations.

• Ctrl + G (or F5 ): Displays the ‘Go To’ dialog box.

• Ctrl+◁/Ctrl+▷: Inside a Cell: Navigate to the cell to the left or right of that cell.

• Alt + ▽: Displays the auto-complete list.

• Tab/Shift+Tab: Used to move a cell right/left.

• Home: keyboard shortcut for jumping to the beginning of a row in a worksheet.

• Ctrl + Home: to jump to the first cell in the worksheet.

• Ctrl + End: Used to jump to the last cell containing the contents of the worksheet.

Hope the above sharing will help readers understand better The Meaning of Keyboard Shortcuts in Excel. From there, apply yourself to work to calculate and enter data simply, which saves you more time!