Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I resize a worksheet that's stuck on 65,000 rows?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I resize a worksheet that's stuck on 65,000 rows?
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. hth Carlo On Dec 11, 9:25 am, JRExcelUser wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I resize a worksheet that's stuck on 65,000 rows?
Select row 201 then SHIFT + End + DownArrow.
EditDeleteEntire 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 On Mon, 10 Dec 2007 16:25:01 -0800, JRExcelUser wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
I'm stuck on and "function Activities" worksheet its due on MONDAY PLEASE HELP, | Excel Worksheet Functions | |||
How do I resize a worksheet after deleting rows? | Excel Discussion (Misc queries) | |||
How can I resize columns and rows to inches? | Excel Discussion (Misc queries) | |||
resize worksheet | Excel Worksheet Functions |