Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Another dramatic improvement comes with the addition of color. We've got a little bit of color in our titles. We can also shade cells in order to create that same visual flow and division. For example, let's select the cells across our titles and let's hold down the Control key and select the cells along the side, and then we'll go to the Format Cells dialog box, and under Patterns select the very, very pale yellow down here. You'll notice that the subheading for the tab Patterns is Cell shading. Say OK and again let's go and look at that in our print preview Go File > Print Preview and let's zoom in on our worksheet, here we go. You can see how just the addition of that color has really divided the title from the body and everything else in between. Let's go ahead and close this view. You can also add color by selecting a cell or range of cells and up here in your Formatting toolbar, this paint bucket is your Fill tool for shading cells. So we could go and add a light gray color. And there again, if you want to take a quick print preview to see what that's going to look like on paper. It's not perfect folks, but you get the idea. Okay, let's close this view and before we move on from all of these aesthetic improvements, I want to show you a neat little trick called the Format Painter. If you select a range that has a formatting you're happy with, for example this entire worksheet, and click on the Format Painter, that's this paintbrush and if you don't see it here, just take a look at the extra options in your toolbar, it's probably hiding in here somewhere. I'm going to select the Format Painter and you notice we get the marching ants marquee indicating that we've made a copy of some sort. Well that's exactly what's happening. If you go to Sheet 2, and you can see we have an almost identical version of that spreadsheet waiting for us. Now you don't have to have an identical version of this spreadsheet, but in this case it's convenient. Let's click and drag across the entire spreadsheet and let go, and you'll notice that it has automatically formatted our new spreadsheet to be exactly the way the old one was. So Format Painter is a great way to get a layout that you're happy with, and then copy and paste just the formatting to other spreadsheets within your workbook.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90678 Viewers
80 Video lessons · 137966 Viewers
59 Video lessons · 56739 Viewers
52 Video lessons · 70363 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.