There's a fine line between a well-formatted Microsoft Excel worksheet and one that's full of issues that take time to fix. Whether you're an Excel newbie or a seasoned pro, avoiding these formatting ...

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 program that holds the report's data. A ...

Change Excel 2007 spreadsheets to tables for easier data analysis Your email has been sent Excel spreadsheets may be good for calculations, but reading them can be challenging. Here's how to convert ...

It’s not hard to add an alternating band format to a table by applying a table style. It’s quick and easy, but it’s limited. You’ll get a single-row fill color that alternates with a row of white (or ...

Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font, size and style. A spreadsheet may contain a number of tables, giving you several ...

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Excel puts lots of great tools on your desktop, but what each one of them does isn’t always obvious, especially since so many Excel features are hidden. Would you like to create multiple lines of text ...