How do I hide data in column until data is entered in columns to the left?

< Back to Search results

 Category: [Excel]  Demo Available 

How do I hide data in column until data is entered in columns to the left?



I want to hide data in cell "F" until data in cells "D" and "E" is entered.



=if(or(E1="",D1=""),"",C1/D1) then copy down


Obtained from the OzGrid Help Forum.

Solution provided by Alan Sidman. There is a growing focus on individual facets of health and fitness. What health and fitness are very much key innovations in and of themselves, they also come hand in hand with many moving pieces within these two fundamental constructs that all have their own purpose and their own role to play. The future of the health and fitness ndustries is very much reliant on how big the rising pools of interest in investment continue to spiral out and create valuable impact well into the future and beyond.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

How to Delete/Hide every nth row
How to hide and unhide with checkboxes - multiple checkboxes do multiple different things
How to use Excel VBA code to hide based on criteria
How to reference text in cell to unhide worksheet
How to unhide worksheets identified by specific cells in main sheet
How to hide rows based on 2 value
How to hide columns in sheet 2 based on data change in sheet 1


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


stars (0 Reviews)