Forum Discussion
How to delete hidden lines
How to delete hidden lines? I go to Find & Select -->Go to special -->Objects then I try to delete but can't , the processor speed become high above 4Ghz and become slow process. This file has size over 30MB.
6 Replies
There are hidden lines ( they made itselft with name is lines 2). If I save as .xls its size is increase from 32MB to 120MB. It become most slowly because it use all CPU speed.
There are hidden lines.
Okay, thank you. I'm not sure how to improve performance for such case, you may try this old solution Deleting hidden objects in Excel 2007 - Microsoft Q&A
Hidden line
yes it is object not hidden row.
To be sure, do you mean lines as graphical objects (placed in hidden rows since the are hided) or just hidden rows?
If the lates few more ways are here How to Delete Hidden Rows in Excel: 3 Methods - ExcelDemy
