How do i get the 65k of rows to go away??

[castruck]

i only have 460 rows of data but the scroll bar goes down all of the
way to 65k of rows... i have highlighted all the rows and pushed
delete then hit save but that didnt work

 

[Harlan Grove]

(e-mail address removed) wrote...

i only have 460 rows of data but the scroll bar goes down all of the
way to 65k of rows... i have highlighted all the rows and pushed
delete then hit save but that didnt work

You could hide the rows you don't need, but worksheets in all Excel
versions from 97 through 2003 (or 2004 for Macs) ALWAYS have 256
columns and 65536 rows. No way to decrease (or increase) that.

 

[Niek Otten]

Look here:

http://www.contextures.com/xlfaqApp.html#Unused

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|i only have 460 rows of data but the scroll bar goes down all of the
| way to 65k of rows... i have highlighted all the rows and pushed
| delete then hit save but that didnt work
|

 

[castruck]

ill try to make the problem more clear..

normaly when i click and hold the scroll bar and bring it all of the
way down it will stop at about row 1400.. and if i hold the down arrow
down it will keep going past 1400

but now its saved so that the scroll bar is really small and when i
bring it all of the way down its at row 65536

this problem is making my save time alot longer.. and i wouldnt care
normally but this is at work and other people use the workbook

 

[castruck]

Look here:

http://www.contextures.com/xlfaqApp.html#Unused

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[castruck]

well that didnt work =( all 65k rows are still showing

 

[Peo Sjoblom]

They will always be showing unless you hide them, the thing is that when you
press ctrl + End
it should just go to the end of the used range so if your last cell with a
values is E455 then it will go to the cell below.
If you have Excel97 you might have to save, close excel and open it again
before it will take effect

 

[Gord Dibben]

The 65536 rows will still be there after deleting and saving.

But..........Your scroll bar should only go down to the bottom of your used
range.

Where does CTRL + End take you?


Gord Dibben MS Excel MVP

 

[Harlan Grove]

normaly when i click and hold the scroll bar and bring it all of the
way down it will stop at about row 1400.. and if i hold the down arrow
down it will keep going past 1400

....

It's your used range. There are some things that affect its size that can't
be reset by deleting rows (AND COLUMNS) outside the used range then saving
the file. Rather than searching for all of them, it's expedient to insert a
new worksheet, CUT what you believe the used range to be, paste it into the
newly inserted worksheet, delete the worksheet that used to contain it, and
finally rename the new worksheet with the newly deleted worksheet's name.
Then perform a full recalc, [Ctrl]+[Shift]+[F9], and check formulas and
defined names in all other worksheets for #REF! errors.