Link to home
Start Free TrialLog in
Avatar of Tom M
Tom M

asked on

Make extra results go away until data is inputed

tammy.xlsx
Please take a look at the attached you will see entries in rows 9 thru 44 in columns N and O.  I would like those cells to be blank until data is inputed columns K & L
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Go to Formulas > Calculation Options > Change from "Automatic" to "Manual"
Then you can change back to Automatic when done, or use Ctrl+Alt+F9 
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial