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.
Adjust horizontal and vertical cell alignment
From the course: Excel 2016: Advanced Formatting Techniques
Adjust horizontal and vertical cell alignment
- We're looking at a worksheet called Cell Alignment, and the way information is aligned in cells is important, because at times you do want to make changes. The native alignment of text entries in Excel is left alignment. These entries here were typed, no changes were made to them, you can see what's happening here. In some cases, we will see wrapped text. We cover that in another movie in this course. So, at different times, you will see alignments, and you'll want to make changes. I think the first thought many of us see as we look at this worksheet is, "Let's get these titles straightened out here." They're not above the data. Now, they could be centered, they could be right-aligned, two easy buttons to get to. Here it is, center your content, also right-align. Either one could make sense in this case. There's a temptation sometimes to center, along with centering numbers. I would strongly advise against centering numbers. Now, part of the idea could be these numbers could be…
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.