Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows to resize workspace
Hi. I'm using a workbook that someone else created from a download. It has
23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it appear that it's only 10% from the top. In the past I've deleted all of the rows - going down to the full million - and then gone back to A1 and hit "save". Usually that refreshes the space. It's not working. I can delete them. And go to A1 and save - even tried resaving with another name.. but it (Excel) still thinks it's bigger than it is. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows to resize workspace
Usually that technique works.
Debra Dalgleish documents it he http://contextures.com/xlfaqApp.html#Unused But I've seen times where it doesn't work. If it really bothers me, I'll create a new worksheet and copy|paste just the data/formulas/headers/names/formatting (all that stuff) to a new sheet. Then I'll check it by hitting ctrl-end (to get to what excel thinks is the last used cell). Then I delete the original sheet. Be careful if you have formulas that point to that sheet to be deleted. You may have more work to do first! beata wrote: Hi. I'm using a workbook that someone else created from a download. It has 23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it appear that it's only 10% from the top. In the past I've deleted all of the rows - going down to the full million - and then gone back to A1 and hit "save". Usually that refreshes the space. It's not working. I can delete them. And go to A1 and save - even tried resaving with another name.. but it (Excel) still thinks it's bigger than it is. Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I resize a worksheet that's stuck on 65,000 rows? | Excel Worksheet Functions | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
Workspace & Links referenced when workspace opened. | 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) |