LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default "Last Cell" to find last row, but can't delete blank rows

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I delete blank rows from excel without selecting them? rgtest Excel Worksheet Functions 9 February 14th 09 03:12 PM
Find & delete rows with ID's from another sheet. plys Excel Discussion (Misc queries) 1 December 21st 06 04:21 PM
Using COUNTIF to search for existence Epinn Excel Worksheet Functions 31 October 27th 06 04:57 AM
select and delete all blank rows Bill from UniqueAuction.com Excel Discussion (Misc queries) 1 October 11th 05 09:06 PM
I want to delete multiple blank rows from a spreadsheet Sharon43 New Users to Excel 2 October 8th 05 12:44 AM


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"