How to protect a column or columns
I want to hide 2 columns and protect them so they and not be opened without a password, the rest of the spreadsheet need to be open so anyone can add (paste new rows of data) to it.
I want to hide a column and protect it by a password, so that people may work on (edit) in other columns and rows with out being able to unhide my hidden
Is there a way to protect a specific column on a worksheet from editing information in it.
E.g. I would like to protect column B on a worksheet I have but only Column B not the whole worksheet.
How can I accomplish this please?
on my worksheet, which anyone can use, how do I deny everyone from entering data on 3 entire columns? these columns contain formulas that deal with the data entered in the other columns.
I have 12 columns with data on days and each new day I want to add a new day to the set of 12 columns without adding a 13th one. So the oldest day are removed and the view is still 12 days.
In these columns some values are calculated with formulas from data residing in the column (not from other columns) and I want to protect the formula but allow the column to be moved one step to the left.
As of now I haven't been able to use the built in functions of protection of cells and protection of formulas.
Related Applications & Scripts
Protect copyrights for your images with professional looking watermarks using Bytescout Watermarking freeware. Do you often take photos of your friends and family and publish them to the Web? Have you ever had your photos stolen from your Website? To protect them from being used without your permission, use our utility to add visible watermarks and be sure that your photos are secure.
If you are in a need for a simple and easy-to-use password protection and user authentication for your pages, but do not require a complicated user management system then look no further!
Protect Your Pages is a session-based login system with the ability to define multiple users with different access levels.
- No database required, only PHP .
- Full documentation provided with easy-to-follow steps.
- Easy to customize
- Uses MD5 hashing and salt for additional security.
This is an easy to use script for users who do not have the ability to use .htaccess but want to protect non sensitive information. Full instructions included
HTMLock allows you to password protect HTML and hide HTML source of your pages. With this tool you can encrypt HTML pages to place them on your web site, CD/DVD, or hard drive. You can password protect HTML and text files.