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.



Helen Bradley