Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I resize a worksheet that's stuck on 65,000 rows?
9 views
Skip to first unread message
JRExcelUser
Dec 10, 2007, 7:25:01 PM12/10/07
to
No matter how much I use the delete function, my worksheet is convinced it
has 65,000 rows. This takes up memory and is a pain to navigate. How do I
get rid of everything below the first couple of hundred rows?
has 65,000 rows. This takes up memory and is a pain to navigate. How do I
get rid of everything below the first couple of hundred rows?
carlo
Dec 10, 2007, 7:32:54 PM12/10/07
to
Excel is built up like that, it always has 65536 rows (except excel
2007 which has a lot more!)
If you don't want to see the rows below, hide them. Select them, right
click --> hide.
2007 which has a lot more!)
If you don't want to see the rows below, hide them. Select them, right
click --> hide.
hth
Carlo
On Dec 11, 9:25 am, JRExcelUser
Gord Dibben
Dec 10, 2007, 7:37:56 PM12/10/07
to
Select row 201 then SHIFT + End + DownArrow.
Edit>Delete>Entire Rows.
Same for columns to the right of used data range.
NOW....Important point.
SAVE the workbook.
In older versions you had to save, close and re-open to see the new range.
Gord Dibben MS Excel MVP
0 new messages