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
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.
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.
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.
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.
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.