In this video, I want to make my cells or ranges, or any other objects look better, what controls Do I have over their appearance when it comes to cells and ranges, simply making a selection of that information. And then moving to most of the commands found on the Home tab provide us with quick access to a lot of simple formatting, like font face size, other effects at bold borders and color, or alignment, or number formatting. Or we can immediately access some particular cell styles. But you can also access some of these more commonly used commands by right clicking. Immediately we have quick access to a subset of those commands. But master control of everything you could possibly want to perform in terms of formatting can be found after making your selection and using the shortcut Ctrl one that brings up the Format Cells dialog box Which gives us options over the number format, alignment font, border full, and even some protection settings, which we'll learn about later in Step nine.
Control one we will notice is the shortcut you can use to move into the formatting of any object within Excel. If we like to format pictures by selecting on the picture itself, that opens up a contextual ribbon tab to format that particular picture. And here we have a range of different options. Once again, right clicking gives us some quick access to certain styles. All once again Ctrl N one will actually open up the format pictures dialog box from the right hand side, giving us control over every possible element of that picture. Similarly, with shapes, we get the drawing tools, with all different types of formatting, somebody with right clicking or pressing CTRL one And you'll notice that in the format dialog box, which appears from the right hand side, you can access different options.
For example, we've got the shape options, which have options at full and the line color, or effects, as well as size and properties. By then clicking on the text options, we see a different subset of text options. Each one of these has a drop down, that we can access to gain complete control over all of these different settings. Even other objects, like charts sparklines our charts and sparklines simply clicking on them will open up contextual menus. And these often include formatting or design. But once again, control and one gives us ultimate control even things like that, classes which we'll learn about.
Later on. In Step five, we have various different options, which can control styles, or pressing Control one opens up this dialog from the right hand side. Any dialog box which opens up from the right hand side can actually be moved and resized. Or if you hover to certain parts of your screen, they can be snapped into place. Personally, I prefer to leave them on the right hand side and close them when I'm not using them. But as we can see, without going through all of the different types of formatting, which involves a lot of trial and error, we've learned that most of these common options are found on the ribbon, many of them being contextual when you click on a particular item, right click is a great option to get some quick settings.
But ultimate control can always be found by pressing the ctrl one shortcut. We'll see in the next video.