Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
Look he
http://www.contextures.com/xlfaqApp.html#Unused -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message oups.com... |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 | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
On Aug 7, 10:09 am, "Niek Otten" wrote:
Look he http://www.contextures.com/xlfaqApp.html#Unused -- Kind regards, Niek Otten Microsoft MVP - Excel Im giving that a try now.. but its taking a very long time for it to delete the 65k rows |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
well that didnt work =( all 65k rows are still showing
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
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 -- Regards, Peo Sjoblom wrote in message oups.com... well that didnt work =( all 65k rows are still showing |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
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 On Tue, 07 Aug 2007 10:25:22 -0700, wrote: well that didnt work =( all 65k rows are still showing |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i get the 65k of rows to go away??
wrote...
.... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |