Even so, you can still change the appearance of your data and other worksheet values to make them easier to understand. In this video, learn how to change the appearance of your text, cell backgrounds, and cell borders.
- [Instructor] When you save data in Excel, you're usually more concerned with the numbers than how they look in the worksheet. Even so, you can still change the appearance of your data and other worksheet values to make them easier to understand. In this movie I will show you how to change the appearance of your text, cell backgrounds, and cell borders. My sample file is the Basic Formatting workbook and you can find it in the chapter six folder of the Exercise Files collection. This workbook contains a single worksheet with monthly revenue for the calendar years 2013 through 2018.
I don't have any formatting applied and I'd like to change a couple of things, the font, the size, the style, and color of some of the cells. I won't make every change to every cell. I'll start with the label which I want to set apart as a label and you can see that here, in cell A1 monthly revenue. If I want to change the font, I can change what's called the font face or usually just the font, also its size, style, and color.
Let's say that I want to change this value in A1 from 12 point to 18 point to make it larger. So I'll click the font size control, I'll click this down arrow and then select 18 from the list that appears. If I wanted to type in a specific value, I could click in the text box and type it there. If I wanted to go up one increment, whatever's available next, I can click the increase font size button or to go down click the decrease font size button.
I can also change the font style. The three most common are displayed here and those are bold, italic, and underline. I typically use bold for this type of heading so I will select cell A1, already was in my case, and press Command + B. That applies bold formatting. I could've also clicked the bold button here. If you've applied formatting and you want to remove it, you can just click the button you used to apply it.
And I'll return it. To change font color go to the font color control. You can either click the last color that was applied, in this case it's red, or you can click the font color controls down arrow and select from theme colors which are covered by office themes, from the standard colors which don't change if you change office themes, or click more colors to select from a rainbow array. In this case, I'll just go with a standard blue and there we have it.
If I want to change the font itself, I can with the cell selected go up to the home tab of the menu and click the font controls down arrow and I can work with various fonts collections. Fixed width, fun, modern and so on. Or I can select individual fonts. In this case I'll go with Cambria which is used for headings and there's the change. To apply formatting to more than one cell you can select them all at one time. So let's say that I want to make the calendar year cells italic.
For that I will click cell C3 and then drag to select all the way to H3. Then I'll hold down the command key and select cells B4 through B15. I wanted to apply italics so I'll press command + I to do so and for month and year I will click cell B3 then command click C2 and click the bold button or I could have also pressed command B as I did before.
Finally I can apply borders. For that I select the cells around which I want to apply a border and then click the border controls down arrow and here you see I have bottom border, top border and so on. In this case I want to do outside borders only. So if I click away you see that I've applied outside borders. And I can also apply thick outside borders by selecting the cells I want, in this case the original cells plus the ones that contain the headers and the blank in B2.
Click the borders control down arrow and click thick box border and click away. And there you see the borders have been applied. There are other formats that I can apply and I will show you how to do those in other movies.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks