Google Answers Logo
View Question
 
Q: How can I resize a spreadsheet in Excel? ( No Answer,   4 Comments )
Question  
Subject: How can I resize a spreadsheet in Excel?
Category: Computers > Software
Asked by: fieldlily-ga
List Price: $5.00
Posted: 26 Jan 2006 15:14 PST
Expires: 25 Feb 2006 15:14 PST
Question ID: 438080
This is a totally trivial problem but it's making me crazy. I'm
working with a number of very long lists in Excel, and every time I
open one, the spreadsheet is about 70000 cells long, no kidding. So
the scrollbar is basically dysfunctional; the slightest move of the
scrollbar makes it hop about 500 cells. I've tried deleting rows and
trying to format the spreadsheet. Can a more experienced Excel user
help me out?

Thanks so much,

lotf629

Request for Question Clarification by pafalafa-ga on 26 Jan 2006 16:05 PST
I don't have Excel right in front of me now, but I think that if you
highlight the range you're working with, and save just the range as a
file, then it will open up with just the resized dimensions.

Try it, and let me know what happens,

pafalafa-ga

Clarification of Question by fieldlily-ga on 10 Feb 2006 12:44 PST
Hi everybody,

Sure it's obvious, Rajesh, but also maddening. :) It just occurred to
me that I had to clarify something important. The lists I am using are
only 5000-6000 cells long. The bottom 60,000 cells or so are totally
empty, but even when I delete them, the spreadsheet doesn't resize.

I've had some good luck figuring out ways to work around the fact that
the spreadsheet is 70,000 cells long--thank you all!--but am still
looking for a way to get rid of these tens of thousands of empty
cells.

Thanks again everybody,

lotf629

Request for Question Clarification by pafalafa-ga on 10 Feb 2006 13:04 PST
I'm not sure if you saw my Jan 26 comment (above) about saving the range?


Did you try it?  What happened?

paf

Request for Question Clarification by hummer-ga on 11 Feb 2006 20:04 PST
Hi fieldlily,

Perhaps this will work?

How to reset the last cell in Excel
Method 1
"To reset the last cell by manually deleting excess rows and columns."
Method 2
"An Excel add-in to remove excess formatting and reset the last cell
is now available for download."
http://support.microsoft.com/?kbid=244435

Good luck,
hummer
Answer  
There is no answer at this time.

Comments  
Subject: Re: How can I resize a spreadsheet in Excel?
From: rainbow-ga on 26 Jan 2006 15:58 PST
 
This may help:

http://www.cpearson.com/excel/deleting.htm

Best regards,
Rainbow
Subject: Re: How can I resize a spreadsheet in Excel?
From: nelson-ga on 26 Jan 2006 16:15 PST
 
Don't move the scroll bar.  Click below it instead.
Subject: Re: How can I resize a spreadsheet in Excel?
From: r_a_j_e_s_h-ga on 02 Feb 2006 22:54 PST
 
Hi,
   It is obvious the excel will move 500 rows when u move the
scrollbar in the excel sheet which has 70,000 cells.

   you can try the "goto" optiin in the excel to work around that excel sheet.
that "Goto" option is located under "Edit" Menu.

if u want to goto a cell A20, then type A20 in that and u will be
moved to that cell. It also has more features like going to the last
cell, etc...

hope this will help you

regards,
Rajesh
Subject: Re: How can I resize a spreadsheet in Excel?
From: pafalafa-ga on 10 Feb 2006 13:04 PST
 
I'm not sure if you saw my Jan 26 comment (above--in "Clarifications"
section) about saving the range?


Did you try it?  What happened?

paf

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy