Hey everyone,
I recently was in need of a procedure where multiple headings required filling down. Kind of like
From this
Bean
""
""
Axel
""
Frog
""
""
""
To this
Bean
Bean
Bean
Axel
Axel
Frog
Frog
Frog
Frog
an easy way of doing it was selecting the column and using F5 key; selecting blanks and Ctrl + Enter. This works great with values, however, with formulas its a different story. What might be a solution here if I needed to copy/fill down formulas multiple times for each formula based heading.
Thanks and will appreciate.
I recently was in need of a procedure where multiple headings required filling down. Kind of like
From this
Bean
""
""
Axel
""
Frog
""
""
""
To this
Bean
Bean
Bean
Axel
Axel
Frog
Frog
Frog
Frog
an easy way of doing it was selecting the column and using F5 key; selecting blanks and Ctrl + Enter. This works great with values, however, with formulas its a different story. What might be a solution here if I needed to copy/fill down formulas multiple times for each formula based heading.
Thanks and will appreciate.