| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting excess rows from a spreadsheet
Some of my spreadsheets have expanded to over 65,000 rows (I don't know what
causes that). When only the top 500 rows contain data, the vertical scrollbar is practically useless. How can I remove the excess 64,500 rows from the spreadsheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting excess rows from a spreadsheet
Select and delete all rows below and all columns right of your data range.
Do not just "clear contents". Save the workbook to reset the used range. In older versions you had to save, close then re-open to see changes. Gord Dibben MS Excel MVP On Fri, 2 Jan 2009 08:30:02 -0800, TumbleWeed on Platte <TumbleWeed on wrote: Some of my spreadsheets have expanded to over 65,000 rows (I don't know what causes that). When only the top 500 rows contain data, the vertical scrollbar is practically useless. How can I remove the excess 64,500 rows from the spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Excess Rows Again | Excel Discussion (Misc queries) | |||
| deleting rows in a huge spreadsheet with subtotals | Excel Discussion (Misc queries) | |||
| Excel 2003; spreadsheet with filtering; deleting rows | Excel Worksheet Functions | |||
| Deleting excess data in a macro | Excel Discussion (Misc queries) | |||
| Deleting excess rows and columns | New Users to Excel | |||
Linear Mode
