Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding 1 cell
how do you hide 1 cell so people can't see whats in it
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding 1 cell
not sure if what you want, but can try columns or rows, by selecting whole
col/rows, right click on area and select hide. else can change text color to match background, thereby making data invisible. use of conditional format to hide selected cells can also be used. have a fixed cell to manipulate on/off, e.g.: in cell (put cursor in cell desired) for cond. format: Format, Cond. Format, change condition to "formula is", enter: =$A$2="x" (cell has an x makes cond. format active), select color of text you want... "duckie" wrote: how do you hide 1 cell so people can't see whats in it |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding 1 cell
You can format the cell to Custom ;;;
Also under Formatcellsprotection you can lock that cell and checkmark the "hidden" option so the contents won't show in the formula bar either. Then you must protect the worksheet with all other cells unlocked. Note: this will deprive you of some functions and Excel internal security is not great and can be circumvented quite easily. Gord Dibben MS Excel MVP On Thu, 04 Oct 2007 22:52:42 -0700, duckie wrote: how do you hide 1 cell so people can't see whats in it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding a value in a single cell | Excel Worksheet Functions | |||
hiding the cell and the formula bar | Excel Discussion (Misc queries) | |||
Hiding Rows when a cell = 0 | Excel Discussion (Misc queries) | |||
hiding parts of a cell | Excel Discussion (Misc queries) | |||
Hiding cell contents | Excel Discussion (Misc queries) |