HI Linda, Yep, I thought by highlighting the cells from my last active cell to the end of the spreadsheet would have fixed it, but it didn't...lol. That's when my curiosity got piqued, and I figured there must be a way to do this. I had already cheated, I had copied what I wanted and already saved the file under a new filename, which did work. But, as I said, I was curious, and feel there probably is a way of achieving the resizing of the vertical scroll bar somehow within the actual program. Thanks for the replies! That Guy In Africa... http://homepages.gds.co.za/northcom/ ******************************************** ICQ# 39461303 ~ Greetings from Sunny South Africa ~ ******************************************** -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Linda Johnson Sent: 16 May 2002 10:07 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel Scroll Bar Oh...I misunderstood, Eric....if your scroll bar is indicating you have a huge file and you don't, that means Excel thinks you have something in a cell waaaaaaaayyyy down.....and you might or might not (Excel considers a space in a cell as something) When you hit ctrl+end, where does Excel jump to? If it's a cell that's way past the end of your actual data, then this is what's happening Just highlight all the cells from the end of your data up to and including the cell that Excel sees as the end of your data and go to the Edit menu and choose Clear>All....if that doesn't fix it, then highlight your data and copy/paste it into a new workbook and that should fix it Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com/main.htm Author/Teacher ~ MS Office EBooks/Classes http://personal-computer-tutor.com/services.htm -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Eric Skeen Sent: Thursday, May 16, 2002 3:12 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel Scroll Bar Thanks Linda, I have been doing that, but just wondered out of curiosity if there is a way of "re-setting" the vertical scroll bar. I simply hate it when the scroll bar indicates a massive file when the file is not that large. Curiosity killed the cat... ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso ************************************************************* --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.362 / Virus Database: 199 - Release Date: 2002/05/07 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.362 / Virus Database: 199 - Release Date: 2002/05/07 ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso *************************************************************