10 reasons to use Excel's table object

10 reasons to use Excel's table object
27 July 2013

Excel tables offer several advantages over data ranges. Here's a look at some of the handy things tables enable you to do:

  • Easy sorting and filtering.
  • Quick formatting.
  • Effortless data entry.
  • Automatic nomenclature.
  • Quick totals.
  • Always visible headers.
  • Formula autofill.
  • No copy necessary.
  • Dynamic charts.
  • One-click select.