Home » questions » i have an excel worksheet?

i have an excel worksheet?

2
2006-08-13 21:23:34, Category: Programming & Design
I have 2 inputs and the rest is all calculations.. How do i protect the data so it can't be typed into....At the same time allow me to put in those 2 inputs????

Answers

  1. Hugo

    On 2006-08-13 22:14:28


    At 'tools', select 'protection', then 'allow user to edit rages'.

  2. O Caçador

    On 2006-08-14 02:55:52


    Select the 2 cells that you will need to change Format | Cells... | Protection Uncheck locked; click OK Tools | Protection... Uncheck Select locked cells If you wish to use a password to secure the sheet, this is where youu would enter it.