auto hide row

[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

 

[Frank Kabel]

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

 

[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(A11), and AutoFilter on that column to display only
rows where the value is <4

 

[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

 

[Frank Kabel]

Hi
why not use 'Data - filter - autofilter' for this