The Create Table dialog box in Excel, with the range field highlighted, the header checkbox checked, and the OK button selected. A formatted table in Microsoft Excel.

How to add a PivotTable in Excel Let’s suppose that you track orders for t-shirt sales using the Table named TableSales, shown in Figure A . The t-shirts come in four sizes: Small, Medium, Large ...

Step 3: Click the A-Z button. This will alphabetize the table by the contents of the First Name column. You could also sort in reverse order by using the Z-A button. ... How to add a column in Excel ...

And that’s it. It took all of 20 seconds to create and format a table in Excel. How to use a Total row for quick calculations. Next, you’ll add calculations to your table.