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.
Select column A.
Press Ctrl+G to activate the Go To dialog.
Click Special...
Select Blanks, then click OK.
Enter the formula =A1 and confirm it with Ctrl+Enter to populate all selected cells.
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.