I used to play formula roulette every time I dragged the fill handle, hoping Excel wouldn't misinterpret my intentions. Was I supposed to lock the column, the row, or both? Then, the dollar signs ...
How-To Geek on MSN
How to use R1C1 referencing style in Microsoft Excel
R1C1 coordinates provide a predictable map for auditing formulas and writing universal VBA macros.
This useful application MS Excel uses tables to store and analyze mathematical data using formulas and functions and your office work is incomplete without this app. Like all software, it can have ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results