Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Home Tab

clipboard - font - alignment - number - styles - cells - editing

Excel 2010 Home Ribbon

Alignment

EXCEL 2010 HOME ALIGNMENT GROUP

As you continue to create your spreadsheet, the Alignment options are useful for making your spreadsheet easier to read and making the overall appearance better.

Hover over each of the buttons within the Alignment group in the Home tab for a name and brief description.

We have added more details to our Monthly Budget spreadsheet and will start adding alignment features to help certain areas standout and/or look more presentable.

EXCEL 2010 HOME ALIGNMENT FEATURES

First, let's adjust the heading of the spreadsheet, Monthly Budget, to be centered horizontally and vertically in the report.

EXCEL 2010 ALIGNMENT MERGE AND CENTER

Select A1 and drag your mouse to M3 to highlight a group of cells. Select Merge & Center, and then select Middle Align (as shown in the image to the right). While the cells are still highlighted, change your font size to 24 from the Font group of the Home tab, and then select Bold.

Next, highlight B4 through M4 (January through December) and select Center from the Alignment group of the Home tab. While the cells are still highlighted, select Bold from the Font group of the Home tab.

Your spreadsheet should now look like the image below.

EXCEL 2010 ALIGNMENT CENTER
EXCEL 2010 ALIGNMENT ORIENTATION

We now know we can center our text vertically and horizontally. In addition, the Orientation button allows you to rotate your text to a diagonal or vertical angle.

When your text is longer than your cell, the Wrap Text function is useful. Select the cell and select Wrap Text and the height of your cell will increase and the text will wrap below, as shown in the image to the left.

EXCEL 2010 INCREASE AND DECREASE INDENT



For additional formatting, utilize the Increase and Decrease Indent buttons. Highlight cells A6 and A7 and select Increase Indent from the Alignment group of the Home tab. Do the same for cells A11 through A19. You can select the Increase and Decrease Indent buttons multiple times depending on how big or little you want your indentation.

Next Tutorial


This concludes the Alignment tutorial.
Click next to continue to the Excel 2010 Number tutorial.