Headers in excel

Hi Clare,

Thank you for your post; in answer Yes you can lock your heading or any other cells to ensure they are not changed.

Follow these steps; its a bit of reverse logic;

Select the cells that you wish to be changed, ie data entered or edited.
Go to the Menu option Format>Cells, on the dialog box select Protection.
Deselect the Lock Cells tick box

Go to Tools>Protection and choose the option Protect Worksheet, you can set a password at this point if you wish.

When you return to your worksheet you will be able to make changes to the cells which you selected in the first step. Those which were not selected will be locked and a warning dialog box will pop up if any changes are attempted.

I hope that has helped, regards Pete