ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to skip cells with formulas in data entry? (https://www.excelbanter.com/excel-discussion-misc-queries/178995-how-skip-cells-formulas-data-entry.html)

Lindab

How to skip cells with formulas in data entry?
 
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.

Gary''s Student

How to skip cells with formulas in data entry?
 
You can protect the formula cells in such a way that they can't even be
selected.
--
Gary''s Student - gsnu200771


"LindaB" wrote:

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.



All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com