Excel shortcuts

How to Delete Multiple Rows in Excel: The Ultimate Keyboard Shortcut Guide

Deleting multiple rows in Excel can be a tedious task, especially if you have a large worksheet. But there's a keyboard shortcut that can help you quickly delete multiple rows. Here's a step-by-step guide on how to use it.

First, select the rows you want to delete. To do this, click on the row number at the left of the screen. Then, press and hold the Shift key on your keyboard, and click on the last row you want to delete. All of the rows between your first and last selection will be highlighted.

Next, press the Ctrl+- keys on your keyboard. This shortcut will delete all of the selected rows.

You can also use this shortcut to delete multiple columns. Simply select the columns you want to delete, and then press the Ctrl+- keys on your keyboard. All of the selected columns will be deleted.

If you want to delete multiple rows or columns at the same time, you can use the Ctrl+Shift+- shortcut. Simply select the rows or columns you want to delete, and then press the Ctrl+Shift+- keys on your keyboard. All of the selected rows and columns will be deleted.

You can also use this shortcut to delete multiple cells. Simply select the cells you want to delete, and then press the Ctrl+Shift+- keys on your keyboard. All of the selected cells will be deleted.

This shortcut is a great time-saver if you need to delete multiple rows, columns, or cells in Excel. Give it a try the next time you need to delete multiple rows in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.