Lenght of sheets

[Dupie1]

In Excel 2002 I have a workbook with 12 sheet. One ended up with > 45,000
rows. The scroll bar on this sheet is tiny compared to the other sheets. Is
there a way to set the lenght of the sheets to a specific number of rows.

Thanks

 

[Bob Phillips]

You could always hide rows 1,000-65536 I guess.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

Select all the rows below your data and Edit>Delte>Entire Rows.

Do same for columns to the right of your data.

IMPORTANT step now.

Save the workbook.


Gord Dibben MS Excel MVP