Formatting Basics

Lesson 7: Format: Align, Bold, Italic, Underline

S M L XL FS | Slo Reg Fast 2x | Bookmark

In Lesson 7, we will start exploring spreadsheet formatting to make your work look more professional. I will show you how to adjust cell alignment, select and format cell ranges, and use the bold, italics, and underline options for your data. We will discuss the differences between text and number alignment, how to efficiently format multiple cells at once, and explain what a cell range is. These formatting techniques will help improve the appearance of your spreadsheets.

Navigation

Prev: Lesson 06
Next: Lesson 08

Keywords

TechHelp Excel, spreadsheet formatting, cell alignment, bold cells, italics, underline, select multiple cells, cell ranges, horizontal alignment, vertical alignment, Excel formatting, column headers, font group, cell selection, undo formatting

Subscribe to Formatting Basics
Get notifications when this page is updated

Intro

Transcript

In lesson 7, we are going to start looking at how to format our spreadsheets to make them look more professional. We will learn about cell alignment, cell ranges, bold, italics, and underline.

Now that we know how to enter data into a spreadsheet and edit that data, let's learn how to format the spreadsheet to make it look a little more professional.

The first change I would like to make involves the column headers. Notice how January, February, March, and April line up on the left side of each cell, but the numbers underneath them line up on the right. It makes for a very messy column.

This is the way that Excel was designed. Text values will always line up on the left side of the cell, whereas numeric values and dates and things like currency amounts will line up on the right side of the cell.

You can change the alignment of a cell using the alignment functions up here in the alignment group on the Home tab. Right here you can see Align Left, Center, and Align Right.

The first thing you have to do is click on the cell you want to change. In this case, I'll click on cell B1. You can come up here in the alignment group and click on Align Text Right. That will change that cell so all the data in it lines up to the right side. This makes it so the column header lines up nicely over the data in that column.

You can also click on Center or Align Left if you like, but I am going to bring it back to Align Right.

Do not confuse the horizontal alignment with the vertical alignment. These three buttons up here will align the value to the top, middle, or bottom of the cell if you have a tall row. We will see how this works in a future lesson.

I can sit here and do each one of these cells one at a time by clicking on them and then clicking on Align Right. This is not too bad only having four cells to do, but what if I had 40 cells? That would take a long time. There has to be a more efficient way to apply a single formatting command to multiple cells.

So, I am going to undo that. I am going to come up here and click on the Undo button a couple of times. Undo, undo, undo, undo, and I put them all back the way they were when we started this lesson.

It would be nice if there were a way I could change the alignment for all four of those cells with one command. In order to do that, we have to select multiple cells.

You can select multiple cells by moving your mouse over the middle of the first cell, click, and then drag to select additional cells. I have now selected a range of cells from B1 to E1.

Now if I make any change, for example, Align Text Right, it affects all of the selected cells in that range. Cell ranges can be horizontal like that one. They can also be vertical, such as that range from A2 to A5, or they can be both horizontal and vertical.

For example, this is a range right here from C2 to E5. This range shown here from B2 to E2 is represented by B2:E2. We will see a lot more of this when we start dealing with formulas and functions. That is how you refer to a particular range. It is the starting cell, colon, the ending cell. This range is C3:D5. It starts at C3 and it goes down to D5.

Do not worry too much about this right now. You are not going to be quizzed on it, but I just want to expose you to it so later on when we get to formulas and functions, you have seen it and you are a little more familiar with it.

A cell range is simply defined by its upper left cell followed by a colon, followed by its bottom right cell.

Now the next thing that I would like to do is to bold my column headers. I will take my mouse and I will click and drag to select A1 through E1, let the mouse button go. Then I will come up here and click on the B for Bold button in the font group on the Home tab and that will bold all the selected cells, A1 through E1.

If I click off of them over here somewhere, it makes it easier to notice. If for any reason you decide you do not want those cells to be bolded, simply select them again and click on Bold. That turns off the bold feature. Remember I mentioned that a little while ago. Some switches are simple toggle buttons. Click to turn it on, click to turn it off. I will leave them bolded though.

