How To Manage Text Alignment In Excel For Mac


show more Managing text alignment provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Managing text alignment

When you enter a value into your worksheet, Excel determines what type of value it is: a number, text, date, and so on, and assigns the cell a format based on that data's type. Part of that format includes the cell's alignment, which means that the data can start at the left edge of the cell, end at the right edge, or be centered within the cell. If you want, you can reposition your data within a cell by changing its alignment. To change a cell's alignment, you go to the Home tab of the Ribbon, and then you use the controls within the Alignment group.

There are a lot of them. I'm just going to focus on the few that you'll use the most often. The most commonly used controls are the left, center, and right alignment controls. You can see that we have left-aligned data. Those are the text values here: Quarter, Month and Revenue, and also right- aligned, which are the numbers here and the numbers here. In general, text is aligned to the left and numbers are aligned to the r...

Managing text alignment
Video duration: 3m 56s 6h 32m Beginner

Viewers:

Managing text alignment provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...