Absolute References

When Excel Columns become Numbers instead of Letters…

Using the R1C1 Cell Reference Style

aka Turning the R1C1 Address Option On and Off A client called me a while back with a terrifying problem: all of the column letters in Excel had become numbers and she had no idea how it got that way or how to write formulas anymore. Rest assured, it was not the beginning of the… Keep Reading