Benefits of working with format as Table feature:
Found on the Home tab next to Conditional Formatting
- Freeze Pane is activated
- Sort/Filter is Activated
- Last row can be set as a Totals row.
- New Records are created by pressing TAB on the last cell or the last record without disturbing your summary total
- As your records and column headings grow they are kept together as a database. Making it a dynamic data set to use with Pivot tables and charts. Saves the need for creating an Offset function.
Ensure there are no blank columns or rows.
Tip: If need to use Subtotalling must turn off Table Feature.
Press convert to Range