How do you Delete all rows on excel?

Answer 1

it's a pain but depending on the length of the document it may be worth it to make a macro, or make a column to the right of your data with the row numbers 1,2,3... (let auto fill do it), and then make the column next to it be the row number modulo 2 (if i remember right =(XX\2) or =mod(XX,2) where xx is the address of the column with the row number). This will alternate between 0 and 1 for the rows in that second column. Then you can sort that column in ascending/descending order (make sure it sorts the whole sheet and not just the one column) and delete either the 0's or the 1's en masse.

On October 16, 2009 at 03:46 am http://wiki.answers.com/Q/User:Mathuranathan [0] said:

Method to delete alternate rows in MS Excel. (If the alternate rows contain blank data)

1)select the area in which you have the data 2)click Data->Filter->AutoFilter from the Excel menu. 3)you will see a scrollable text box appearing at the first row of your data. Click the scrollbox and select "nonBlanks" (which will be last element in the box). 4)You will see that only those non blank data will be selected. copy those data and paste it to another sheet.

Answer 2

You can do it by selecting more than one sheet. Click on one sheet tab. Then press the Ctrl key and click on another. If you now right click, you can delete the sheets. You can also click on one sheet tab and click on another sheet tab while holding the Shift key. All the sheets between the two will be selected. You can then right click and take the Delete option.

Answer 3

Select all the cells you want to clear and then press the delete key.

Answer 4

Highlight as many rows as you would like to delete and select delete rows.