Excel Forum

Excel Magic Trick 691: Look At Cell C2 No Matter How Many Rows Or Columns You Insert Or Delete

See how to use the INDEX or INDIRECT functions to create a formula that will always point to cell C2 no matter how many rows or columns you insert or delete.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.