• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
How to Erase Multiple Excel Rows Simultaneously

How to Erase Multiple Excel Rows Simultaneously

By Judy Sanhz Leave a Comment

You can probably think of various reasons as to why you use Excel. Whether it’s a project for work or not, Excel just helps you organize your data better.

Since mistakes will happen, you’ll surely need to erase data on your Excel document. For those times when you have to delete a lot, it’s best to erase more than one row at a time, but how?

How to Erase More than One Excel Row at a Time

A quick way to erase multiple Excel rows is by right-clicking on cells A1 (for example) and dragging your mouse until all the cells you want to delete is selected.

Right-click anywhere in the selected area, and when the side-menu appears, place the cursor on Delete. A new side-window will appear; here is where you choose what you want to delete exactly.

Or, if you prefer, you can click on the Delete option’s drop-down menu at the top right and choose the choice of your interest.

How to Erase Excel Rows with a Keyboard Shortcut

If you prefer to erase Excel rows with a keyboard shortcut, you can try pressing the Ctrl + minus keys. When the window appears, choose the Entire row option, followed by OK.

How to Erase Multiple Excel Rows Using Macros

To erase Excel rows by using Macros, you-ll need to press the Alt + F11 keys. In the new window, click on the Insert tab, followed by the Module option.

Now it’s time to paste the following:

Sub DeleteEntireRow()
Rows(1).EntireRow.Delete
Rows(3).EntireRow.Delete
Rows(5).EntireRow.Delete
End Sub

The rows that the module will delete will depend on the ones you want to erase. Make sure to make those changes in the data above after you paste it.

Save the Macros and now go back to your Excel document and click on the View tab. To the right, click on the Macros drop-down menu and click on View Macros.

When the Macro window appears, it will indicate that it’s to erase the Excel rows, Click on Run, and the rows will be erased.

Conclusion

The first option is the easiest and fastest way to erase various Excel rows at the same time, but it’s always good to know more ways just in case the first ones fail. Which option are you going to go with?

You Might Also Like

  • How to Rename Multiple Windows 10 Files Simultaneously
    How to Rename Multiple Windows 10 Files Simultaneously
  • Excel 2016: Unhide Rows or Columns
    Excel 2016: Unhide Rows or Columns
  • Freeze or Unfreeze Panes, Columns, and Rows in Excel
    Freeze or Unfreeze Panes, Columns, and Rows in Excel
  • How to Mute Everyone Simultaneously on Zoom
    How to Mute Everyone Simultaneously on Zoom
  • Chrome: How to Refresh Various Tabs Simultaneously
    Chrome: How to Refresh Various Tabs Simultaneously
  • Hide and Unhide Rows and Columns in Google Sheets
    Hide and Unhide Rows and Columns in Google Sheets
  • How to Resize Multiple Images at Once
    How to Resize Multiple Images at Once
  • How to Record Multiple Snaps in SnapChat
    How to Record Multiple Snaps in SnapChat
  • How to Open Multiple Programs With 1 Shortcut
    How to Open Multiple Programs With 1 Shortcut

Filed Under: Office Tagged With: Excel

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Recent Posts

  • How to Add a Hyperlink in Excel
  • What Are The Different Types Of DDR?
  • What Is Non-Volatile Memory?
  • SATA: What It Is and What You Need to Know
  • SLC vs MLC vs TLC vs QLC vs PLC
  • What is SLC Caching?
  • What Is Host Memory Buffer (HMB) in SSD?
  • DRAM on an SSD: Is It Something You want?

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2022 Technipages · All Rights Reserved · Privacy