L Linda Jul 27, 2009 #1 How can I delete everything below the last line to the end on a worksheet? Somehow I have lines extending to the end of time?
How can I delete everything below the last line to the end on a worksheet? Somehow I have lines extending to the end of time?
D Dave Peterson Jul 27, 2009 #2 That's the way excel works. You can hide those unused rows, but you can't delete them. Personally, I'd just let them stay visible. They're not hurting anything and if you share the workbook with others, I bet most would expect to see them.
That's the way excel works. You can hide those unused rows, but you can't delete them. Personally, I'd just let them stay visible. They're not hurting anything and if you share the workbook with others, I bet most would expect to see them.