Software

Ask something
Discussion Locked

Locking cells with formulas in Excel

0 helpful
3 replies

by nsohenick 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a spreadsheet that I would like to have users key in information in the detail section, but I want to lock the abilty to change the formulas at the bottom. Is there a way that I can lock only the bottom row of a spreadsheet?

3 replies

by dklippert

Select the cells that you want to allow changes. Go to Format Cells and remove the check mark in the Locked box on the Protection tab.
Now go to Tools>Protection

This discussion is closed to new replies.