To build the formula, follow these steps: The closest heading above each blank cell.Ĭurrently, blank cells in columns A and B are selected, and cell A3 is the active cell. Next, complete the following steps, to create a simple formula, that will copy the value from selected cells are only within the used data range, even though entire columns were selected.the first blank cell, A3, is the active cell.blank cells in colums A and B are selected.Then click OK, to close the Go To Special dialog boxĪfter you close the Go To Special dialog box:.

OR, press Alt + K (the underlined letter in the Blanks option).

In the Go To Special dialog box, click Blanks.

Press Alt + S to open the Go To Special dialog gox.

Press Ctrl + G to open the Go To window.

On the Excel Ribbon's Home tab, in the Editing group, click Find & Select.

Select columns A and B, that contain the blank cells.

To select the empty cells with Excel's built in Go To Special feature, follow these steps: The first main step is to select all the blank cells that you want to fill. 3) Change Formulas to Values 1) Select Empty Cells To fill the blank cells manually, there are 3 main steps:

Convert a row to a column in excel