Question

how to refer the all cells in column D IN EXCEL

Answer 1

To create and copy a formula using relative references:

Select the cell that will contain the formula. ...

Enter the formula to calculate the desired value. ...

Press Enter on your keyboard. ...

Locate the fill handle in the bottom-right corner of the desired cell. ...

Click and drag the fill handle over the cells you want to fill

Answer 2

Referring to all cells in column IN EXCEL

In an Excel worksheet that has multiple rows, the user may require to refer to all of the cells within a specific column. An entire column reference can be absolute or relative.

The following are the options to reference the whole column in the excel worksheet.  

• Absolute column reference, as $Column Name:$Column Name like $A:$A
• Relative column reference, as Column Name: Column Name like A:A