Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Had a problem w/ speeding up save of an Excel file. Good solutions from
people responding and speed has drastically improved! I was given another suggestion to use Last Cell or Ctrl-End to find the last used cell. I did and found that I had about 10,000 "extra" rows that were all blank and therefore making my file bigger and slower to save. Now I can not delete the extra rows (or columns). I have high lighted the unwanted rows and used both Delete and Clear (to take care of any unknown formatting), but when I try Ctrl-End, I'm right back at row 10,000. As usual, thanks for you help. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Find & delete rows with ID's from another sheet. | Excel Discussion (Misc queries) | |||
Using COUNTIF to search for existence | Excel Worksheet Functions | |||
select and delete all blank rows | Excel Discussion (Misc queries) | |||
I want to delete multiple blank rows from a spreadsheet | New Users to Excel |