I have a spreadsheet with formulas that autofill the cells they're in. I would like to protect those cells, so that users don't change them by mistake, but when I protect them, they don't autofill anymore... how can I do this? Thanks!
I have a spreadsheet with formulas that autofill the cells they're in. I would like to protect those cells, so that users don't change them by mistake, but when I protect them, they don't autofill anymore... how can I do this? Thanks!
What do you mean? Locked cells containing formulae continue to work whether the sheet is protected or not, so what do you mean by 'autofill'?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
@fillipa, is your spreadsheet a Table?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks