Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why won't my unhide command work?
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why won't my unhide command work?
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 "Micki" wrote: 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why won't my unhide command work?
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why won't my unhide command work?
On Feb 17, 12:00 pm, Stan Brown wrote:
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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide column - why doesn't click unhide column work? | Excel Discussion (Misc queries) | |||
Activex command to Hide/Unhide | Excel Worksheet Functions | |||
Command Button to Hide/Unhide Rows | Excel Discussion (Misc queries) | |||
how do i unhide a worksheet in excel 2003? unhide tab don't work | Excel Discussion (Misc queries) | |||
How do I unhide a column when format/column/unhide won't work | Excel Worksheet Functions |