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.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Excel Tables offer a range of features for working with list-style data.

If you find yourself struggling trying to efficiently format large numbers in Excel spreadsheets. Manually adjusting figures to display in thousands or ...

Your worksheets will be more polished and easy to read if you learn a few sophisticated formatting techniques. Most Excel users know how to apply basic numeric and text formats. But users who push ...

In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that ...

All formatting will be lost if you attempt to save a JMP table to an existing Excel workbook. Copying the table from JMP and pasting it into the spreadsheet allows you to work around this issue.

How to Format a Sales Report in Excel. A sales report should reflect changes to its underlying data quickly and accurately. For that reason, it often makes sense to format a report in the same ...