Microsoft Excel 2007 Custom Text Alignment

The alignment section of the Home Tab of the Excel ribbon contains a number of options

relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three relating to the horizontal position your data: left, centre and right. However you'll notice that when you click in the cells of an unformatted worksheet, none of these three icons is highlighted, which indicates that none of them is the default. The reason for this is that Excel treats data differently depending on the data type.

If you type text in a cell, your text is aligned on the left; if you type a number, the number is aligned on the right; if you type a date, it is also aligned on the right. To change the horizontal alignment, either select a range of cells or click on a column letter to highlight the entire column then click on one of the alignment icons.

Haven chosen one type of horizontal alignment, you can change it in two ways. You can either choose a different alignment or you can click again on the already selected alignment to deactivate it. For example, if your text is right-aligned and you click on the Right-align button a second time, this will deactivate right alignment and return you to the default alignment which, for text, is left-aligned. So, in fact, Excel has four types of horizontal alignment: left, centre, right and unspecified (or default), which is the alignment that applies when none of the alignment buttons is highlighted.

Microsoft Excel also allows you to specify the vertical alignment of your text. This setting becomes apparent when you increase the height of the cell and there is a definite default; text is normally aligned at the bottom of the cell. This default vertical alignment applies to text, dates and numbers alike.

To set the vertical alignment, either make a selection or click on the row number to select the entire row then click on one of the buttons to make the change: align middle, align top and so forth.

Excel also features the ability to change the orientation of text within the cell. This is particularly useful in those situations where your column headings are wider than the data in the cells. To change the vertical orientation of your text, just select the cells in question and then choose the appropriate angle in the Alignment dialogue.

Having changed the orientation of the headings, you can probably make the columns much narrower. Excel offers a very useful way of doing this: simply select all the columns that contain data then in the Cell group of the Home Tab of the Excel Ribbon, choose Format and then AutoFit Columns. This option makes each of the highlighted columns no wider than it needs to be to display all the data it contains.

by: Benjamin Johnson

POST COMMENT

Delegating Tasks Effectively In Microsoft Project What's the Buzz about Microsoft Dynamics CRM 2011? Free Microsoft Points 2010 Microsoft's Natural Keyboard Microsoft 70-680 Eaxm Microsoft 70 270 Installing, Configuring And Administering Your Heard of it But What is Microsoft Dynamic's? Microsoft Dynamics Gp In Retail Implementation Highlights Microsoft Dynamics Gp 2010 Improvements And Innovations: Optimism And Some Pessimism Microsoft Dynamics Gp Distribution Industry Implementation: Barcoding, Wms, Scm, Edi Resolving "cannot Turn Off The Reminder" Microsoft Office Outlook 2007 When To Consider Upgrade To Microsoft Dynamics Gp Versions 2010/11.0 Microsoft Exchange And Android