Tip 294 – Quickly convert a range to a table

Converting a range to a table gives you instant filters and totals for each column. To do this quickly, select the cells you want to convert to a table and press the CTRL and T keys together. Once inserted, click the Table Design tab to add totals and control the formatting of the table.