pROTECTING CELLS

S

sjanaswamy

Hi there,
I have got 2 questions.

1) I need to protect onle cells that have formulae in it.

2) In a work sheet how do I get to see only formulaes in the cells an
not the constants.

Please help.

Thx,
Srin
 
F

Frank Kabel

Hi
first select the cells which should not be protected and goto 'Format -
Cells - Protection' and uncheck 'Locked'. After this protect the sheet
'Tools - Protection'

2. Goto 'Tools - Options - View' and choose 'Formulas'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo or list box 0
Split cells next to 1 cell 1
Protecting Word 2019 document 0
Show a cell's formula in text format in a linked cell 2
Visio: copy text of a master shape to User-define Cells (Variable) 0
Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
Mapping integers to strings 6

Top