| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hidden/0 height rows
Hello all,
I have a 7000+ row worksheet; rows 2-1180 and 1185-7028 are hidden/have a 0 height. I learned from a previous post that I can manually "drag" each row and change its height back to 14.25. Since this is not my worksheet (a colleague asked me to "fix" it) I am loath to manually drag 7000+ rows to the correct height. I have highlighted the workbook, right clicked; change height to 14.25 and this only changes the height of "visible" rows. Row 1 is frozen (with titles). The numbers for rows 1181 to 1184 are blue. This was created with MS Excel 2003 and I am using MS Excel 2007. Thanks for any ideas and advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
Threaded Mode
