How do you password protect a single cell or column of cells
I am trying to password protect a column of single cells but it keeps
protecting the whole work sheet can ant one help? |
How do you password protect a single cell or column of cells
Select all the column not to be protected;
Use Format | Cells | protection and deselect the Lock box Now Tools | Protect | worksheet Does this give you what you want? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kinnaird" wrote in message ... I am trying to password protect a column of single cells but it keeps protecting the whole work sheet can ant one help? |
How do you password protect a single cell or column of cells
Thanks very much I will try this.
Kinnaird "Bernard Liengme" wrote: Select all the column not to be protected; Use Format | Cells | protection and deselect the Lock box Now Tools | Protect | worksheet Does this give you what you want? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kinnaird" wrote in message ... I am trying to password protect a column of single cells but it keeps protecting the whole work sheet can ant one help? |
How do you password protect a single cell or column of cells
On Thursday, January 10, 2008 12:31:02 AM UTC+8, Kinnaird wrote:
I am trying to password protect a column of single cells but it keeps protecting the whole work sheet can ant one help? Step 1 : Select all cells, right click, choose format cells, choose protection, unclick the box that says lock cells Step 2 : Select the cells that you want to be locked, right click, choose format cells, choose protection, click the box that says lock Step 3 : Click on Review from Menu Tab - protect sheet - input a password ALL LOCKED CELLS THAT YOU SELECTED WILL BE LOCKED. ALL UNLOCK CELLS WILL REMAIN UNLOCKED ** ENSURE THAT WHEN YOU PROTECT THE SHEET - UNCLICK THE BOX THAT SAYS "SELECT LOCKED CELLS" |
All times are GMT +1. The time now is 03:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com