Hiding Formula Automatically
There is an Excel file that teaches how to perform the Hiding Formula Automatically operation.
Excel Template for Hiding Formula Automatically
This workbook demonstrates hiding formula automatically using VBA macros on a 2-row data layout.
Hope it is useful.