Basic Formatting

Data that is hard to read is data that gets ignored. Formatting is not about making things look pretty for the sake of it — it is about making your work clear, scannable, and professional. In this lesson we are going to cover all the essential formatting tools in Excel so you can turn a plain grid of numbers into something that actually communicates.

Formatting Lives in the Home Tab

Almost every formatting tool you will use day-to-day lives in the Home tab. You already got a quick tour of this in Lesson 3. Now we are going to go through each group properly and actually use them.

Let's start with a plain, unformatted sales table and build it up step by step so you can see exactly what each tool does:

All the data is there — but nothing stands out, nothing guides the eye, and the numbers have no formatting. Let's fix that.

Font Formatting

The Font group in the Home tab gives you control over how text and numbers look inside cells. The most useful tools here are bold, font size, font colour, and fill colour — and you will use them constantly.

Select the cells you want to format first, then apply. Here is what each tool does:

Alignment

The Alignment group controls where content sits inside a cell — horizontally (left, centre, right) and vertically (top, middle, bottom). By default, text aligns to the left and numbers align to the right. That default is actually meaningful — if you see a number left-aligned, it is probably stored as text, not a number, which will cause formula problems. Worth keeping in mind.

Two alignment tools deserve a special mention:

Wrap Text — when your text is too long to fit in a cell, Excel hides the overflow. Turning on Wrap Text makes the cell taller instead, showing all the text on multiple lines inside the cell. Very useful for notes columns or long descriptions.

Merge & Center — combines two or more selected cells into one and centers the content inside. Commonly used for report titles that span across multiple columns. Use it with care though — merged cells can cause problems with sorting and formulas, so avoid merging inside a data table.

Borders

Borders add lines around or between cells. The default grey grid you see in Excel is just a visual guide — it does not print unless you add actual borders. When you want clean-looking printed reports or dashboard tables, borders are what make cells look properly defined.

Select the cells you want to add borders to, then go to Home → Font group → Borders dropdown (the square icon with lines). You can apply borders to the outside of a selection, to all inner lines, to just the bottom of a cell, or customise exactly which sides get a border and what style and colour the line is.

The Format Painter

The Format Painter is one of those tools that feels small but saves an enormous amount of time. Here is the situation it solves — you spend five minutes getting one cell to look exactly right. Nice font, right size, good fill colour, correct alignment. Now you need thirty other cells to look the same. Do you redo all of that manually thirty times?

No. You click the cell that looks right, click the Format Painter button (the paintbrush icon in the Clipboard group), then click the cells you want to apply that formatting to. Done in one click.

If you need to apply the same formatting to multiple separate areas, double-click the Format Painter instead of single-clicking. It stays active and you can keep clicking cells one by one until you press Escape to turn it off.

Format as Table

The fastest way to make a data range look polished and professional is Format as Table, found in the Home tab under the Styles group. Select your data, click Format as Table, choose a style, and Excel transforms your plain range into a fully formatted table with alternating row colours, a styled header row, and built-in filter dropdowns — all in about three seconds.

Same data as before — but now it has a clear header, alternating row shading, and filter arrows. Instantly more readable.

Excel Tables also bring extra superpowers beyond looks — they expand automatically when you add new rows, formulas referencing a table update automatically, and you can reference table columns by name in formulas. We will use Excel Tables heavily throughout this course.

Conditional Formatting

Regular formatting is something you apply manually. Conditional formatting is formatting that Excel applies automatically based on rules you set. The cell colour, font colour, or icon changes depending on the value inside the cell — and it updates live as the data changes.

This is one of the most powerful visual tools in Excel. Here are the most useful things you can do with it:

To apply conditional formatting, select the range, go to Home → Conditional Formatting, and choose the rule type. You can also write custom formula-based rules for more advanced scenarios — like turning a whole row red if a deadline has passed. We will revisit conditional formatting in the dashboard lessons later in the course.

Clearing Formatting

Sometimes you inherit a file from someone else and the formatting is a mess — random colours, mixed fonts, inconsistent sizes. The fastest way to reset it is to select the cells and go to Home → Clear → Clear Formats. This removes all formatting without touching the data inside the cells.

Be careful not to click Clear All by accident — that deletes the data too. Clear Formats only removes the visual styling and leaves your numbers and text completely intact.

Next up — Number Formatting, where you will learn how to control exactly how numbers display in your cells — as currency, percentages, dates, and custom formats you design yourself.