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 can use keyboard shortcuts to quickly delete the line in Excel. So which shortcut keys can delete lines in Excel, let's find out in the article below.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 1
Here's how to delete lines in Excel with keyboard shortcuts, invite you to follow.
Step 1: Select the line to delete.
Select the mouse in the beginning of the box to select all lines.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 2
Or you quickly select the line containing the cell you are selecting and press the key combination Shift + Space.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 3
If you want to delete multiple lines in a row, hold down the Shift key and select the first few boxes in each line to select the lines.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 4
If you want to delete multiple non-consecutive lines, hold down Ctrl and select the lines to delete.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 5
Step 2: Delete the selected line with the shortcut.
Press Ctrl + minus key ( Ctrl + - ) to delete the lines you have selected, immediately the lines you selected will be deleted.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 6
Note: If you want to delete the current row (the row containing the cell you are selecting), then pressing Ctrl + - will bring up a small dialog box, select Entire row and click OK .
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 7
Instead of choosing the Ctrl + - shortcut , you can use the shortcut Alt + H to open the Home tab shortcut .
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 8
Next select the D key, select the R key on the keyboard. Corresponding to the keyboard shortcut Alt + H -> D -> R is you choose Home -> Delete -> Delete Sheet Rows.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 9
So the lines you choose will also be deleted.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts Picture 10
Thus, the article has shared with you two shortcut key combinations that help you delete one or more lines quickly. Hopefully through this article you will remember the shortcut keystrokes to be able to apply them in the process of working with Excel. Good luck!
You should read it
- Insert line shortcut in Excel - Shortcut insert Excel
- Summary of useful keyboard shortcuts in excel
- Merge keyboard shortcuts in Excel
- Keyboard shortcuts in Excel
- Summary of the most useful Excel keyboard shortcuts you should know
- Summary of expensive shortcuts in Microsoft Excel
- 38 Excel keyboard shortcuts, Work with Excel faster
- Summary keyboard shortcuts in Excel
- Some shortcuts in Excel you need to know
- Invaluable keyboard shortcuts in Excel
- List of common shortcuts for Google Sheets on Mac (Part 2)
- Useful keyboard shortcuts in Microsoft Word (Part 3)