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

Apply different formatting styles within the same cell

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

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…

Contents