Topic Cell formatting. Description Working with the Format Cells dialog to apply text rotation and borders, as well as centering data across multiple cells. Where/when to use the technique Having a report is one thing, but if it looks ugly, no one is going to want to engage with it. The format cells dialog contains the abilities to apply more advanced formatting than the Ribbon’s shortcuts allow, in an effort to make your reports truly grab your audience. • 00:04 In this video, we're gonna look at how to format cells. • 00:07 And this is one the tasks that most people love to do with Excel, • 00:11 is make their data look pretty. True if the font is an outline font. Read/write Boolean. This property has no effect in Windows, but its value is retained (it can be set and returned). Select the cell you want to apply multiple font colors or fonts, then get into the cell with pressing the F2 key (or just double click the cell). Select the text you need to use different font colors or fonts, click Home > Font Color or Font in the Font group, then specify the certain font color or font you need. Docker for mac sql server. • 00:13 So, we'll take a look at some different options that we have here. • 00:16 The first one that I'd to look at is how to actually center properly • 00:21 across a selected range. • 00:22 So if we look at cells B3 through B5 here, • 00:27 these are obviously titles that belong centered across the top of this table. • 00:32 Now, one of the big things that a lot of people will do is they'll • 00:34 merge cells and center. • 00:36 And merged cells are not a good thing.
• 01:07 The one part of this can make mess you up, though, is that when you select • 01:10 the cell that looks like it has data, look what's in the formula bar. • 01:14 There's nothing there. • 01:15 That's actually showing up In the original cell. • 01:18 This is the one that holds the data, it's just been centered across. • 01:21 The key way that you can identify this look where the column breaks are. • 01:25 There aren't any in here. • 01:27 So we know that this has been centered across there. • 01:29 We can also do more than one cell at a time the same way. • 01:33 We can right click, Format Cells. • 01:36 Go into the general, and Center Across Selection. • 01:39 And that will allow us to center across those guys as well. • 01:44 Now, obviously we can do things like change colors. • 01:48 So we could center or select these guys here, and • 01:51 we could go give these a nice, oh, I don't know. • 01:52 How about a purple color? • 01:54 There we go. There's a nice cell color there. • 01:56 We could format in bold. • 01:58 That's no problem. ![]() • 01:59 What if we wanted to tip this data 45 degrees on its side? • 02:02 Maybe that's something that we'd like to see in our report. • 02:04 We can Right-Click, go to Format Cells, and • 02:09 on that same Alignment tab, that's where this little dealie is over here is. • 02:13 You can Left-Click and drag the text rotation. • 02:17 And set it to 45 degrees. • 02:18 And you can actually dial it up or • 02:20 dial it down if you want to get really specific with it. • 02:22 What'll end up happening here • 02:25 is the the data will end up tipped on it's side over the columns. • 02:28 Now, let's go and set our column Column widths here a little bit as well. • 02:34 So we'll just drag in between here. • 02:36 And this is one of the things that can get a little bit funny when you start doing • 02:40 these kind of things, and you start bringing your columns nice and • 02:43 close together, is you'll notice that these columns, • 02:47 even though it only used to be about this wide, they sort of overlap.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |