Invaluable keyboard shortcuts in Excel

The use of shortcuts helps you accelerate your work many times. The following article introduces the most commonly used keyboard shortcuts in Excel.

Invaluable keyboard shortcuts in Excel Picture 1

1. Basic keyboard shortcuts

Enter: Assign the entered data to the cell and move it to the bottom of the cell.

ESC: Ignore the data that is changing.

Alt + Enter : Create a new line in the same cell.

BackSpace: Delete characters to the left of the selection.

F4 or Ctrl + Y : Repeat the previous operation.

Delete: Delete the character to the right of the mouse cursor or selection.

Ctrl + Delete : Delete all text on the highlighted line or mouse cursor.

Ctrl + D : Copy data from the top cell to the bottom cell.

Ctrl + R : Copy data from the left pane to the right.

Shift + Enter : Assign data to a cell and move it above the selection.

2. Data format shortcuts

2.1. Format cell data

Ctrl + 1 : Display the Format dialog box.

Ctrl + B (or Ctrl + 2 ): Format bold or cancel bold.

Ctrl + I (or Ctrl + 3 ): Format italics or cancel italics.

Ctrl + U (or Ctrl + 4 ): Format underlined text or cancel underline.

Ctrl + 5 : Format dash or cancel.

Alt + ' : Display the Style dialog box.

2.2. Number format

Ctrl + Shift + $ : Format currency data with 2 decimal places.

Ctrl + Shift + ~ : General numeric data format

Ctrl + Shift + % : Format a percentage data with no decimal places.

Ctrl + Shift + # : Format date data in date, month and year order.

Ctrl + Shift + @ : Format time data in chronological order and use AM and PM distinguished.

Ctrl + Shift + ! : Number format takes 2 decimal values and uses "-" for negative values.

F4: Repeat the last format.

3. Data editing shortcuts

Ctrl + Z : Return to the previous operation.

Ctrl + Y : Go to the previous action.

Ctrl + C : Copy contents of selected cell.

Ctrl + X : Cut content of selected cell and save to clipboard.

Ctrl + V : Paste content from the clipboard into the selected cell.

Ctrl + Alt + V : Select the type of data paste in the Paste Special dialog box.

Data-manipulation keyboard shortcuts:

F2: Allows editing a data cell with the mouse cursor at the end of the line.

Alt + Enter : Down 1 new line in the same cell.

Enter: Complete the data entry into a cell and move up to the cell below that cell.

Shift + Enter : Complete the data entry into a cell and move up the cell above the cell.

Tab / Shift + Tab : Complete entering data at that cell and move to the left or right cell of that cell.

ESC : Cancel all operations in one cell.

BackSpace : Delete the character to the left of the mouse cursor.

Delete : Delete the character to the right of the mouse cursor.

Ctrl + Delete : Delete text content to the end of the line.

Ctrl + ; (semicolon): Insert the current date at the mouse cursor position.

Ctrl + Shift + : (colon): Insert the current time.

Ctrl + D : Copy content in the box above.

Ctrl + R : Copy cell to the left.

Ctrl + " : Copy the content of the cell above and allow editing.

Ctrl + ' : Copy the formula of the cell above and put it in the editing state.

Ctrl + - : Display the delete row and column menu.

Ctrl + Shift + + : Display the menu insert rows and columns.

Shift + F2 : Insert or edit a Comment.

Shift + F10 , then press m: Delete Comment.

Alt + F1 : Create and insert a chart on the current page.

F11 : Create and insert a chart in another sheet.

Ctrl + K : Insert a link.

Enter (in a cell containing a link): Open the link in the link.

4. Navigation shortcuts in spreadsheets

Page Down / Page Up : Move to the bottom or the top of the worksheet.

Alt + PageDown / Alt + PageUp : Move the screen left or right of the worksheet.

Tab / Shift + Tab : Move a cell to the right or left of the worksheet.

Ctrl + Arrow key: Move to the cells next to the data area.

Home : Move to the first cell of a row.

Ctrl + Home : Move to the first cell of the worksheet.

Ctrl + End : Move to the last cell of the worksheet.

Ctrl + F : Display the Find and Replace dialog box in search mode.

Ctrl + H : Display the Find and Replace dialog box in search and replace mode.

Shift + F4 : Repeat the previous search.

Ctrl + G (Or F5 ): Display the Goto dialog box.

Ctrl + right arrow key or Ctrl + left arrow key: Move to the cell to the right or to the left.

Alt + Down arrow: Display the AutoComplete list.

5. The shortcut to insert formulas in Excel

Alt + = : Insert the formula for calculating AutoSum.

Shift + F3 : Display the Insert Function dialog box.

Ctrl + A : Display the input method after entering the formula name.

Ctrl + Shift + A : Insert the arguments of the formula.

Ctrl + Shift + Enter : Enter a formula as an array formula.

F4 : Convert cell address to absolute address.

F9 : Calculate all tables in spreadsheets.

Shift + F9 : Calculate the active worksheet.

Ctrl + Shift + U : Switch mode to expand or collapse the toolbar.

Hope these keyboard shortcuts are useful in your work. Good luck!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

List of common shortcuts for Google Sheets on Android (Last part)
the interface and working style of google sheets is similar to excel, even simpler. using keyboard shortcuts helps you enter table data smarter and faster.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts
keyboard shortcut in excel, how to delete lines in excel with keyboard shortcuts. normally, when working with excel if you want to delete a certain line, you will select all the rows then right-click and select delete. but instead of manipulating the mouse you have t
Pubg keyboard shortcuts - All the Pubg keyboard shortcuts you need to know
pubg keyboard shortcuts - all the pubg keyboard shortcuts you need to know. to become a professional gamer and survive in the world of pubg (playerunknowns battlegrounds), in addition to the powerful configuration computer, the keyboard, the correct mouse, the shortcut keys for quick operation are quite important for each gamer.
Useful keyboard shortcuts in Microsoft Word (Part 2)
tips make introduce to you how to use the shortcut set with the f key from f1, f2, f3, ..., f12 with detailed explanation, easy-to-understand illustrations.
How to use keyboard shortcuts when Paste Value in Excel?
how to use keyboard shortcuts when paste value in excel? here is a summary of keyboard shortcuts when paste value in excel, how to use keyboard shortcuts when paste value in excel, invite you to track.
Keyboard shortcuts in Excel 2007, 2013, 2016, 2010, 2003, 2019, 2021
when working with excel, using shortcuts not only saves time but also improves work efficiency. taking advantage of basic and advanced shortcuts in excel helps you perform operations more quickly and efficiently, from copying data to formatting cells and tables.
Summary of 60+ latest keyboard shortcuts on Windows computers
the tips for using shortcuts super fast on windows computers. quick guide on how to use simple and easy to understand keyboard shortcuts. let's find out together now!
How to change keyboard shortcuts in Photoshop
adobe photoshop allows you to change keyboard shortcuts related to any function of the application. this article will show you how to change keyboard shortcuts in photoshop on windows and mac, as well as how to reset keyboard shortcuts to their default values.
Useful keyboard shortcuts in Microsoft Word (Part 3)
to continue the previous post, tips make would like to summarize for you how to use the shortcut keys with the f key from f7, f8, ..., f12 with detailed explanation, easy-to-understand illustrations.
MathType keyboard shortcuts - All MathType keyboard shortcuts you need to know
for math students and teachers, mathtype is an indispensable software in computers. to edit in mathtype quickly and effectively, we should use the shortcut on mathtype and readers, please refer to the keyboard shortcuts on mathtype summarized in the article below!