• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

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

How to Erase Multiple Excel Rows Simultaneously

Posted on June 4, 2020 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

  • Excel 2016: Unhide Rows or ColumnsExcel 2016: Unhide Rows or Columns
  • Freeze or Unfreeze Panes, Columns, and Rows in ExcelFreeze or Unfreeze Panes, Columns, and Rows in Excel
  • Hide and Unhide Rows and Columns in Google SheetsHide and Unhide Rows and Columns in Google Sheets
  • How to Resize Multiple Images at OnceHow to Resize Multiple Images at Once
  • Wii: Erase All DataWii: Erase All Data
  • How to Record Multiple Snaps in SnapChatHow to Record Multiple Snaps in SnapChat
  • How to Open Multiple Programs With 1 ShortcutHow to Open Multiple Programs With 1 Shortcut
  • Windows 10: How to Print Multiple FilesWindows 10: How to Print Multiple Files
  • How to Manage Multiple Google AccountsHow to Manage Multiple Google Accounts

Filed Under: Office Tagged With: Excel

Reader Interactions

Did this help? Let us know! Cancel reply

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

  • WhatsApp Self-Destructing Messages: What You Need to Know
  • Spotify: How to Merge Playlists
  • Google Duo on Android: How To Add Automatic Captions To Video and Audio Messages
  • Slack: How To Disable Notifications for Threads You’re Following
  • Slack: How To Configure Your Status
  • Google Duo: How To Prevent Other People From Seeing Your Video Before They Pick up Your Call
  • Slack: How To Configure Notification Keywords
  • How to Tell If Your Phone Is Dual-SIM

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.

Follow me on Twitter, or visit my personal blog.

You May Also Like

© Copyright 2021 Technipages · All Rights Reserved · Privacy