Hide formulas

H

Heather

Hi, is there a way to hide the formulas in a spreadsheet so they'll only see
the result? thank you
 
B

Bill Kuunders

Just google for "hide formulas excel"
there are macro solutions and sheet protection solutions
 
G

Gord Dibben

Select the cells to be hidden.

Format>Cells>Protection. Checkmark "hidden"........they will be locked also
by default.

Now Tools>Protection>Protect Sheet.

You may want to leave other cells unlocked for editing.

First hit CTRL + A to select all cells.

Unlock these.

Now select the cells to be hidden and locked and do so.

Now protect the sheet.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Just a warning.

Worksheet protection, even with a password, is very weak.

A determined user can find ways to see your formulas.


Gord
 
H

Heather

thank you, this is very helpful :)

Gord Dibben said:
Just a warning.

Worksheet protection, even with a password, is very weak.

A determined user can find ways to see your formulas.


Gord
Click to expand...
 

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

Visio shape text disappears upon copy paste 1
Hide columns based on row values 2
Convert Formula Results to Absolute 1
hiding rows 2
MS Project. Real progress of the project, % complete 1
Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
Newbie Help - IF Yes No Function 0

Top