HOW DO I COPY A FORMULA KEEPING A CELL VALUE

[DUKITTY]

I CANT FIGURE OUT HOW TO DRAG A FORMULA TO COPY DOWN A COLUMN & KEEPING THE
FIRST PART TH E SAME. SUCH AS (E6*D10) (E6*D11) (E6*D12) (E6*D13) AND SO ON

 

[Robin Hammond]

To keep the row reference, change the original formula to E$6. To keep a
column ref, $E6, to keep a fixed cell ref, $E$6.

Robin Hammond
www.enhanceddatasystems.com