Join Dennis Taylor for an in-depth discussion in this video Applying different formatting styles within the same cell, part of Excel 2013: Advanced Formatting Techniques.
- If you'd like to apply different kinds…of formats to the same group of cells…at the same time, you can take advantage…of using the Format Cells dialogue box…rather than performing the tasks individually.…For example, if we'd like to change the formatting…of the cells B4 through I4.…If we want to apply different font features,…we could certainly make those bold.…If we wanna get into a different kind of underlining,…we'll have to either click the dialogue box…launcher here or control 1…or right-click Format Cells…and perhaps use a different style here.…
How about Single Accounting underlining?…And after doing that, we see those two features in effect.…Maybe we wanna change the color of the font as well, too.…And they're still highlighted,…so I'll make 'em, you know, blue, something like that.…So we're doing these features individually.…And if we wanna copy that, too,…we can certainly consider doing that,…but let's also consider the idea that we could…have done that a little faster because…sometimes if you activate Format Cells,…
Author
Released
12/10/2013- Adjusting fonts, cell borders, and fills
- Aligning text
- Indenting data
- Setting special formats for dates, times, phone numbers, zip codes, and more
- Creating formats based on formulas with conditional formatting
- Applying styles and themes
- Adjusting row heights and column widths
- Adding background images and pictures
- Outlining data
- Printing double-spaced data
Skill Level Advanced
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Appropriate for all -
Excel 2013: Shortcuts
with Curt Frye3h 16m Intermediate -
Excel 2013: Pivot Tables
with Curt Frye4h 20m Intermediate
-
Introduction
-
Welcome47s
-
-
1. Controlling Fonts, Borders, and Cell Color
-
2. Alignment Tools
-
3. Adjusting Numeric Formats Quickly
-
Building custom date formats5m 44s
-
4. Accentuating Dynamic Data with Conditional Formatting
-
5. Tables, Styles, and Themes
-
Working with tables8m 34s
-
-
6. Row, Column, and Sheet Adjustments
-
7. Other Worksheet Formatting Tools
-
8. Displaying Data as an Outline
-
9. Adding Pictures
-
Formatting picture styles3m 12s
-
-
10. Specialized Power Formatting Techniques
-
Conclusion
-
Goodbye29s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Applying different formatting styles within the same cell