auto hide row

T

tommyboy

Is it possible to hide a comple row when a number of the cells in tha
row have data in them

So if i was entering data into a1,a2,a3 and a4 , once all 4 of thes
contained data it automatically hides the line so i can start enterin
data into the next row

and so o
 
F

Frank Kabel

Hi
should this happen automatically after inserting the values. And if yes
how do you want to change them afterwards?
 
M

Myrna Larson

Or, for that matter, just look at the screen to double-check your entries.
Personally, I would prefer a solution where, say in the 4th column you had a
formula like =COUNTA(A1:D1), and AutoFilter on that column to display only
rows where the value is <4
 
T

tommyboy

was thinking this may be problematic,

can you enter a button or check box at the end of the row in say colum
g to hide the line then have a button at the top to unhide all hidde
rows then hide all the rows bac
 
Top