From the course: Excel 2016: Advanced Formatting Techniques
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Apply different formatting styles within the same cell
From the course: Excel 2016: Advanced Formatting Techniques
Apply different formatting styles within the same cell
- We're looking at a worksheet called Same Cell. Let's imagine that I'm about to apply some formatting features to these cells right here. Now there's certainly nothing wrong with doing these individually. For example, I might want to make these cells Bold. I might want to provide a background color here, maybe a light blue. I might want to change the text to be a dark blue. And I might also want to change the number format here. Maybe I don't want to see the decimals, or maybe instead of Accounting Number Format, maybe I want to use Comma Format. In other words, there's certainly nothing wrong with doing these one by one. Possibly I might want to be copying these features elsewhere. So let's reconsider an approach here. I'm going to press Control-Z a few times. Let's go back to a previous display before I changed anything, and this time let's highlight these cells again and begin with Format Cells, Control-1 activates this dialog box. Also right-clicking, going to Format Cells does…
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
-
-
-
-
-
-
-
-
-
Use the Format Cells dialog box and the pop-up mini-toolbar3m 53s
-
Apply different formatting styles within the same cell2m 52s
-
Copy formats quickly using dragging techniques and the Format Painter6m 27s
-
Format text from Word or the web with the Justify feature5m 4s
-
Add a background image to a worksheet4m 32s
-
-
-
-
-