Formula Formating

R

Ryha

How do i formulate the formula in the cell without having doing the pasting
to all the cell wanted and adjusting the formula. Since the formula change
when the cell is in the different cell row and column.

Thank you
 
R

Roger Govier

Hi

You need to change some of your cell references to Absolute instead of
Relative

$A1 locks column letter when copying across the sheet
A$1 locks the row number when copying down the sheet
$A$1 locks both column and row
A1 allows both column and row to adjust as copying takes place.

With the cell reference highlighted in the Formula Bar, repeatedly
pressing F4 will cycle the reference through the 3 different modes.
 
Top