Forum Discussion
Skip a cell when entering data
I want to skip calculated cells in the row.
Select the cells where you (or the user) should be able to enter/edit data.
Press Ctrl+1 to activate the Format Cells dialog.
Activate the Protection tab.
Clear the locked check box.
Click OK.
On the Review tab of the ribbon, click Protect Sheet.
Clear the check box "Select locked cells" (but leave the check box "Select unlocked cells" ticked).
Click OK.
Pressing Tab or Enter will now move between the unlocked cells only.