Microsoft Excel

SWITCHING OFF TABLE FORMULA

Steps to Follow

  1. Click on File Tab
  2. Click On Options
  3. Click on Formulas
  4. Under Working with Formulas, uncheck “Use table names in formula”.
    You can also uncheck “Use GetPivotData functions for PivotTable references”
  5. Click Ok

CONVERTING RULER UNITS IN EXCEL

Steps to Follow

  1. Click on File Tab
  2. Click On Options
  3. Click on Advanced
  4. Under Display, on Ruler Units, select Millimeters from the drop down list
  5. Click Ok