From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create custom formats: Dot leaders and more
From the course: Excel 2016: Tips and Tricks
Create custom formats: Dot leaders and more
- [Voiceover] Excel has a variety of formats and anytime you want to go behind the scenes and get to some of the formats you might not be seeing on the home tab press Control 1. It activates the Format Cells dialog box and lots of choices here on the Number tab most of them numerical, not all of them, and there's a feature here called Custom, where you can create your own. When you see this list sometimes it's a bit overwhelming. What do all those symbols mean? I don't want to go into a great deal of detail about these, but there are some features in here that you might want to know about. So let me close this and set up a scenario. Nothing wrong with the Job Rating entries that we see over here in column J. It just might look more interesting if the numbers are maybe preceded by dots or dashes. We could do it with Compensation Amounts too or other numbers if we wished. Here's one simple example of making up a custom format for column J. Now you don't always have to select the entire…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Use keystroke shortcuts for frequently needed numeric formats6m 29s
-
(Locked)
Accentuate data with alignment tools6m 2s
-
(Locked)
Add a color background to every 5th row in a range5m 40s
-
(Locked)
Use conditional formatting based on comparison criteria5m 13s
-
(Locked)
Use conditional formatting to highlight formula cells only2m 54s
-
(Locked)
Create custom formats: Dot leaders and more6m 1s
-
(Locked)
Use special formats for times over 24 hours4m 9s
-
(Locked)
Add/remove strikethrough and borders with keystroke shortcuts3m 34s
-
(Locked)
Quickly format phone and SS numbers3m 54s
-
(Locked)
-
-
-
-