Basic Formatting in Excel: A Beginner’s Guide

Basic formatting in Excel is what separates a spreadsheet that makes people squint from one that makes them say, “Oh, this is clear.” Picture this: you have just finished typing up your monthly budget. Every number is right. Every label is correct. You hit send to your manager or your partner or save it for yourself, and then you look at it again. It looks like a tax form from 1987. Flat, grey, and overwhelming.

That is the problem basic formatting in Excel solves. And here is the good news: it takes less than ten minutes to learn the essentials, and it will change how every spreadsheet you ever make looks and feels.

In this lesson, you will learn about fonts, colors, number formats, borders, alignment, Format Painter, and how to clear formatting when things go sideways. Every tool is explained simply, with real examples you can follow along with right now. Let us get into it.

What Is Basic Formatting in Excel? (And Will It Change Your Data?)

Before you click anything, let us kill the biggest fear beginners have about formatting: will it change my data? No. Not even slightly. Here is the thing: formatting and data are two completely separate things in Excel. Your data is the actual content sitting inside a cell — a number, a word, a date, a formula result. Formatting is a visual layer on top of that content that controls only how it appears.

Think of it like a digital picture frame. You put a gold frame around a photo, and the photo stays exactly the same. The frame just makes it look better. Same idea here.

Formatting vs. Data: What Is the Difference?

Say cell A1 contains the number 1500. You format it as currency. It now shows as $1,500.00. But the cell still holds 1500. Any formula that uses A1 still calculates with 1500. Nothing broke. Nothing changed. You just told Excel to dress that number up a little.

Once you truly internalize this, you will stop hesitating and just format freely. That is the mindset you want.

Where Are the Formatting Tools in Excel?

Almost everything you need for basic formatting in Excel lives on the Home tab of the Ribbon. Click Home, and you will see groups labelled Font, Alignment, and Number. Those three groups are your main playground for this lesson.

There is also one dialog box you are going to love: the Format Cells dialog. Press Ctrl+1 on your keyboard, and it opens. It contains every formatting option Excel has in one organized place. Bookmark that shortcut in your brain right now.

If you are still getting your bearings in the Ribbon, take a look at Lesson 2 on navigating the Excel Ribbon over on XplorExcel.com. It will make everything click faster.

How to Format Fonts in Excel (Bold, Italic, Size, and More)

Font formatting is your first and most basic tool. It is how you create visual hierarchy — meaning some text looks more important than other text. Headers look different from regular data. Totals stand out from individual values. All of that starts here.

Making Text Bold, Italic, or Underlined: Excel Bold Italic

These three are the tools you will use most. Select a cell first, then pick your option from the Font group on the Home tab.

• Bold makes text heavier and more prominent. Use it for headers and total rows.
• Italic tilts the text slightly. Good for notes, units, or secondary labels.
• Underline draws a line under text. Use sparingly since it can look like a cell border and confuse people.

Trust me on this: learn the keyboard shortcuts right away. They will save you a lot of time.

Changing Font Type and Size

Excel defaults to Calibri size 11. That is perfectly fine for body data. But headers often benefit from being size 14 or 16, and sometimes a project calls for a different font entirely. To change the font, click the Font Name dropdown on the Home tab. To change size, click the Font Size box and type a number or choose from the list.

One rule worth following: stick to one font per spreadsheet. Change sizes for hierarchy. Using three different fonts in one sheet makes it look unplanned.

How to Use Excel Font Color and Cell Fill Color

Color is genuinely powerful in a spreadsheet when used with intention. You have probably seen those clean professional dashboards where headers are dark blue, and totals are highlighted. That is all just font color and fill color, used consistently.

Changing Font Color for Readability

Select your cell, then click the small dropdown arrow next to the Font Color button on the Home tab — it is the letter A with a colored bar underneath it. A color palette appears. Click your color.

Dark tones work best for readability. Dark red or dark blue on white reads clearly from across a room. The Excel font color feature is especially useful for negative numbers — many accountants manually color them red so they pop immediately without any formulas needed.

Adding Fill Color to Highlight Important Cells

Fill color puts a background color behind your cell content. Select the cell, click the dropdown arrow on the Fill Color button (the paint bucket icon on the Home tab), and choose your color.

The best advice here is to use fill color for structure, not decoration. Headers get one color. Totals get a shade of that color. Input cells might get a light yellow. Everything else stays white.

Practical Example: Color-Coding a Budget Sheet

Here is a relatable scenario. You are building a monthly budget with income rows and expense rows mixed together. You add a light green fill to income rows and a light red fill to expense rows. Now, anyone who opens that file — including future you — understands the structure before reading a single word.

That is the actual purpose of basic formatting in Excel. Not making things pretty. Making things understood.

Excel Number Format: Displaying Your Data the Right Way

Here is the thing that trips up almost every beginner: the number displayed in a cell is not always the same as the number stored in that cell. Number formatting is what controls what you see. And this matters more than you think.

General vs. Number vs. Currency vs. Percentage

Excel applies a format called General to every new cell by default. General means Excel takes a guess at what your value is and displays it without much styling. Here are the four formats you will reach for most often:

