From the course: Excel 2016: Advanced Formatting Techniques
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Format text from Word or the web with the Justify feature
From the course: Excel 2016: Advanced Formatting Techniques
Format text from Word or the web with the Justify feature
- Excel has an unusual editing feature referred to as justify. Let's imagine that I've copied some numbers here and also some text. Maybe from Microsoft Word or maybe off the internet here and I've pasted the text in Excel B2. In the formula bar we can see some of this, maybe a little bit more than what we're seeing on the screen. One tip we could use here to read the text is we can slide the mouse into the formula bar and as we see the double arrows on the bottom border click and drag downward. You can also press Control + Shift + U as well too. Or drag this even further. Ultimately we will have a limit here if we re-wrap this text, but how would we get this text, for example, into these cells here by somehow wrapping it? Well one technique and a little bit tedious is to copy this into this cell, this cell, this cell and then do various kinds of editing to reshape the text that we're seeing. We don't necessarily have to keep the formula bar looking like that. I'll take it back to its…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
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
-
-
-
-
-