Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unhide rows
I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet is unprotected and I have tried to unhide these rows without success. The only way to unhide it is to physically drag one row at a time. I also noted that the numbers listing rows 1 -20 (number of the row on the left side) are purple color, where as rows 21+ are normal black color. thanks Comic_fly |
#2
|
|||
|
|||
Sounds like there is a filter on, do datafiltershow all
Regards, Peo Sjoblom " wrote: I have a spreadsheet that has 100 columns of data. Unfortunetely rows 21 - 60 are hidden. The spreadsheet is unprotected and I have tried to unhide these rows without success. The only way to unhide it is to physically drag one row at a time. I also noted that the numbers listing rows 1 -20 (number of the row on the left side) are purple color, where as rows 21+ are normal black color. thanks Comic_fly |
#3
|
|||
|
|||
Hi
Try DataFilter Show all -- Regards Ron de Bruin http://www.rondebruin.nl " wrote in message ... I have a spreadsheet that has 100 columns of data. Unfortunetely rows 21 - 60 are hidden. The spreadsheet is unprotected and I have tried to unhide these rows without success. The only way to unhide it is to physically drag one row at a time. I also noted that the numbers listing rows 1 -20 (number of the row on the left side) are purple color, where as rows 21+ are normal black color. thanks Comic_fly |
#4
|
|||
|
|||
Thanks. It worked
-----Original Message----- Hi Try DataFilter Show all -- Regards Ron de Bruin http://www.rondebruin.nl " wrote in message ... I have a spreadsheet that has 100 columns of data. Unfortunetely rows 21 - 60 are hidden. The spreadsheet is unprotected and I have tried to unhide these rows without success. The only way to unhide it is to physically drag one row at a time. I also noted that the numbers listing rows 1 -20 (number of the row on the left side) are purple color, where as rows 21+ are normal black color. thanks Comic_fly . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
Filtering rows with tracked changes | Excel Discussion (Misc queries) |