| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Michael
You cannot get rid of those rows, but you can reset the used range that affects the scrollbar travel. Find your end of data and select the row below. SHIFT + END + DownArrow to select all rows below. EditDeleteEntire Rows. Same for all columns to the right of data. Save the workbook at this point. You may have to close then re-open to see changes. For more on this subject see Debra Dalgleish's site. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben Excel MVP On Tue, 18 Jan 2005 12:41:01 -0800, michael g <michael wrote: My worksheet has about 66,000 empty rows at the bottom of the sheet and that affects my usage of the scrollbar on the right of the screen. Anyone know how i can get rid of those miscellaneous rows? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
| How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Remove empty rows in excel? | Excel Discussion (Misc queries) | |||
| increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) | |||
Threaded Mode
