Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Formula

 

Change an absolute reference back to a relative reference

In the cell with the absolute formula,             repeatedly press F4 until all the dollar signs are removed from the reference.