The same techniques work for italics and underline. Let's say you want to italicize the cells Rep Names, I will select A2 through A5 and click on the Italics button. I have just italicized the cells Rep Names. And yes, of course you can combine bold with italics.

If you want to italicize Cells Rep as well, you can do that. I will turn it back off though.

Quiz

Q1. How does Excel align text values in cells by default?
A. Text values are aligned to the left side of the cell
B. Text values are centered in the cell
C. Text values are aligned to the right side
D. Text values are adjusted based on the data below

Q2. What is the default alignment for numeric values in Excel?
A. Centered in the cell
B. Aligned to the left
C. Aligned to the right
D. Aligned to the top

Q3. Which group on the Home tab contains the alignment functions in Excel?
A. Font group
B. Alignment group
C. Number group
D. Editing group

Q4. Which button would you click to right-align the text in a cell?
A. Align Left
B. Center
C. Align Right
D. Justify

Q5. What does selecting a range of cells allow you to do?
A. Enter the same value in multiple cells automatically
B. Apply formatting commands to multiple cells at once
C. Delete all selected cells at once
D. Merge the cells into one

Q6. How is a range from cell B2 to E2 represented?
A. B2-B6
B. B2:E2
C. E2:B2
D. B2..E2

Q7. What happens if you click the Bold button on already bolded cells?
A. It italicizes the text
B. It underlines the text
C. It removes the bold formatting
D. It does nothing

Q8. When formatting cells, which of the following is NOT mentioned in the lesson?
A. Bold
B. Italics
C. Underline
D. Strikethrough

Q9. To apply italics formatting to cells A2 through A5, what should you do first?
A. Type 'Italics' in the cells
B. Select cells A2 through A5 and click the Italics button
C. Double-click each cell
D. Use the Merge & Center button

Q10. Which of the following is the correct way to specify a cell range in Excel?
A. StartCell-EndCell
B. Row:Column
C. StartCell:EndCell
D. [StartCell, EndCell]

Answers: 1-A; 2-C; 3-B; 4-C; 5-B; 6-B; 7-C; 8-D; 9-B; 10-C

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Excel Learning Zone is all about making your spreadsheets look more polished and professional by learning how to format your data properly. Now that you are comfortable with entering and editing information in your Excel sheets, it is time to focus on presentation.

Let's start by addressing the way column headers are displayed. You might notice that while your months like January, February, March, and April are all left-aligned at the top of your columns, the numbers underneath those headers are right-aligned. This mismatch can make the spreadsheet look a bit untidy.

Excel is set up so that text values will naturally align to the left edge of the cell, while numbers, dates, and currencies align to the right. However, you can control this alignment and make everything line up to your liking by using the alignment options found in the Alignment group on the Home tab. Here, you have options for left, center, and right alignment.

If you want a header like January in cell B1 to match the alignment of the numbers below, you just need to select that cell and then apply right alignment. Now the header is right-aligned and lines up neatly with the numbers in that column. Of course, you can also choose left or center alignment, depending on how you want your spreadsheet to look.

It is important not to confuse horizontal alignment with vertical alignment. In Excel, there are separate controls to align your content to the top, middle, or bottom of a cell, which is especially useful when your rows are taller. We will look at vertical alignment in more detail in an upcoming lesson.

If you only have a few headers, it is not so bad to manually set the alignment for each one. But what if you have dozens? Going one by one would be time-consuming. Instead, you can select multiple cells at once and format them together.

To do this, simply select the range of cells you want to update. For example, if you want to change the alignment for four months across the top, select those four cells as a group. Any formatting change you make now, such as right-aligning, will apply to all selected cells in that range. Ranges can be horizontal, vertical, or even cover a block of cells.

Excel refers to these ranges using the upper-left cell and the bottom-right cell, separated by a colon. For example, B2:E2 means the cells from B2 to E2. You do not need to memorize all the notation right now, but it helps to be exposed to these concepts as we move toward working with formulas and functions.

After aligning your headers, bolding them is another simple way to highlight important information. By selecting your headers and applying the bold option in the Font group, you make those labels stand out. If you change your mind, you can simply select them again and toggle off bold - the button works as a switch.

