By learning how to delete every other row in Google Sheets is useful when you want to delete rows quickly and not manually or manipulate the data by deleting certain rows.
This tutorial is to teach you to delete and hide every other row in Google Sheets by using the filter tool.
The filter tool can not only assist us to deleting every other row, but it can also use advanced formulas to delete every third, fourth, or Nth row in a dataset.
Table of Contents
Deleting Every Other Row in Google Sheets Using the Filter Tool
It is really simple to delete every other row in Google Sheets. We would simply use the filter tool to hide either the even or odd-numbered rows.
Lets use an example to show you what we mean!
As you can see, the filter has to hide every other row that is even-numbered. Another thing to take note of is that the formula we input in filters the rows that are even-numbered instead of the data that are even-numbered.
Here is a breakdown of the formula we used in the formula.
So together, the formula will help us to hide all even-numbered rows.
Deleting Every Nth Row in Google Sheets Using the Filter Tool
Other than deleting or hiding every other row in Google Sheet, you can also use another formula in the filter tool to delete or hide every third, fourth or fifth row.
This formula is a bit more complex than the previous formula. However, it is also very customizable.
Lets use the same database as Example 1 to show how this can be achieved.
So instead of inserting the previous formula into the filter tool, we would be using the MOD function.
You can see that the highlighted rows are now missing, meaning the formula inputted in the filter tool works!
Lets have a better understanding of what the formula does.
You may make a copy of the spreadsheet using the link attached below and try it for yourself:
Make a copy of example spreadsheet
As simple as that! You can now hide or delete every other row in Google Sheet by following the steps above.
Dont be afraid to play with the formulas. With little modification, you can also customize the formula in the way you prefer!
Get emails from us about Google Sheets.
Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'll love what we are working on! Readers receive early access to new content.