How to delete multiple rows or columns in Microsoft Excel at once

Microsoft Excel is a spreadsheet application for organizing, formatting, and calculating data with formulas. It is a part of the Microsoft office and exists from the early days of Windows. It is a powerful tool used by numerous business organizations to manage their financial data. Moreover, the application provides a wide range of features and functionality in the app. Features such as Calculation, graphing tools, pivot tables, and macro programming using VBA makes the application standout between others spreadsheet and data entry applications.

Excel allows users to perform a wide variety of tasks manually or by using programs to organize the data. It allows users to edit multiple Rows and Columns in Microsoft Excel at once. Even more, you can also delete multiple rows and Columns in your word table. Here we are discussing the easy method to delete multiple columns and rows in MS Excel word table.

How to delete multiple rows or columns in Microsoft Excel at once

How to delete multiple rows or columns in Microsoft Excel at once

Method 1. Deleting Rows or Columns using Contextual Menu

Step 1) Select the rows and columns that you want to delete by left mouse clicks.

Step 2)After the rows and columns are selected right-click on your mouse. A menu will appear, select Delete Rows, and the rows will be deleted.

Advertisements

Step 3) You can also delete rows and columns using the menu bar, click on the Layout tab, and click on the Delete option at the rightmost corner of the window. You can select delete Rows or Delete Columns accordingly. Moreover, you can delete the entire table from here.

Method 2. Using shortcuts and putting Unnecessary Rows and Columns Together

You can organize all the rows and columns that you want to delete in one place or together, and then you can select them all in once and use the shortcut key to delete it.

Step 1) Firstly, select the rows or columns that you want to delete, then click mouse and hold on, release it to a proper position where you will be gathering the rest of the rows and columns that you are gonna delete. Do the process again with all the rows and columns that you want to delete and gather it all in one place.

Advertisements

Step 2) Now, you will have to select all the rows and columns, therefore, left-click and drag your mouse to select.

Step 3) To delete the rows and columns, you can just use the shortcut key Backspace on your keyboard, or you can right-click and select delete rows. Moreover, you can also delete it from the layout menu.

Method 3. Run Macro to Delete multiple Rows and Columns

Step 1) Firstly, select the rows that you want to delete then press Alt+F11 to open the VBA editor.

Advertisements

Advertisement

Step 2) Click on the Normal project to create a module and then click on the Insert option from the menu bar and select Module.

Step 4) Open the module and paste the following code. Press  F5 or hit Run to run the code, this will delete the rows and columns.

Conclusion

Knowing how to delete multiple rows or columns in Microsoft Excel at once can be an easy and interesting trick up your sleeve. Not only will it save you time, but it will also boost your productivity. We have more of such nice tricks in our PC tips and tricks section, and you may check it out.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.