| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why won't th unhide function work??
Why won't the unhide function work on a sheet that I have created. I
previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why won't th unhide function work??
Try selecting the 2 rows on either side of the hidden rows and then unhide.
Mike "Draino" wrote: Why won't the unhide function work on a sheet that I have created. I previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why won't th unhide function work??
Tried it and still nothing. Not even selecting the entire sheet will work.
"Mike" wrote: Try selecting the 2 rows on either side of the hidden rows and then unhide. Mike "Draino" wrote: Why won't the unhide function work on a sheet that I have created. I previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why won't th unhide function work??
Remember that very very short rows can appear hidden. Make sure the rows in
question are not like that. -- Gary''s Student gsnu200710 "Draino" wrote: Tried it and still nothing. Not even selecting the entire sheet will work. "Mike" wrote: Try selecting the 2 rows on either side of the hidden rows and then unhide. Mike "Draino" wrote: Why won't the unhide function work on a sheet that I have created. I previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why won't th unhide function work??
That's the problem. They were not like that - they were hidden, and now they
are acting like short rows. I can not unhide them nor set the height unless I click and drag them. "Gary''s Student" wrote: Remember that very very short rows can appear hidden. Make sure the rows in question are not like that. -- Gary''s Student gsnu200710 "Draino" wrote: Tried it and still nothing. Not even selecting the entire sheet will work. "Mike" wrote: Try selecting the 2 rows on either side of the hidden rows and then unhide. Mike "Draino" wrote: Why won't the unhide function work on a sheet that I have created. I previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why won't th unhide function work??
Edit|Goto
type: A175:A350 format|row|unhide Draino wrote: Why won't the unhide function work on a sheet that I have created. I previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why won't th unhide function work??
Or change the row height
Format|Row|Height Dave Peterson wrote: Edit|Goto type: A175:A350 format|row|unhide Draino wrote: Why won't the unhide function work on a sheet that I have created. I previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Figured it out
For Now I have figured to use Go To: Edit -- Go To
In the reference box type in the cells in the hidden rows (i.e A109:A130) These rows are now selected, but hidden. Next go to: Format -- Row -- Height Set height at what you want (i.e. 12.75) The selected rows height changes from 0 to what you selected and they will appear on screen again. "Draino" wrote: Why won't the unhide function work on a sheet that I have created. I previously hid about 175 rows between my last data entry and my summary. Now when I try to unhide them, nothing happens. I have to manually drag all of the hidden cells from a height of 0 to 12.75. Going to format - row height and trying to set them all to 12.75 does not work either. Is there a way to do this other than me dragging rows 350 to 175 to open them all up?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhide function grayed out, why? | Excel Worksheet Functions | |||
| Unhide multiple work sheets at once | Excel Worksheet Functions | |||
| 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 | |||
| Exce Hide / Unhide function | Excel Worksheet Functions | |||
Linear Mode
