Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide data in specific rows/colums/cells in Excel 2003
Hi,
I want to hide the data (content) in a specific column in a worksheet, without hideing the whole column, with a password so that only authorized users can view its data. I know that Excel allows to protect these elements from editing, deleting etc using passwords, but that's not what I need. I need to hide the data in those elements so that users wont be able to view them, unless they enter the correct password. Does Excel allow me to do this? Thanks, Ben |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide data in specific rows/colums/cells in Excel 2003
Cant'n hide just one cell.
Your simple solution will be text coloring wanted cell with same background color and then protecting those cells. "Ben" wrote: Hi, I want to hide the data (content) in a specific column in a worksheet, without hideing the whole column, with a password so that only authorized users can view its data. I know that Excel allows to protect these elements from editing, deleting etc using passwords, but that's not what I need. I need to hide the data in those elements so that users wont be able to view them, unless they enter the correct password. Does Excel allow me to do this? Thanks, Ben |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide data in specific rows/colums/cells in Excel 2003
Ben
You can format the cells as Custom ;;; (3 semi-colons) to not see the contents. Also format under Protection to "Hidden" so's the formula bar will display nothing. Then Protect the sheet. Note on Excel internal security...................it is very weak and passwords easily cracked. General rule is: if you don't want users to see data, don't include that data. Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 03:58:00 -0700, Ben wrote: Hi, I want to hide the data (content) in a specific column in a worksheet, without hideing the whole column, with a password so that only authorized users can view its data. I know that Excel allows to protect these elements from editing, deleting etc using passwords, but that's not what I need. I need to hide the data in those elements so that users wont be able to view them, unless they enter the correct password. Does Excel allow me to do this? Thanks, Ben |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide data in specific rows/colums/cells in Excel 2003
Thanks a lot guys.
Both your tips were very helpful. Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide specific cells in Excel | Excel Worksheet Functions | |||
Chart disappears if you hide rows/colums with data. | Excel Discussion (Misc queries) | |||
Can I rearrange data entered in rows into colums in Excel? | Excel Discussion (Misc queries) | |||
What is the quickest way to hide a lot of rows and colums ? | Excel Discussion (Misc queries) | |||
How can I hide data in colums. | Excel Discussion (Misc queries) |