Excel Format as a Table
How to Apply Table Styles in Excel
Excel Training Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Besides applying table styles, you can format individual table style elements.
Table Style Options
- Click any cell in the table.
- Click the Design tab.
The formatting options available in the Table Style Options group include:
- Header Row: Toggles the table’s header row on and off.
- Total Row: Adds a total row to the bottom of the table. This option doesn’t just change formatting, but also allows you to calculate values in the total row.
- First/Last Column: Displays special formatting for the first or last columns in the table.
- Banded Rows/Columns: Displays odd and even rows and columns differently for easier readability.
- Select the option(s) you want to apply in the Table Style Options group.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
- LinkedIn-ready certificate
- Skill assessments
- Bite-sized, interactive lessons
- Saved progress