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.
Control titles and headings using Wrap Text and Shrink to Fit
From the course: Excel 2016: Advanced Formatting Techniques
Control titles and headings using Wrap Text and Shrink to Fit
- We're looking at the worksheet called Wrap Text. And imagine that in this list here, we will be adding some columns to the right. One of our concerns is that we will be using this worksheet frequently, and we don't like the idea that we're wasting a lot of screen space by these wide columns when they really shouldn't be that wide. Column E, column F, also column A. Now, a couple of thoughts here. We could use a smaller font, and a couple ways to get there. One approach says why don't we click, first of all, cell A1 and explore this feature. We can do this in a couple of ways. We need to go to the Format Cells Dialog Box. It's an Alignment feature, we can get there by way of Control-1 or on the Alignment Group within the Home tab here, a little button off to the right, we can click this. One of our choices is Shrink To Fit. Now for the moment, nothing has happened, but I'm going to make column A a bit narrower here. And nothing wrong with that, but I think at some point you see…
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.