How can I hide formulas in a spreadsheet to send to a customer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If it is possible, I would like to send a service proposal to a customer that
I have created in Excel. I think it may work by sending only the tab/sheets
that have the results, these only reference a cell on another sheet and
hence, that me be sufficient.

Let me know if there is a better way.

Thanks
 
Hi
If the sheet contains formulas, you'll probably want to protect the sheet,
so they cannot be changed. As default, all the cells are locked, but the
sheet needs to be protected for the lock to be activiated. Ctrl+A will
select all the cells in the sheet. Go to Format|Cells|Protection. From
there, you can select to hide the cells. This means that the formulas cannot
be seen.
 
You can also copy and paste values on the sheets you are sending. thatway
they get no formulas at all.
 
You must log in or register to reply here.

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

Hide a Formula 3
customize what work sheet to hide. 1
Excel EXCEL - using a date dependant formula to hide rows 3
Can I hide sheet tabs so only some are accessible? 3
Hide Formula & Allow Copy 1
Copy a formula using Vlookup 2
How can I hide the formula in an excel sheet? 3
How can I compare spreadsheets and remove duplicated data? 3

Back
Top