i want protect some fields in microsoft-excel and also that should be hidden.how it is possible?

Question

i want protect some fields in microsoft-excel and also that should be hidden.nobody access those fields without my permit.how is possible?

Answer 1

THESE INSTRUCTIONS APPLY TO OFFICE 2003 AND OLDER. FOR OFFICE 2007 THESE INSTRUCTIONS WILL NOT APPLY AS A NEW INTERFACE MAKES THESE COMMANDS UNAVAILABLE.

You can select fields and right click them to choose "Format Cells". In there, visit the Protection Tab and choose whether to lock, hide, or both.

Once you selected the cells to protect, you need to set a password. Open the "Tools" menu, then "Protection", then "Protect Sheet". Enter a password (even a blank one will protect the sheet if you're not too interested in security). you must remember this password: just like with Microsoft Word, there is no backdoor (no alternate method of password retrieval or opening the file without one) if you forget what password goes with your Excel file.

From this point on, those cells will not be altered or visible without going back to the "Tools" menu, choosing "Protection", then "Unprotect Sheet." You will need the password to remove protection. I would suggest selecting the cells to protect in "Format Cells" first while you're working on the worksheet then using Tools > Protection > Protect Sheet to finalize the changes when your editing is finished (so it's less annoying to work on the changes while it's not done.)

Please note that hiding a cell DOES NOT HIDE it's value or results. It only hides the formula used to create the result.

Answer 2

You can protect the workbook and then hide the specific fields.

Answer 3

the one above me gave a huge explanation.. wow..

why dont u just message me at [e-mail] i can help you step by step online and u can do it instatly.

if you dont find me online or if you dont have a yahoo messenger...

you can actually checkout this site www.ExcelGoodies.Com there are excel consultants online. you can chat with them and get instant help on this.

I learnt excel from them. Its worth giving a try.. why dont u give a try.

Answer 4

specific. basically staggering click on the little tab, itself, and you will do it. on the wonderful click menu it is going to say "tab shade." opt for that and choose your shade. properly, in line with danger it incredibly is the colour of the tab, yet i do no longer understand bearing directly to the font shade on the tab. besides the undeniable fact that, in case you opt for for a gloomy shade which includes army Blue, the font will seem in white, from what i will tell.