H
Hozefa
how can i fix one entire column after putting my formula there so no one can
edit it
edit it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
Assuming the col with the formulas is col C,
with data input in say, cols A and B
Try this:
Select cols A & B
Click Format > Cells > Protection tab
Uncheck "Locked" > OK
Then just protect the sheet via:
Click Tools > Protection > Protect Sheet > [Password?] > OK
This'll protect every cell on the sheet (inclusive col C)
other than cols A and B
with data input in say, cols A and B
Try this:
Select cols A & B
Click Format > Cells > Protection tab
Uncheck "Locked" > OK
Then just protect the sheet via:
Click Tools > Protection > Protect Sheet > [Password?] > OK
This'll protect every cell on the sheet (inclusive col C)
other than cols A and B
L
Luada
Hi Max, I tried your suggestion and when I try to uncheck the locked on the
cells withing the column, I get an error message "cannot change part of a
merged cell". In my invoice sheet I need to protect only the area H15 to H29
and leave the rest of the sheet unprotected so data can be added. Any
suggestions?
Luada
cells withing the column, I get an error message "cannot change part of a
merged cell". In my invoice sheet I need to protect only the area H15 to H29
and leave the rest of the sheet unprotected so data can be added. Any
suggestions?
Luada
Max said:Assuming the col with the formulas is col C,
with data input in say, cols A and B
Try this:
Select cols A & B
Click Format > Cells > Protection tab
Uncheck "Locked" > OK
Then just protect the sheet via:
Click Tools > Protection > Protect Sheet > [Password?] > OK
This'll protect every cell on the sheet (inclusive col C)
other than cols A and B
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Hozefa said:how can i fix one entire column after putting my formula there so no one can
edit it
M
Max
Try this sequence instead for your case ..
Press CTRL+A to select the entire sheet
Click Format > Cells > Protection tab
Uncheck "Locked" > OK
(we unlock the entire sheet first)
Select the target range H15:H29
Click Format > Cells > Protection tab
Check "Locked" > OK
(then we lock only the target range)
Now protect the sheet via:
Click Tools > Protection > Protect Sheet > [Password?] > OK
And if the above doesn't work, then ..
Try unmerging the entire sheet first
Instead of using merged cells to centre across cols
(e.g.: for col labels), consider:
Format > Cells > Alignment tab
Under Text alignment:
Horizontal > Centre across selection
(merged cells can be a real pain <g>)
Press CTRL+A to select the entire sheet
Click Format > Cells > Protection tab
Uncheck "Locked" > OK
(we unlock the entire sheet first)
Select the target range H15:H29
Click Format > Cells > Protection tab
Check "Locked" > OK
(then we lock only the target range)
Now protect the sheet via:
Click Tools > Protection > Protect Sheet > [Password?] > OK
And if the above doesn't work, then ..
Try unmerging the entire sheet first
Instead of using merged cells to centre across cols
(e.g.: for col labels), consider:
Format > Cells > Alignment tab
Under Text alignment:
Horizontal > Centre across selection
(merged cells can be a real pain <g>)