Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to disable all functions in Excel??
- Thread starter Bvlcvry
- Start date
You'll need to protect the sheet.
By default, all cells are "locked", so when you protect a sheet-NO cells can be changed. What you want to do is this:
If you're locking just a few cells, do #1. If you're locking most of the cells, do #2.
1. Hit ctrl-a, Format-Cells, Protection tab. Unselect locked. Now, select only the cells you want to lock and Format-Cells, Protection tab, locked. Then Tools-Protect-Worksheet.
2. Select only the cells you want to UNlock and Format-Cells, Protection tab, remove locked checkbox. Then Tools-Protect-Worksheet.
I assume you'll want to lock only cells that contain formulas.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
By default, all cells are "locked", so when you protect a sheet-NO cells can be changed. What you want to do is this:
If you're locking just a few cells, do #1. If you're locking most of the cells, do #2.
1. Hit ctrl-a, Format-Cells, Protection tab. Unselect locked. Now, select only the cells you want to lock and Format-Cells, Protection tab, locked. Then Tools-Protect-Worksheet.
2. Select only the cells you want to UNlock and Format-Cells, Protection tab, remove locked checkbox. Then Tools-Protect-Worksheet.
I assume you'll want to lock only cells that contain formulas.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
- Status
Similar threads
- Locked
- Question
- Locked
- Question