Select C2, enter ‘=MOD(ROW(),2)’ in the fx bar and press the Return key. To add filters to the spreadsheet table, press the Ctrl + Z hotkey to undo the earlier erasing of the third, fifth and seventh rows. You’ll use this column to hold the numbers that will indicate whether the row is one that will be deleted or one that will be kept. When deleting rows, you can filter out those you need to keep and quickly select the ones to erase. To set up filters, you’ll need to add an extra table column. Excel’s filtering tool enables you to filter out columns from spreadsheet tables. The above technique works fine for small tables, but what if your table has 600 rows? Or 6000? Or 600,000? It would take forever and a day to get all those rows selected, and the first mis-click would force you to start the process all over!įor larger tables, there’s a powerful way to delete rows using the Filter tool. Let’s get started!ĭelete Every Other Row with Excel’s Filter Tool Then you can decide for yourself which technique is most suitable for your immediate need.
#How to delete a header from excel how to
In this article, I’ll show you how to use each one of these techniques. The second way is to use Excel’s Filter tool, and the third way is to use an Excel add-on. While cumbersome and possibly time-consuming, this might be the right approach if your table is very small. The first way is to manually select and delete the rows you want to get rid of. There are three basic ways of accomplishing this task. We’ve written several articles showing you some of these power techniques, like this article on how to swap columns. In this article, I’m going to show you how to delete rows – specifically, how to delete every other row, in Excel.
There are a lot of common “power user” tasks that people need to learn how to accomplish in order to get the most out of the tool.
Excel is a powerful spreadsheet that many people use to organize and analyze information.