| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Cells
I want to hide a selected range of cells from view without using the Hide
Columns or Hide Rows commands. Could someone please tell me how to do this. Thank you in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Cells
I am afraid you can't,
"Chris" escreveu: I want to hide a selected range of cells from view without using the Hide Columns or Hide Rows commands. Could someone please tell me how to do this. Thank you in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Cells
If by "hide" you mean simply make them "not so visible", you can always set
the Row Height of those rows to something like .01 Vaya con Dios, Chuck, CABGx3 "Chris" wrote: I want to hide a selected range of cells from view without using the Hide Columns or Hide Rows commands. Could someone please tell me how to do this. Thank you in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Cells
Thanks, I kind of figured it would be this way.
"CLR" wrote: If by "hide" you mean simply make them "not so visible", you can always set the Row Height of those rows to something like .01 Vaya con Dios, Chuck, CABGx3 "Chris" wrote: I want to hide a selected range of cells from view without using the Hide Columns or Hide Rows commands. Could someone please tell me how to do this. Thank you in advance. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Cells
You're welcome Chris, and remember, you can also just change the font color
to the same as the background color and the viewer sees it as a blank cell....... Vaya con Dios, Chuck, CABGx3 "Chris" wrote: Thanks, I kind of figured it would be this way. "CLR" wrote: If by "hide" you mean simply make them "not so visible", you can always set the Row Height of those rows to something like .01 Vaya con Dios, Chuck, CABGx3 "Chris" wrote: I want to hide a selected range of cells from view without using the Hide Columns or Hide Rows commands. Could someone please tell me how to do this. Thank you in advance. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Cells
"Chris" wrote in message
... I want to hide a selected range of cells from view without using the Hide Columns or Hide Rows commands. Could someone please tell me how to do this. Thank you in advance. Data/ Filter? -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| Use functions when cells are merged | Excel Worksheet Functions | |||
| Hiding cells on condition | Excel Worksheet Functions | |||
| Hiding Formula in cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
