Press the Control key and the Enter key together. This will select the last used cell in the entire column. 6 CTRL R keyboard shortcut to apply the formula on the column to the right Suppose you have made a column filled with Excel formulas like the following image.
Now in the Home tab under the Editing option select Fill and click on to the Down option.
Type any value in B3 and c3 cells you will see the answer in the D3 cell. You need to drag towards the right to apply the formula to the entire row. However Excel also has a different kind of cell range that omits the row number and pulls in all of the cells in the entire column. Type any value in B3 and c3 cells you will see the answer in the D3 cell.