Excel for Mac 2011: Fit and Position Cell Content in Worksheets

You can align and position cell contents in Excel using the Alignment group on the Office 2011 for Mac Ribbon’s Home tab at the top of the Excel window:

  • Horizontal: Select from left, center, or right justification for a cell.

  • Vertical: Select top, center, or bottom.

  • Orientation: Tip and turn cell contents.

  • Wrap Text: Choose Wrap Text from this pop-up menu to allow text to wrap within a cell. Select some contiguous rows and then select Shrink to Fit from the pop-up menu. The text in rows with more text will be made smaller to match the length of the shortest text entry among the selected rows.

  • Merge: Select two or more cells and then click this button to merge the selection into a single cell. You retain only the content of the upper-left cell. Select an already merged cell and then click this button to unmerge the merged cell.

    image0.jpg

When you type text that extends past the right edge of the cell, your text displays. If you then enter text or a formula into the cell immediately to the right, the contents of the second cell will cover the text in the first cell. This is normal. Adjust the column width and row heights by using the double-arrow cursor. The Wrap Text button has a pop-up menu from which you can choose to either Wrap Text or Shrink Text to Fit, which you can use to solve overlap problems.

You can access additional cell alignment options by pressing Command-1 and clicking the Alignment tab. The Orientation area gives you a couple fun options:

  • Stacked letters: Click this button to stack letters.

  • Angled orientation: Drag the angle line or use the spinner control to tilt text to any angle.

blog comments powered by Disqus
Advertisement

Inside Dummies.com