Quick LinksHide Cell ValuesReplace Zeros With a DashTurn Values to Text Based on a ConditionColor Numbers Based on Their ...

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 tabl ...

In this story, we’ll get you up and running with tables in Excel, from creating and formatting them to performing calculations on their data. Below is the sample data we will be using, if you ...

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.

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.

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 ...

Finally, it’s time to create the conditional format rule that fills alternating groups in the Excel Table: Select the data, B3:F13. (Don’t include the column of consecutive values in column H.) ...