How to Select Cells in Excel 2013 with Go To
How to Select Cells in Excel 2013
How to Merge Custom Styles into Other Excel 2013 Workbooks

Format Tables with the Quick Analysis Tool in Excel 2013

You can use Excel’s new Quick Analysis tool to format your data as a new table. Simply select all the cells in the table, including the cells in the first row with the column headings. As soon as you do, the Quick Analysis tool appears in the lower-right corner of the cell selection (the outlined button with the lightning bolt striking the selected data icon).

When you click this tool, the Quick Analysis options palette appears with five tabs (Formatting, Charts, Totals, Tables, and Sparklines).

Click the Tables tab in the Quick Analysis tool’s option palette to display its Table and Pivot Table buttons. When you highlight the Table button on the Tables tab, Excel’s Live Preview shows you how the selected data will appear formatted as a table. To apply this previewed formatting and format the selected cell range as a table, you have only to click the Table button.


As soon as you click the Table button, the Quick Analysis options palette disappears and the Design contextual table appears on the Ribbon. You can then use its Quick Styles drop-down gallery to select a different formatting style for your table. (The Tables button on the Quick Analysis tool’s Tables tab offers only the one blue medium style shown in the Live Preview.)

blog comments powered by Disqus
How to Use the Excel 2013 Format Painter
How to Add Comments to Excel 2013 Worksheet Cells
How to Create a Custom Cell Style in Excel 2013
Format Dates and Times in Your Excel Reports
Format Cell Ranges with the Mini-Toolbar in Excel 2013