#1
|
|||
|
|||
Excell spreadsheet hidden rows
I use a large spreadsheet about 45 columns and 300 rows. Something is causing the row heights of blocks of rows to be set at zero, which basically hides the rows. The only way you know they are there is the small double line in the row number column. I have tried to "unhide the rows, have tried to highlight the row above and the row below and set the row height to a larger number - nothing works. The only way I have found to fix the problem is position the cursor on the bottom double line and pull the row down larger. This works but is time consuming if 100-200 rows are hidden. I have fixed it several times, and later when I open the workbook, it has happened again. |
#2
|
|||
|
|||
First, I would look to see if there is any code in the workbook.
If you don't know anything about VBA, take a look at this link Second, you can select Ctrl + A which will select the entire spreadsheet, then right click on the row headings and select row height. Add in a row height such as 15 and select OK. Third, copy and paste all of your data to a new spreadsheet as text a format as needed. Maybe the spreadsheet is corrupted in some way. Without us seeing the offending worksheet, it's hard to know exactly what to advise as I can duplicate the problem. Hope this helps... |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
AVERAGEIF function excluding hidden rows | michael_1962 | Excel | 1 | 05-17-2015 11:31 PM |
VBA to keep hidden rows hidden when filtering | tectonicseer | Excel Programming | 1 | 07-27-2014 11:54 AM |
how to view hidden rows | gsrikanth | Excel | 10 | 01-27-2012 05:29 AM |
hidden rows | gsrikanth | Excel | 5 | 01-19-2012 02:40 PM |
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. | psmaster@earthlink.net | Excel | 0 | 11-24-2009 11:54 AM |