number of rows

[Guest]

I used autoformat so that my rows would alternate colors. But, it added a
bunch of empty rows so that the sheet is maxed out and my file is huge. I
don't need all those empty rows and I can't find a way to delete them. Any
suggestions for how to get rid of the rows, or limit the number of rows on a
worksheet?

I know I could copy all the data to a new worksheet, but I'd like a better
solution.

 

[Richard O. Neville]

Try this: click on the number of the first empty row, so the whole row is
selected. Using the vertical scrollbar, go to the last row on the sheet.
Hold down the shift key while you click on this row's number. You should now
have selected all the empty rows.

Then press Ctrl and - (the minus sign on the numeric keypad). This should
delete all the formatted rows and replace them with unformatted rows.

 

[Gord Dibben]

You will always have 65536 rows and 256 columns.

These cannot be deleted.

You could hide what you don't want, but they will still be there.

You can limit the Scroll Area using VBA.

Gord Dibben Excel MVP