I have a sheet as shown in the screenshot with a table made.
It contains answers for questions. The grey cells indicate the question number. The white cells denote the answer number, e.g. 1,2,3 or 4.
I will later on replace 1 with A, 2, with B, 3 with C, 4 with D.
Now for testing purposes. I locked the question numbers, and protected my sheet. Then I entered few numbers in the cells for answers. Excel doesn't allow to do find/replace on a protected sheet.
I want to do the find/replace such as, all '1' get replaced by A, '2' with B, so on and so forth. However, this find/replace shouldn't disturb the locked grey cells. How can I do this process?
I am using Excel 2019 on Windows 10-64 bit.
Bookmarks