microsoft excel shortcut keys delete row

Thus, the article has shared with you two shortcut key combinations that help you delete one or more lines quickly. So the lines you choose will also be deleted. Corresponding to the keyboard shortcut Alt + H -> D -> R is you choose Home -> Delete -> Delete Sheet Rows. Next select the D key, select the R key on the keyboard. Instead of choosing the Ctrl + - shortcut, you can use the shortcut Alt + H to open the Home tab shortcut.

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. Press Ctrl + minus key ( Ctrl + - ) to delete the lines you have selected, immediately the lines you selected will be deleted. Step 2: Delete the selected line with the shortcut. If you want to delete multiple non-consecutive lines, hold down Ctrl and select the lines to delete. 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. Or you quickly select the line containing the cell you are selecting and press the key combination Shift + Space.

Select the mouse in the beginning of the box to select all lines. Here's how to delete lines in Excel with keyboard shortcuts, invite you to follow. So which shortcut keys can delete lines in Excel, let's find out in the article below.

But instead of manipulating the mouse, you can use keyboard shortcuts to quickly delete the line in Excel. 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.

Microsoft excel shortcut keys delete row