MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I copy formulas so that the row definition remains the same and doesn't increment


Posted by Jeff on January 09, 2002 7:55 AM

How do I copy formulas so that the row definition remains the same and doesn't increment


Posted by Juan Pablo G. on January 09, 2002 7:57 AM

Use absolute references, like A$1. The '$' fixes the row in this case. Then you can copy it and it will keep pointing to row 1.

Juan Pablo G.

Posted by Mark W. on January 09, 2002 7:57 AM

Use absolute references (e.g., $A$1) (nt)