Microsoft Excel Column Row Issue

Revision as of 12:23, 28 April 2014 by Cherneskim ws (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  • To fix Excel if the columns and rows are both numeric, follow the below instructions:
  • go to the micro soft office button. Click on "excel options" button at the bottom. Click on "formulas" on the left side of the screen. In the Working with Formulas section there is a box that is labeled "R1C1 reference style". Un-check the box to get the alpha column and numeric row system. If the box is checked then the columns and rows are both numeric - which makes for some very confusing formulas.