Forum Discussion
Is there a formula to auto fill down text?
So I selected the range and did as you suggested. All of the correct blank cells were highlighted. I used the formula =A6.
Now, instead of '0' appearing in all the blanks, 'A6' is what appears.
I tried the IF function in the helper column, as suggested by adversi. The same thing happened and 'A6' is what appeared as a result.
Are there any settings I need to adjust for the cells?
Thanks.
Each of the steps seem to lead me in the right direction until I get to the last step of enter '=A1 and press enter.' All of the blank cells are highlighted but the data is not filling.
I do have column headings in Row 5 so my client data starts in A6. Rows 1 - 4 include a title/description of the report I am trying to create.
You should press Ctrl+Enter, as I wrote in my previous reply.
- I went ahead an pressed ok, but all the blanks were filled in with a '0'.
Did you enter =A2 by accident? =A1 should work:
Left: before entering formula, right:after entering formula and pressing Ctrl+Enter.