The same process goes for italics and underline. If you want to italicize a set of cells, such as your sales rep names, select the relevant cells and then apply italics from the toolbar. Bold, italics, and underline can all be used in combination or toggled off as needed.

That wraps up the introduction to cell alignment, ranges, and basic font formatting. Each of these adjustments only takes a moment but goes a long way toward making your spreadsheets appear more organized and professional.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Understanding default cell alignment for text and numbers
Changing horizontal cell alignment
Using the alignment group in the Home tab
Selecting single and multiple cells
Selecting cell ranges
Formatting multiple cells at once
Defining and understanding cell ranges
Bolding column headers
Using toggle buttons for formatting
Applying italics to cell ranges
Combining bold and italics formatting

Article

When you are working in Excel, making your spreadsheet look clean and professional is just as important as entering accurate data. Formatting your spreadsheet can help your data stand out and make it easier to read. One of the first steps in creating a well-organized sheet is adjusting how your content is aligned and formatted.

Take a look at your column headers, such as January, February, March, or April. You might notice that the text for these headers is aligned to the left side of the cell, while the numbers listed underneath are aligned to the right. This difference in alignment can make your columns look messy or uneven. This is how Excel works by default. Text is always lined up on the left of the cell, while numbers, dates, and currency are lined up on the right. Fortunately, you can change the alignment of any cell using the alignment tools on the Home tab, usually found in the alignment group. There, you will see options like Align Left, Center, and Align Right.

To change the alignment, first click on the cell you want to change. For example, select cell B1, then click the Align Text Right button in the alignment section. Now the text will line up with the numbers below, making your column neater. You can also choose Center or Align Left if you prefer, but aligning your headers to the right often helps them match up with the data in the column.

Be careful not to mix up horizontal alignment with vertical alignment. The main alignment buttons will move your content to the left, center, or right within the cell. There are also buttons to align your text to the top, middle, or bottom of a cell, which becomes more important if you have taller rows. You do not need to worry about vertical alignment right away.

You might think you have to repeat this process cell by cell, but there is a more efficient way to format multiple cells at once. If you want to align the headers in several columns, you can select them all before applying your formatting. To select a range of cells, move your mouse pointer over the first cell, click, hold, and then drag it across to the last cell you want to include. For example, if your headers are in cells B1 through E1, you would click and drag from B1 over to E1. Now, when you click Align Text Right, all those headers will be right-aligned together.

Understanding ranges is important for more than just alignment. You will use cell ranges for many Excel tasks, including writing formulas and applying formatting. A range can be horizontal (like B1:E1), vertical (like A2:A5), or even cover a block of cells (like C2:E5). The format for referring to a range is the address of the top-left cell, a colon, then the address of the bottom-right cell. For example, C3:D5 refers to all the cells in that block from C3 down to D5.

Now, let us look at bolding your column headers. Select the range you want, such as A1 through E1, by clicking and dragging across those cells. Then, look for the Bold button, which normally appears as a capital B in the font group on the Home tab, and click it. All the selected cells will now have bold text, making your headers stand out. If you decide you do not want them bold, just select the same range and click Bold again to turn it off. Many formatting buttons work as toggles this way; click once to apply and click again to remove.

Italics and underline work in exactly the same way as bold. For example, if you want to italicize a group of cells listing representative names, select the range (such as A2 through A5), then click the Italic button, typically shown as a slanted I. The text in the selected cells is now italic. You can combine bold and italics if you want your text to be both bolded and slanted for extra emphasis.

If you want to underline section headers or important data, select the relevant cells and click the Underline button, which is usually shown as a U with a line under it. As with other formatting, you can turn the underline off the same way.

These are the basics of formatting your spreadsheet to help your data look more polished and professional. Using cell alignment, ranges, bold, italics, and underline, you can quickly improve the appearance and readability of your spreadsheet, whether you are preparing it for your own reference or to share with others. Experimenting with these formatting tools will help you make spreadsheets that are both attractive and easy to work with.