Mar 29 2021 11:26 AM
I am on an Lenovo all in one, Windows 10 with excel version 2019 (16.0)
I have a spreadsheet that where the first 5 columns (A through E) need to allow for editing but, because there are calculations which are based on column E, (F through P) need to be locked so the calculations cannot be changed. Here is a copy of the document (INFO in doc is fictitious)
I retired about 3 years ago and was better at this but a little rusty since I haven't used for awhile.
Any help would be appreciated.
Mar 29 2021 11:38 AM
I assume you meant columns A to F, for F1 explicitly mentions "manually enter date of affidavit".
Step 1: Unlock the cells that should be editable.
Step 2: Protect the worksheet.
See the attached version (there is no password)