Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
The previous movies in this chapter showed you how you can format different sections of the spreadsheet independently of one another, by using the Font, Alignment, and Numbering commands, and groups, on your home ribbon. Now I'm going to take a look at some of the more powerful style options by using this style grouping, and specifically the format as a table option. For those of you that would like to follow along, please open the regional EatCake Sales Forecast spreadsheet in your Exercise Files. To use this particular functionality, we're going to start with the title row in our table, and we're only going to highlight the area that we're looking at on the screen here. And I've done that by placing my mouse in cell A3 and clicking and dragging down to sell E29, and releasing the mouse. So you'll notice that I have a highlighted area in front of me here.
The reason I'm doing this is just to easily show you what's happening here, but this can be placed on any size table that you'd like to work with. Once you've selected the area that you're interested in working with, you go up to your ribbon, and select the Format as Table command. Clicking on that particular command presents a wide variety of different color options that you can choose from. Let's choose the red as a starting point. I'm going to move to the middle area and select that. It then asked me to confirm that I am working with the total area of the table that I want to play with at the moment. And in this case, I do. So it's identifying for me here, that I picked cell A3 through to cell E29 that I want to work with.
And it's also identifying the fact that my table has headers, so it's going to automatically put an AutoFilter on those particular headers for me. If your table doesn't have headers, you just deselect that area. You click OK, and see how quickly the options that we took three or four different commands to work with in previous movies, are now all presented in one. If you'd like to play with different color options, you simply need to move across in this Table Styles option here, and you can use your live preview ability to see which color codes you'd like to work with.
Let's choose green, and now we have our green formatting setup. What might have taken 10 minutes to set up is now set up in as little as three clicks. If you thought that was pretty slick, let's take a look at some of the more advanced formatting options that are available in Microsoft Excel, in the next chapter.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 87461 Viewers
80 Video lessons · 136422 Viewers
59 Video lessons · 55082 Viewers
52 Video lessons · 68946 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.