How to skip cells with formulas in data entry?

L

LindaB

I have a user who enters data in a worksheet and wants to automatically skip
the cells calculating the data (there are several subtotals). She wants it
to be completely "head down" data entry.
 
G

Gary''s Student

You can protect the formula cells in such a way that they can't even be
selected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

portected cells 5
Excel 2003-skip to another cell upon leaving 7
Automatically skipping cells when pasting data 1
ENTER skips unlocked cells 3
Lock out data entry in a cell 1
Skip over a (calculated) cell in a Table 3
Paste Special Values 2
Data entry that changes worksheet(s) results (2003 or 2007) 1

Top