Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Let's take a look at cell styles in particular. For those of you that would like to follow along, in the advanced Formatting folder, you'll see EatCake Sales Forcast7, please open it right now. Once you have it open, you'll notice that there's three different types of cell formatting that have been applied to the first area of this spreadsheet. I've done a little bit of formatting to the title, to the column headers, as well as to the first column in the first five rows. Let's select the first row, the EatCake Sales Forecast and see what kind of style formatting has been put on there. Once you select that cell, go over to the styles command and click on it. And you'll notice that the style that has been selected is highlighted with a orange box around it.
Let's see what kind of formatting is going on behind there. To see what one makes up the style underneath heading 1, simply right-click on it, and a subset of menus will show. Select the Modify command from there. And you'll see the different styling options that have been applied. What this pop up screen shows you is the font choice that was selected. So it's been bolded, and the fact that we've chosen a bottom border for this particular area. If you want to see a few other styles that have been chosen, you can click on the Format button and you'll the font color, as well as the title of the font style that we're working with available to you.
If you're interested, you can also investigate what number formatting you've got, what alignment you're working with, as well as if there's any other highlighting done to fill in the cell itself. So, by simply going to the Cell Styles command, and right-clicking on the area that you would like to investigate and clicking modify, you can really see what kind of styling options have been set for that particular style that you're interested in choosing.
Similarily, if we go down to the next row, and do the same thing, we'll see that the 20%-Accent1 style was chosen, and the same options are available for me to see here. Let's take a look at that styles menu one more time. You'll see that you have different styles to choose from. You have the Good, Bad, Neutral highlighting options, which allow you to visually identify areas of this worksheet that you'd like to bring focus to. You have your Data and Model options, which help you again, present the information in a nice, visibly easy to see formatting, as well as areas that will help you work with your titles and theme styles. If you'd like to create your own personal style, you can do that by going down to the bottom of the page where you see new cell styles selecting matte, naming your style, so let's call this EatCake1. Identifying any color formatting that you'd like to put in place.
Well since we used Arial, I'm going to new select that as my default, make it 12, as well as I'm going to change the color of it. I'm going to the color area and selecting a darker green. Save that by clicking OK. And when I go back to my cell options, my new Custom cell option is right at the very top, and if I select that, it'll be applied to the areas in the spreadsheet that I've already pre-selected.
Now let's explore the options to auto format, as you're actually typing into the screens.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74389 Viewers
80 Video lessons · 129663 Viewers
52 Video lessons · 63907 Viewers
59 Video lessons · 49695 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.
Your file was successfully uploaded.