Tag Archives: R1C1

Spotting Errors

By Sebastien Labonne | Published: November 17, 2009
In a workbook, I like to be consistent in the use of columns across all worksheets. If the first month of my model is in column L in one worksheet, then it will be the same in all sheets. I have found that this method is really useful in reading formulas because you can promptly see [...]
Posted in Tips | Also tagged , , , | Leave a comment

R1C1 Enlightenment

By Sebastien Labonne | Published: September 3, 2009
You might know that Excel has two different reference styles for formulas: A1 (default) R1C1 But why should you care? You might think the default A1 reference style is sufficient for you, but that would leave opportunities only the R1C1 reference style allows. Let’s first see the difference between both reference styles Reference Type A1 Style R1C1 Style Relative =A1 =R[ ± x ]C[ ± [...]
Posted in Excel Options | Also tagged , , , , , | 2 Comments

  • Email updates

    Enter your email address:

  • Share this blog

    Bookmark and Share

  • Recent Posts

  • Recent Comments

  • Meta

  • RSS The Financial Modeler

SEO Powered by Platinum SEO from Techblissonline