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

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)



"Dupie1" wrote in message
...
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

Select all the rows below your data and EditDelteEntire Rows.

Do same for columns to the right of your data.

IMPORTANT step now.

Save the workbook.


Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 09:00:01 -0700, Dupie1
wrote:

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