How to Format Dates in Excel

The same date value can look totally different depending on the format. It might appear as 19/04/2026, April 19 2026, or 19-Apr-26. None of these is wrong — it depends on context.

To control this, select the cell, press Ctrl+1, click the Number tab, and choose Date from the Category list. You will see previews of each available format on the right. Click through them and watch the preview until you find one that works.

Using the Format Cells Dialog (Ctrl+1) for Custom Formats

The Format Cells dialog is the full control panel for all Excel cell formatting. Six tabs: Number, Alignment, Font, Border, Fill, Protection. You will live in the first five. Get into the habit of using Ctrl+1 instead of hunting around the Ribbon.

How to Add Excel Cell Borders (And Why They Are Not Gridlines)

You have probably seen this happen. Someone builds a spreadsheet, it looks fine on screen, they print it, and the lines are gone — just numbers floating in white space. That is the gridlines vs borders confusion, and it trips up nearly every beginner.

Borders vs. Gridlines: The Difference Beginners Miss

Gridlines are the faint grey lines you see on every blank Excel sheet. Screen display guide only. Do not print by default. Cannot be styled.

Borders are the actual formatting you apply manually to specific cells. They do print. You control thickness, color, and which sides they appear on.

So if you want lines to appear when printed, you need Excel cell borders. Gridlines are just there to help you see where you are while you work.

Adding and Customizing Cell Borders Step by Step

When to Use Borders

• Your sheet is going to be printed
• You are creating a data table that needs a clear visual separation
• You are building a dashboard or report with distinct sections

For more in-depth guidance, Microsoft’s official support page on applying or removing cell borders is worth bookmarking.

Cell Alignment, Wrap Text, and Merge & Center

Alignment is one of those things that people do not notice when it is right, but they absolutely notice when it is wrong. A column of numbers that is left-aligned looks messy. A header that is center-aligned looks intentional. The details matter.

Horizontal and Vertical Alignment Options

Horizontal alignment sits in the Alignment group on the Home tab: three buttons for left, center, and right.

• Left align: best for text, names, labels, and descriptions.
• Center align: best for column headers, short values like Yes/No, and titles.
• Right align: best for numbers — digits line up vertically and are much easier to compare at a glance.

Vertical alignment controls where content sits inside a tall row. Top, middle, or bottom. Middle usually looks the cleanest.

Using Wrap Text to Show Long Content Cleanly

Type a long sentence into a cell, and one of two things happens: it spills into the next column visually, or it gets cut off if the next cell has content. Neither is ideal. Wrap Text makes the cell expand vertically so all of the text is visible within that single cell.

Click the Wrap Text button in the Alignment group on the Home tab, or find it in the Alignment tab of the Format Cells dialog (Ctrl+1).

Merge & Center for Headers (And When Not to Use It)

Merge and Center joins multiple cells into one and centers the content. It looks great for a sheet title that spans across several columns. Select the cells, then click Merge & Center in the Alignment group.

Format Painter: Copy Formatting in One Click

You have probably seen a perfectly formatted section of a spreadsheet and thought: How do I make the rest of it match without manually redoing everything? Format Painter is the answer.

How to Use Format Painter

Locking Format Painter for Multiple Cells

Single-clicking Format Painter lets you paint one selection, and then it turns off. If you need to apply the same formatting to several separate areas, double-click the Format Painter button instead. This locks it on. Press Escape when you are finished.

How to Clear Formatting in Excel Without Deleting Data

Sometimes you open a file someone else made, and the formatting is a complete disaster. Clashing colors, random bold cells everywhere, date columns formatted as plain numbers. You want to start fresh without wiping the actual data.

Basic Formatting in Excel: Putting It All Together

You have now learned each tool individually. Here is where basic formatting in Excel stops feeling like a list of buttons and starts feeling like a real skill.

Before & After: A Simple Budget Sheet Transformation

Take a simple sheet with three columns: Category, Amount, and Month. All the data is there, but it is raw and flat. Now apply what you have learned:

Quick-Reference Checklist: 8 Formatting Steps for Any Sheet

• ✓ Header row: bold, fill color, center-aligned
• ✓ Number columns: currency, percentage, or number with a comma separator
• ✓ Date columns: formatted as a readable date, not a plain number
• ✓ Borders applied if the sheet will be printed or shared formally
• ✓ Alignment checked: numbers right-aligned, text left-aligned, headers centered
• ✓ Fill colors used sparingly for totals, sections, and key highlights
• ✓ Wrap Text applied where content is getting cut off
• ✓ Format Painter used to copy consistent formatting across sections

What’s Next? Continue Your Excel Journey

You have now covered all the essentials of basic formatting in Excel. These are skills you will use in every spreadsheet you ever build — whether it is a personal budget, a school project, a work report, or anything else.

When you are ready to level up, the next lesson covers Basic Formulas in Excel, where you will start making your spreadsheet actually calculate things automatically. It is where Excel really starts to feel powerful.

And if you want to make sure your data entry habits are setting you up for clean formatting from the start, Lesson 3 on entering and editing data in Excel is worth revisiting. Good data makes good formatting easier every time.