Why won't my unhide command work?

[Micki]

I am currently taking an Excel class, and we are learning about hiding and
unhiding columns and rows. I was successful in hiding each, but when I tried
to unhide them it didn't work. I was sure to select both columns and/or rows
on either side of the hidden element before choosing to unhide, but no luck,
both the column and the row stayed hidden. Any advice?

 

[Mike Rogers]

Micki

Lets say you are trying to "unhide" rows. Select the row before and the row
after at the same time, right click with the curser over the selected rows
and select unhide from the drop down menu. Sounds like you already tried
this but thought I would walk you throuhg it again. Now do the same thing
but this time from the drop down select "Row Height" and enter something
like "12.75" (without the quotes of course) and see if they don't came back.

Mike Rogers

 

[Stan Brown]

Sat, 16 Feb 2008 21:12:01 -0800 from Micki

I am currently taking an Excel class, and we are learning about hiding and
unhiding columns and rows. I was successful in hiding each, but when I tried
to unhide them it didn't work. I was sure to select both columns and/or rows
on either side of the hidden element before choosing to unhide, but no luck,
both the column and the row stayed hidden. Any advice?

Did you select them with a control-click, which selects just those
particular columns, or with a shift-click, which selects them and all
columns in between?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?

 

[Matt Richardson]

Sat, 16 Feb 2008 21:12:01 -0800 from Micki


Did you select them with a control-click, which selects just those
particular columns, or with a shift-click, which selects them and all
columns in between?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?

Have you hidden the first few columns? I remember pulling my hair out
on this when I was starting out. Click the column header and drag/
highlight across to the left (to the little box that sits before the
place where column A should be.) Now try Unhiding again and it should
work. Similarly this works for unhiding rows - click the row header
and drag upwards, and then that should work too.

Hope this helps,
Matt Richardson
http://teachr.blogspot.com