Yet Excel can also copy formatting styles without copying cell contents, letting you apply the copied style to tables you've already filled. Click the upper left cell of the table you have formatted.

If your data contains spilled arrays, you can't format it as an Excel table. In this scenario, keep your manual table formatting to a minimum, such as using bold font in the column headers.

Detailed article outlines how to use Microsoft Excel to make data more useful, giving step by step instructions on using table formatting. Article uses sample data (which the user can download), and ...

An Excel conditional format rule. Finally, it’s time to create the conditional format rule that fills alternating groups in the Excel Table: Select the data, B3:F13.

See the screenshot below of the Excel spreadsheet after using Data Table for this example. I do not like one thing about this display — the reference in B9. I feel like it is confusing to a user ...