Formatting worksheet

[asaini]

I have a worksheet with 30,000 rows. But sometimes even if I have fewer records in this worksheet(lets say 1000) worksheet shows the same 30,000 rows.And its annoying when you try to navigate using vertical scroll bar. Is there any option to re-adjust the worksheet to make it more user friendly based on number of rows in current sheet.

[Leith Ross]

Hello asaini,

If you have copied formulas down to row 30000, Excel will mark your used range to this point, even if the formulas don't show anything. Aside from removing the unused formulas and saving the worksheet, I don't know of any other way to reset the used range.

Sincerely,
Leith Ross

[asaini]

thanx Leith