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

  • Thread starter Thread starter castruck
  • Start date Start date
C

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
 
(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
Click to expand...

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.
 
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
 
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
 
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
 
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
Click to expand...
....

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have more than 65K rows when I open Excel 2007 2
how do I combine multiple worksheets into one? not summarize 1
Export 65k+ file 9
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Text import/ Text to Column 7
Query not returning all the rows 8
How can I surpass/modify the Excel limit of 65k rows? 1
Excel Cannot delete empty cells/rows 4

Back
Top