Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reset Worksheet Size
How can I reset the size of a spreadsheet?
If if hit 'end' 'home' it goes to g1000. The data I need is a1 to g700. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reset Worksheet Size
What is after G700, just blanks? If your meangingful data ends at G700 and
there is nothing after that you could delete all the rows between G700 and G1001, this should get rid of cells with blank spaces in them and then the end of your sheet should be at G700. "Wade" wrote: How can I reset the size of a spreadsheet? If if hit 'end' 'home' it goes to g1000. The data I need is a1 to g700. thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reset Worksheet Size
Whenever you save an Excel file, it will re-determinethe the "last" cell
used. Excel will continually expand your range of used cells as you add more data, but will not retract that range if data is deleted, until the file is saved. HTH, Elkar "Wade" wrote: How can I reset the size of a spreadsheet? If if hit 'end' 'home' it goes to g1000. The data I need is a1 to g700. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can the default size of an excel 2000 worksheet be changed? | Excel Discussion (Misc queries) | |||
HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS | Excel Worksheet Functions | |||
Modify cell size in worksheet | Excel Worksheet Functions | |||
How do I apply a default size to all comments in Excel worksheet? | Excel Discussion (Misc queries) | |||
Can I split my worksheet and have different size columns and rows. | Excel Discussion (Misc queries) |