When entering data into cells, the default alignment is left-aligned along the bottom for text and right-aligned along the bottom for numbers. Excel supplies many other alignment options from which to choose – left alignment, right alignment, center alignment, as well as horizontal and vertical alignment options.
The alignment options are available on the Alignment group on the Home Ribbon:
- Align Left – Aligns cell contents along the left edge of the cell
- Align Right – Aligns cell contents along the right edge of the cell
- Center – Centers the cell contents within the cell
- Top Align – Aligns text to the top of the cell
- Middle Align – Aligns text so that it is centered between the top and bottom of the cell
- Bottom Align – Aligns text to the bottom of the cell
- Orientation – Allows you to rotate text
- Decrease Indent – Decrease the margin between the border and the text in the cell
- Increase Indent – Increase the margin between the border and the text in the cell
- Wrap Text – Wraps the text within a cell so it does not cross adjoining cells or get cut off
Alignment Commands
Other alignment options are available from within the Format Cells dialog box.
To Change the Alignment of Data within Cells
- Select the cell or cell range whose data you wish to align.
- Click the desired alignment button on the Alignment group on the Home Ribbon
OR
- Select the cell or cell range whose data you wish to align.
- Display the Format Cells dialog box.
- Click the Alignment Tab.
- Choose options from the Horizontal and/or Vertical combo box.
- Select any desired additional options such as Wrap Text, Orientation or Text Direction.
- Click OK.
Similar Posts:
- Merge Cells and Center Text in Excel
- Align Objects in PowerPoint 2007
- Creating a Hanging Indent in Word
- Locking and Unlocking Cells in an Excel Worksheet
- Using Conditional Formatting based on Top/Bottom Values in Excel 2007
- Adding Cell Borders in Excel 2007
- Naming a Range in Excel
{ 2 comments… read them below or add one }
I need to wrap text within a RANGE, not just within a single cell. I have a very long piece of text in cell J3, and I would like to have the whole thing wrapped within the range J3-L13. The “Wrap Text” button works only for a single cell. How can I accomplish what I want?
Hi – have you tried Merging the cells before wrapping? This could turn the range into one longer cell. This should then work.