Hide a formula. Change Source data

  • Thread starter Thread starter wheelspk
  • Start date Start date
W

wheelspk

I would like to hide a formula and be able to edit the data that feeds into
the formula. When I protect and hide the formula, the data cells can not be
changed either. Help would be much appreciated.
 
By default, all cells are locked, so that when you protect the
worksheet, all cells are not editable. To get around this, select all
the cells in the worksheet (click the button above the "1" row header
and to the left of the "A" column header), uncheck the Protected item
on the Format Cells dialog. Then, go back and choose the cells that
really should be locked, set the protected status, and protect the
sheet.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
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

Excel EXCEL - using a date dependant formula to hide rows 3
hide multiple worksheets based on a formula value in one cell 1
Hide formulas in cells 5
Mid column sum formulas with varied ranges to sum 17
Hide / Unhide Columns in Password Protected w/s 2
hide & unhide toggle button 3
hiding rows containing formulas which return zero values 3
Excel Excel Vlookup formula based on cell data 7

Back
Top