Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Wanna Learn

Select the rows on each side of the hidden row/rows and right click and
select unhide.

Mike Rogers

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Perhaps you have some cells merged or something like that?

Have you tried left clicking on the sheet in the spot kitty corner to 1 and
A to select the whole sheet and then format cells unhide rows?

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Mike I tried that and it does not work

"Mike Rogers" wrote:

Wanna Learn

Select the rows on each side of the hidden row/rows and right click and
select unhide.

Mike Rogers

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Tim I tried that and it does not work

"tim m" wrote:

Perhaps you have some cells merged or something like that?

Have you tried left clicking on the sheet in the spot kitty corner to 1 and
A to select the whole sheet and then format cells unhide rows?

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

How did you hide them?

"Wanna Learn" wrote:

Tim I tried that and it does not work

"tim m" wrote:

Perhaps you have some cells merged or something like that?

Have you tried left clicking on the sheet in the spot kitty corner to 1 and
A to select the whole sheet and then format cells unhide rows?

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Try selecting the range that includes the hidden rows and choose Format,
rows, autofit. If a row accidently gets sized as something other than zero,
then unhide won't bring it back.
Good luck!

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Bj This is a monthly report so I really do not remember, but there is a
pivot table on the sheet could that have something to do with it?

"bj" wrote:

How did you hide them?

"Wanna Learn" wrote:

Tim I tried that and it does not work

"tim m" wrote:

Perhaps you have some cells merged or something like that?

Have you tried left clicking on the sheet in the spot kitty corner to 1 and
A to select the whole sheet and then format cells unhide rows?

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Hi Everyone

I was able to unhide the rows one at a time. nothing unusual I did have a
sort on one of the columns . Again thank you

"bj" wrote:

How did you hide them?

"Wanna Learn" wrote:

Tim I tried that and it does not work

"tim m" wrote:

Perhaps you have some cells merged or something like that?

Have you tried left clicking on the sheet in the spot kitty corner to 1 and
A to select the whole sheet and then format cells unhide rows?

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

Wanna Learn

Another way that works for me is in the upper left corner find & select the
small square at the intersection of the columns and rows. Bring your curser
on the row side and right click select "Row Height" and enter something like
12.75. (If you put your curser over a colum e.g. A, B, C.... you can adjust
the column width.) This should bring everything selected to that row height.

Mike Rogers

"Wanna Learn" wrote:

Mike I tried that and it does not work

"Mike Rogers" wrote:

Wanna Learn

Select the rows on each side of the hidden row/rows and right click and
select unhide.

Mike Rogers

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

I am having the same problem in several spreadsheets. I have tried all the
solutions offered, and nothing is working. Any more ideas?

"BoniM" wrote:

Try selecting the range that includes the hidden rows and choose Format,
rows, autofit. If a row accidently gets sized as something other than zero,
then unhide won't bring it back.
Good luck!

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

I don't know waht all the solutions were, but if you've tried autofitting the
rows, maybe you just can't see the rows you want.

I'd try window|Unfreeze panes
then scroll a few times.

HannaS wrote:

I am having the same problem in several spreadsheets. I have tried all the
solutions offered, and nothing is working. Any more ideas?

"BoniM" wrote:

Try selecting the range that includes the hidden rows and choose Format,
rows, autofit. If a row accidently gets sized as something other than zero,
then unhide won't bring it back.
Good luck!

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

--

Dave Peterson

Thank you so much for all your suggestions. I have to confess, though, that
I have been a complete idiot, but have now solved the problem! Just in case
anyone else has done what I did, I will just ask one question: have you got
any filters applied? Enough said, I think! Oops.....

"Dave Peterson" wrote:

I don't know waht all the solutions were, but if you've tried autofitting the
rows, maybe you just can't see the rows you want.

I'd try window|Unfreeze panes
then scroll a few times.

HannaS wrote:

I am having the same problem in several spreadsheets. I have tried all the
solutions offered, and nothing is working. Any more ideas?

"BoniM" wrote:

Try selecting the range that includes the hidden rows and choose Format,
rows, autofit. If a row accidently gets sized as something other than zero,
then unhide won't bring it back.
Good luck!

"Wanna Learn" wrote:

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

--

Dave Peterson