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.
If cell A1 is blank, the formula cannot fill in a name. You should select a range from the first non-blank cell down.
After the blanks have been selected, look at the address box on the left hand side of the formula bar.
You'll see the address of the active cell.
The formula should refer to the cell above that. So if the active cell is A7, the formula should be
=A6
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.
IT WORKED!!! Thanks so much for sticking with me to help me get this figured out!
The issue was the number format was changing to text so I set it to general prior to going through the steps.
Make sure that the number format is not set to Text and that 'Show Formulas' on the Formulas tab of the ribbon is not highlighted.