How to skip cells with formulas in data entry?

  • Thread starter Thread starter LindaB
  • Start date Start date
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.
 
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

Lock out data entry in a cell 1
ENTER skips unlocked cells 3
Automatically skipping cells when pasting data 1
Excel 2003-skip to another cell upon leaving 7
Skip over a (calculated) cell in a Table 3
Skip Copying a protected cell with subtotal 2
Getting Text data using the Data - Subtotal feature 1
Copying a formula with an increase of more than 1 6

Back
Top