Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting a single column
Is it possible, within an Excel spreadsheet that is not otherwise protected,
to hide and password-protect a single column of data? I want to have a spreadsheet with data that is shared with co-workers, but within that spreadsheet I want to have a column (or several columns) of data that only I can view. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting a single column
On 18 May, 19:47, Metallocene
wrote: I want to have a column (or several columns) of data that only I can view. If your information is really confidential, I would recommend isolating this into it's own workbook. Worksheet protection is flimsy. See John Walkenbach's FAQ on the subject. http://j-walk.com/ss/excel/faqs/protectionFAQ.htm HTH Andrew |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting a single column
Only indirectly but you could try:-
Select all the cells on a worksheet and then format|cells|protection and remove the locked check mark. Then select the single column you want to hide and repeat the above but this time check the locked box. With your column still selected right click and hide the column and then protect the worksheet. Users cannot now unhide you column and in effect it isn't protected because all users cells are unlocked. One warning, Excel protection is pretty useless so anyone with even rudimentary knowledge could crack this security. Mike "Metallocene" wrote: Is it possible, within an Excel spreadsheet that is not otherwise protected, to hide and password-protect a single column of data? I want to have a spreadsheet with data that is shared with co-workers, but within that spreadsheet I want to have a column (or several columns) of data that only I can view. Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting a single column
Hi,
Try this: active all your sheet ( click on the box in the left of column headers and top of the row numbers ) and the right click on your sheet choos format cells and then go to protection tab and uncheck the luck checkbox click OK then active the cells you want to protect and again right click on the active cells and then format cells and then protection tab and check the luck checkbox click OK then go to menu ToolsProtection Protect sheet and follow the instruction and make your password. Thanks, -- Farhad Hodjat "Metallocene" wrote: Is it possible, within an Excel spreadsheet that is not otherwise protected, to hide and password-protect a single column of data? I want to have a spreadsheet with data that is shared with co-workers, but within that spreadsheet I want to have a column (or several columns) of data that only I can view. Thanks, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting a single column
Yeah I appreciate the weakness of the security in Excel, but what I'm mainly
trying to do is prevent essentially accidental viewing. I appreciate all the suggestions, thanks! "loudfish" wrote: On 18 May, 19:47, Metallocene wrote: I want to have a column (or several columns) of data that only I can view. If your information is really confidential, I would recommend isolating this into it's own workbook. Worksheet protection is flimsy. See John Walkenbach's FAQ on the subject. http://j-walk.com/ss/excel/faqs/protectionFAQ.htm HTH Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From single cell variables to a single column serie | New Users to Excel | |||
Protecting single sheets | Excel Discussion (Misc queries) | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
Protecting single cells or a range | Excel Discussion (Misc queries) |