Conventionally, we label cells in Excel by their column letter and row number. This works great for most situations.
But, it works poorly if we have formulas in different cells that are repetitive; especially if they mix absolute and relative addresses.
Excel has an alternative addressing scheme for this, that you can turn on through the Formulas tab on the Option menu under "File" on the ribbon. It's called R1C1. R1C1 addresses state all formulas in terms of rows or columns from the current position. This is extremely useful for repetitive formulas becuase oftentimes you are referencing cells that are the same number of rows and columns from the cell where the formula is: so that all the formulas look just about the same.
No comments:
Post a Comment