Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last Cell" to find last row, but can't delete blank rows
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |