Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Decrease size of a worksheet so it has fewer than 64,000 rows?
I do not need for the worksheet to be so big. How do I decrease the size, not
just delete the data from the rows. |
#2
|
|||
|
|||
sophy
A worksheet has 65536 rows and 256 columns, no less and no more. You can hide the rows and columns you don't use, but they will still be there. Gord Dibben Excel MVP On Wed, 28 Sep 2005 14:14:01 -0700, sophy2 wrote: I do not need for the worksheet to be so big. How do I decrease the size, not just delete the data from the rows. |
#3
|
|||
|
|||
If you or someone accidentally entered information in the last row or so you
could have a file that is unnecesarily bloated. I have people who do that all the time. Just delete all the rows from your last real row to the end of the sheet, and save. You will see blank rows, but they are truly blank. When you are in the last row of your information your scroll bar should be at the bottom. "Gord Dibben" wrote: sophy A worksheet has 65536 rows and 256 columns, no less and no more. You can hide the rows and columns you don't use, but they will still be there. Gord Dibben Excel MVP On Wed, 28 Sep 2005 14:14:01 -0700, sophy2 wrote: I do not need for the worksheet to be so big. How do I decrease the size, not just delete the data from the rows. |
#4
|
|||
|
|||
I have done that, but the scroll bar at the right is still at the very top
since it thinks it has to scroll all the way to 64,000. Any way to reset it? I have reset the print area, but that has not helped. Thanks! "widman" wrote: If you or someone accidentally entered information in the last row or so you could have a file that is unnecesarily bloated. I have people who do that all the time. Just delete all the rows from your last real row to the end of the sheet, and save. You will see blank rows, but they are truly blank. When you are in the last row of your information your scroll bar should be at the bottom. "Gord Dibben" wrote: sophy A worksheet has 65536 rows and 256 columns, no less and no more. You can hide the rows and columns you don't use, but they will still be there. Gord Dibben Excel MVP On Wed, 28 Sep 2005 14:14:01 -0700, sophy2 wrote: I do not need for the worksheet to be so big. How do I decrease the size, not just delete the data from the rows. |
#5
|
|||
|
|||
I am not an Excel expert...but I think..
you may have accidentally key something into a cell at the far bottom. It could be just a " ' " which is invisible. Suggest you go to last cell of every column that has an entry, press 'End' and then 'down arrow'. If there is an entry somewhere down there, the cursor will stop at that cell. Repeat for every column until you find which cell has the hidden entry. Delete that entry. hth. "sophy2" wrote in message ... I have done that, but the scroll bar at the right is still at the very top since it thinks it has to scroll all the way to 64,000. Any way to reset it? I have reset the print area, but that has not helped. Thanks! "widman" wrote: If you or someone accidentally entered information in the last row or so you could have a file that is unnecesarily bloated. I have people who do that all the time. Just delete all the rows from your last real row to the end of the sheet, and save. You will see blank rows, but they are truly blank. When you are in the last row of your information your scroll bar should be at the bottom. "Gord Dibben" wrote: sophy A worksheet has 65536 rows and 256 columns, no less and no more. You can hide the rows and columns you don't use, but they will still be there. Gord Dibben Excel MVP On Wed, 28 Sep 2005 14:14:01 -0700, sophy2 wrote: I do not need for the worksheet to be so big. How do I decrease the size, not just delete the data from the rows. |
#6
|
|||
|
|||
sophy
I should have addressed this in my first post. See Debra Dalgleish's site for instructions on how to reset the used range of a sheet. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben Excel MVP On Thu, 29 Sep 2005 04:22:02 -0700, sophy2 wrote: I have done that, but the scroll bar at the right is still at the very top since it thinks it has to scroll all the way to 64,000. Any way to reset it? I have reset the print area, but that has not helped. Thanks! "widman" wrote: If you or someone accidentally entered information in the last row or so you could have a file that is unnecesarily bloated. I have people who do that all the time. Just delete all the rows from your last real row to the end of the sheet, and save. You will see blank rows, but they are truly blank. When you are in the last row of your information your scroll bar should be at the bottom. "Gord Dibben" wrote: sophy A worksheet has 65536 rows and 256 columns, no less and no more. You can hide the rows and columns you don't use, but they will still be there. Gord Dibben Excel MVP On Wed, 28 Sep 2005 14:14:01 -0700, sophy2 wrote: I do not need for the worksheet to be so big. How do I decrease the size, not just delete the data from the rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
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) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |