Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to hide cells, which I can using Custom ;;; However, my cells
are also on a validation list (cells containing numbers and decimals), so after I hide the cells, and click on my drop down box, it shows blanks. The scroll bar is still there, it's just that the selection data is missing. Any suggestions? Thanks -- Tropical |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I prefer to actually type the data for the validation in the validation
windows instead of liking to cells in a sheet itself. In the dialog window for validation, select list, and instead of putting your range in, type the values in seperated by commas. HTH -- Anything is possible if you don't know what you're talking about. "Tropical" wrote: I am trying to hide cells, which I can using Custom ;;; However, my cells are also on a validation list (cells containing numbers and decimals), so after I hide the cells, and click on my drop down box, it shows blanks. The scroll bar is still there, it's just that the selection data is missing. Any suggestions? Thanks -- Tropical |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding Cells | Excel Discussion (Misc queries) | |||
hiding cells | New Users to Excel | |||
Hiding Cells | Excel Discussion (Misc queries) | |||
hiding cells from others | Excel Worksheet Functions | |||
Hiding Cells | New Users to Excel |