Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Formatting a spreadsheet is very similar to formatting a word processing document. First, select the text or cell you want to format and then apply your changes. I'm working with the very simple spreadsheet I previously created. Let's take a look at some formatting things we can do. First of all, we've already seen that you can use the Numbers section of the Formatting palette to specify the appearance of numbers, like currency, or percentages, or date, or time. The Formatting palette also contains many of the same options you'll find in a word processor for formatting text. For example, I could select the cells containing the Job A and Job B. And here in my Formatting palette, I can make them bold.
And if I go under Alignment and Spacing, I can center them. And in the Borders and Shading section, I can change the color and outline of selected cells. For instance, I could select the Annual Income cells and then make them, say, a light green, and maybe with a slight border around them, like so. Now, Excel even has some built-in formatting options, under Format > AutoFormat. First, I'm going to select all the cells currently in use, and I'll select AutoFormat.
And in here, I can browse through several designs, clicking on them to get previews, and I can apply any one that I like. I kind of like that one. I'll click OK, and there it is. Now, I'm not going to get into the details of formatting with Excel exclusively, because I want to keep this general enough to apply to all spreadsheet applications, but this should give you an idea of how formatting works. Again, it's very similar to formatting a word processing document. First select what you want to change and then change it.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98320 Viewers
80 Video lessons · 141445 Viewers
59 Video lessons · 59800 Viewers
52 Video lessons · 72999 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.