Skip over a (calculated) cell in a Table

J

Jeremy

I have an (Excel 2003) list with some calculated columns in it. Users add
data to the botttom of the table as usual. When user tabs right from a cell
in which she has entered data, I'd like the cursor to skip over any
calculated columns, so that the user doesn't corrupt the formulas.
However, if I protect the sheet appropriately, users can't add new records
to the bottom of the list.
Is there a way to skip the calculated cells in an Excel 2003 list? I don't
want to have to create a data entry form.
Thanks!
 
J

Jeremy

I have locked the cells I want to skip over. However that has no effect
unless one protects the sheet. If you protect the sheet you can't add more
records to the List (or Table as it's called in Excel 2007).
Jeremy
 

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

Need event macro to tab past a (calculated) cell 4
Counting calculated formulas in a Column 3
Cursor skip over a cell 2
Creating a Calculated Field in a Pivot Table for same field 3
Is there anyway to find out which cell is being calculated? 2
Excel 2007 pivot tables - calculated fields and SSAS cube 3
Server Calculated Members in Excel 2007 4
Default Formula for a Cell 4

Top