I have a small but annoying issue with some of my worksheets. I have copied
and pasted large volumes of data from one worksheet to another and removed
data in rows that I don't need. I am now left with a worksheet that has a
tiny vertical scroll bar indicating that the sheet has 60,000+ rows. Is it
possible to reset this scroll bar as it appears to vastly increase the file
size?

Rodders, See Debra Dalgleish's suggestions for resetting the Used Range:
http://www.contextures.com/xlfaqApp.html#Unused


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Rodders" wrote in message
...
I have a small but annoying issue with some of my worksheets. I have
copied
and pasted large volumes of data from one worksheet to another and removed
data in rows that I don't need. I am now left with a worksheet that has a
tiny vertical scroll bar indicating that the sheet has 60,000+ rows. Is it
possible to reset this scroll bar as it appears to vastly increase the
file
size?

Thanks for your help Paul B. It hit the nail on the head.

"Paul B" wrote:

Rodders, See Debra Dalgleish's suggestions for resetting the Used Range:
http://www.contextures.com/xlfaqApp.html#Unused


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Rodders" wrote in message
...
I have a small but annoying issue with some of my worksheets. I have
copied
and pasted large volumes of data from one worksheet to another and removed
data in rows that I don't need. I am now left with a worksheet that has a
tiny vertical scroll bar indicating that the sheet has 60,000+ rows. Is it
possible to reset this scroll bar as it appears to vastly increase the
file
size?