| 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 | |||
Linear Mode
