"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

"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

"Last Cell" to find last row, but can't delete blank rows
 

Try this:

Edit/Delete rows/columns that you no longer need
Go to cell A1
Save

" wrote:

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

"Last Cell" to find last row, but can't delete blank rows
 

Hi John

Save/Close and reopen after you delete the rows/columns

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


" 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

"Last Cell" to find last row, but can't delete blank rows
 

Sean,
Thanks. I have 5 tabs on this sheet. For 4 tabs the number of rows was
reduced from 5000 to between 480-490 (it varied). For the 5th tab, it stayed
at 5000 rows.

In deleting columns, if I have a VBA instruction that says,e.g., select
columns A thru CZ...so if I say delete all columns Z thru IV, does this
overide the instruction that needs columns A - AZ?

John

"Sean Timmons" wrote:

Try this:

Edit/Delete rows/columns that you no longer need
Go to cell A1
Save

" wrote:

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

"Last Cell" to find last row, but can't delete blank rows
 

Sean, when I use "Delete" instead of "Clear", Tab 5 deletes down to row
486....still a big improvement over 5000 rows!

"Sean Timmons" wrote:

Try this:

Edit/Delete rows/columns that you no longer need
Go to cell A1
Save

" wrote:

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

"Last Cell" to find last row, but can't delete blank rows
 

Ron, that one works pefectly!! Thanks, John

"Ron de Bruin" wrote:

Hi John

Save/Close and reopen after you delete the rows/columns

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


" 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