# Arrayformula on column header **URL:** \ **Category:** Ask for Help\ **Created:** [February 18, 2020, 10:11pm UTC](https://community.glideapps.com/t/arrayformula-on-column-header/4728 "2020-02-18T22:11:21Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [February 18, 2020, 10:26pm UTC](https://community.glideapps.com/t/arrayformula-on-column-header/4728/2 "2020-02-18T22:26:50Z")
Use this technique: > [@Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet](https://community.glideapps.com/t/using-arrayformula-s-in-row-1-of-your-spreadsheet/529): > > I can’t take credit for this tip but I just found out about this trick/tip by reading a post [here](https://community.glideapps.com/t/if-user-deletes-1st-row-he-loses-array-formula/246). So the “Normal” way of using an ARRAYFORMULA function is to use it in row 2 of a given column. You just have to be careful not to accidentally deleted it, or have a user delete it. So the next idea was to put it in row 2 but not put any other data in the row and then hide or minimize that row. Basically your data for the non ARRAYFORMULA columns would start on row 3. Then I saw the post I’ll l… --- _[View the full topic](https://community.glideapps.com/t/arrayformula-on-column-header/4728)._