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
ClipboardFont – Alignment – Number – Styles – Cells – Editing

Alignment

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.

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

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.

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.




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.