How to Make a Table in Excel: 8 Steps to a Clean, Readable Spreadsheet
Enter everything first, then format at the end. Using a sales table as an example, here are 8 steps to a readable table.
2026-11-10
Key points
- 1Add borders and colors after the data is in
- 2Align text left, numbers right, and add thousands separators
- 3Cut vertical lines and use two colors at most: headers and emphasis
Before and after
The same data gets much easier to read just by changing alignment, lines, and colors.
| Item | Rep | Qty | Amount |
| Notebook | Smith | 12 | 18000 |
| Pen | Johnson | 5 | 1250.5 |
| File | Williams | 30 | 36000 |
| Total | 47 | 55250.5 |
| Item | Rep | Qty | Amount |
| Notebook | Smith | 12 | 18,000 |
| Pen | Johnson | 5 | 1,251 |
| File | Williams | 30 | 36,000 |
| Total | 47 | 55,251 |
About the keys
Key sequences starting with Alt are for Excel for Windows. On a Mac, use the buttons on the Home tab.
1Enter the table contents
Enter the headers, data, and total formulas first. If you add lines and colors along the way, you will fix them every time you add a row.
- Put column headers in row 1
- One record per row
- No blank rows or columns inside the table
- No merged cells in the data
Merged cells get in the way of sorting and filtering. See merging cells for details.
2Use one font and size
Click inside the table and press Ctrl + A to select it, then set the font and size on the Home tab. Press Ctrl + A again to select the whole sheet.
For emphasis, bold keeps the table's shape better than a bigger font.
3Align text left and numbers right
Right-aligned numbers line up by digit, so values are easy to compare. Align each header the same way as its column.
| Description | Alignment | Keys (Windows) |
|---|---|---|
| Text such as item or person names | Align Left | Alt → H → A → L |
| Numbers such as amounts or quantities | Align Right | Alt → H → A → R |
| Short values of equal width, such as "Yes" or "✓" | Center | Alt → H → A → C |
4Add thousands separators
Add a comma every three digits to amounts, and use the same number of decimal places within a column.
| Action | Ribbon | Keys (Windows) |
|---|---|---|
| Add thousands separators | Home → Comma Style | Alt → H → K |
| Add a decimal place | Home → Increase Decimal | Alt → H → 0 |
| Remove a decimal place | Home → Decrease Decimal | Alt → H → 9 |
To show values in thousands or add units such as "pcs", use custom number formats.
5Adjust column widths
Select the columns and press Alt → H → O → I to fit them to their contents. With a mouse, double-click the right edge of the column heading.
If a number shows as "####", the column is too narrow. Widen it and the number appears.
6Use mostly horizontal borders
Horizontal lines alone look cleaner than boxing every cell.
- Draw a line under the headers
- Use thin lines between data rows
- Put a line above the total and a double line below it
- Avoid vertical lines where you can
See how to add borders for the steps.
7Limit yourself to two colors
With too many colors, nothing stands out. Stick to two: one for headers and one for emphasis.
| Where | Example colors |
|---|---|
| Headers | White text on a dark fill, or black text on a light gray fill |
| Cells to highlight | A single light yellow or light red |
| Negative numbers | Red text |
Open Fill Color with Alt → H → H and Font Color with Alt → H → F → C.
Color cells automatically
To color cells based on their values, such as rows below target, use conditional formatting. The colors update when the data changes.
8Hide gridlines and freeze the headers
Hiding gridlines leaves only the borders you drew. For long tables, also freeze the header row.
| Action | Ribbon | Keys (Windows) |
|---|---|---|
| Hide gridlines | View → clear Gridlines | Alt → W → V → G |
| Freeze the top row | View → Freeze Panes → Freeze Top Row | Alt → W → F → R |
Format everything at once with Ctrl+T
In a hurry? Select a cell in the table, press Ctrl + T (⌘ + T on a Mac), make sure "My table has headers" is checked, and click OK. You get header colors, banded rows, and filters in one step.
Note
You can't merge cells inside a table.
Final checklist
- One font and size throughout
- Numbers are right-aligned with thousands separators
- Same number of decimal places in each column
- No text is cut off
- No "####"
- Two colors at most: headers and emphasis
- Headers are frozen on long tables
FAQ
QWhich cell should a table start in?
Start data tables at A1. For tables you present, narrow column A and start at B2; the margin makes them easier to read.
QWhere should the table title go?
Put it above the table with one blank row in between. The blank row keeps Excel from treating the title as part of the table when sorting.
QWhen should I add cell colors?
After the data and formulas are done. If you want colors that hold up when rows are added, use a table or conditional formatting.
Guides and practice
Readable Spreadsheet Drill →
36 exercises that fix hard-to-read tables in a virtual Excel
Merge Cells →
Merging and unmerging, and centering without merging
Conditional Formatting →
Colors based on values: whole rows, multiple conditions, weekends
Custom Number Formats →
Thousands, units, red negatives, dates with weekdays
Hide Zeros →
Whole sheet, some cells, or a formula, and when to use each
Border →
Choosing lines, double lines under totals, removing stubborn lines