Often when you’re working in Excel you won’t enter all the data because it is repetitive.
In this example, the cells in column B really should be filled with the months but because the month only changes periodically I have only typed it when the change occurs. If I need to work with this data such as in a PivotTable it may be necessary to fill the data down column B.
This can be done easily by selecting the cells in column B and choose the Home tab on the Ribbon, click Find & Select > Go To Special > Blanks to select the blank cells.
Type =B2 in the cell, this represents the first cell in column B with the data in it.
Press Control + Enter.
Now, to fix the cells so they contain words and not cell references, select all the filled cells in column B, choose Edit > Copy and then Paste > Values and click Ok.
Danke Shön, I’ve been working in some DB and this is a very handy trick. And not too hard to remember.
Thanks! This was perfect for what I wanted to do!
I am getting a message to say “no Blanks Found”, but there definitely are blanks. Am I doing something wrong?