Thread
:
"Last Cell" to find last row, but can't delete blank rows
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
"Last Cell" to find last row, but can't delete blank rows
SAVE
--
Don Guillett
SalesAid Software
" wrote in
message ...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett