Auto create formulas as data is entered

[SaraWitch]

Hello peeps,

Is there a way to continue the formulas when new data is entered in the next (bottom) row? In other words, I want the row formulas to apply wherever there is text. I don't want to assign formulas to the whole column as this increases the rows (and file size) unnecessarily. I wondered if there was a VBA I could use?

Ta muchly!

 

[Peter_SSs]

Make your data into a formal Excel table (Insert ribbon tab -> Table). Then as you add new rows to the table, any formulas in the other columns will automatically flow down

 

[SaraWitch]

I did try this, but it messes with my layout/formatting. Thank you anyway...

 

[Peter_SSs]

but it messes with my layout/formatting.

Can you give some details about that?


Do you have this setting in File -> Options -> Advanced?
It may help in some circumstances.