Excel Tutorials
Every horizontal, vertical, indent and rotation option Excel offers, including the ones hidden behind the Format Cells dialog that the ribbon buttons don't show. This lesson uses the Basic Budget workbook from Excel Foundations, free to download below.
Follow along in the same file used in the video. No email required.
Alignment controls exactly where content sits inside a cell, left to right, top to bottom, how many levels it's indented, and even what angle it's rotated at. The ribbon shows the handful of options people use daily, Left, Center, Right, Top, Middle, Bottom, but Excel actually offers several more alignment types entirely, only accessible through the Format Cells dialog.
Alignment also quietly does something useful by default: text lines up to the left and numbers line up to the right automatically, which is Excel's built-in visual signal for what kind of data is actually in a cell, before you've formatted anything at all.
Step-by-step, matching the video above.
Click a single cell, or select a whole row, column or range to align several cells at once.
On the Home tab, click Align Left, Center, or Align Right in the Alignment group.
In the same group, click Top Align, Middle Align, or Bottom Align, this is independent of horizontal alignment.
Click Increase Indent or Decrease Indent to push content in from the left edge, useful for nesting sub-items under a header.
Press Ctrl+1 and go to the Alignment tab to reach Justify, Distributed, exact rotation degrees, and precise indent levels, none of which have a ribbon button.
Click OK, then check the cell against neighboring cells, alignment differences are often easiest to spot once several rows are formatted the same way.
| Entry | Default Alignment | What It Tells You |
|---|---|---|
| Rent | Left | |
| 450 | Right | |
| 450 (typed with a leading space) | Left |
The third row looks like a number but left-aligns anyway, that's Excel's default alignment quietly telling you it's actually being stored as text, not a real number, which would otherwise break a SUM formula referencing it. This is one of the fastest ways to catch a data-entry mistake before it causes a calculation error.
The ribbon only shows three. Format Cells (Ctrl+1) has several more worth knowing.
The default, text goes left, numbers go right, automatically based on what's actually in the cell.
Repeats the cell's content across its full width until it's visually filled, sometimes used to create a repeating border-like pattern with a character like a dash.
Wraps text onto multiple lines and stretches each line so it touches both the left and right edges evenly, like a newspaper column. Only affects wrapped text, a single short word won't stretch.
Similar to Justify but also spaces out a single line of short text evenly across the cell's width, where Justify would leave it unchanged.
Visually centers text over several cells without merging them, keeping every cell independent underneath, covered in more depth on the Merge and Center page.
The same extra options exist vertically, just less commonly needed.
The three ribbon options, positioning content against the top edge, dead center, or bottom edge of a taller-than-normal row.
Stretches wrapped text so it fills the full height of the cell evenly, matching the logic of horizontal Justify but top to bottom instead of left to right.
Spaces content evenly across the full height of the cell, most noticeable on a row that's been manually made much taller than its content needs.
A common budget-list pattern: a category header with sub-items indented underneath it.
| Cell Content | Indent Level |
|---|---|
| Housing | 0 |
| Rent | 1 |
| Utilities | 1 |
| Renters Insurance | 1 |
Click Increase Indent once on Rent, Utilities and Renters Insurance to visually nest them under Housing, without touching Housing's own indent level or typing a single extra space into any cell.
Typed spaces become part of the cell's actual value, they'll throw off text-matching formulas, break VLOOKUP exact matches, and don't adjust if column width changes. Indent is purely visual and never touches the underlying data.
Format Cells > Alignment > Indent lets you type an exact number instead of clicking Increase Indent repeatedly.
Useful for narrow columns where a horizontal header would otherwise force the column too wide.
Home > Orientation offers preset options like Angle Counterclockwise, Angle Clockwise, Vertical Text, and Rotate Up or Down 90 degrees.
Format Cells > Alignment has a Degrees dial and input box for any angle from -90 to 90, for a precise rotation the ribbon presets don't offer.
Rotated text can also have Wrap Text applied at the same time, though it's worth checking the result carefully, the combination doesn't always look clean at extreme angles.
This changes the cell's actual value, which can break exact-match lookups and formulas referencing that cell as text. Use Increase Indent instead, it's purely visual.
They look identical on screen, but Merge & Center actually combines cells, which can break filtering and sorting later. Center Across Selection achieves the same visual look while keeping every cell independent.
Forcing every cell to Center removes the free visual signal that General alignment gives you for free, text vs. numbers, correct vs. accidentally-text-formatted values, at a glance.
A steep rotation can save column width but make a header genuinely hard to read quickly. Test a rotated header at actual print or screen size before committing to it across a whole report.
A report shouldn't need manual alignment to look organized.
Free 14-day trial. No credit card required.
Select the cells, go to the Home tab, and use the alignment buttons in the Alignment group, or press Ctrl+1 to open Format Cells for every option including Justify and Distributed.
Select the cell, go to the Home tab, and click Middle Align in the Alignment group. This centers content between the top and bottom of the cell, separate from horizontal centering.
Text left-aligns and numbers right-align by default under General alignment, which is why a column of properly entered numbers already lines up along the right edge without you doing anything.
Select the cell and click Increase Indent on the Home tab, or use Format Cells > Alignment > Indent to set an exact number of indent levels.
Justify wraps text onto multiple lines and stretches it so both the left and right edges line up evenly within the cell, similar to a newspaper column.
Distributed spreads text evenly across the full width of a cell, adding space between characters or words as needed, available for both horizontal and vertical alignment in Format Cells.
Select the cell, go to Home > Orientation, and choose a preset angle, or use Format Cells > Alignment > Degrees for a custom rotation up to 90 degrees in either direction.
Center Across Selection visually centers text over several cells without merging them, keeping each cell independent. Merge & Center actually combines the cells into one, which can break filtering and sorting.
Yes, select the full range, column, or row first, then apply any alignment option, it applies to every selected cell at the same time.
Every business starts with a spreadsheet. Updoot is where you scale past it, layout and formatting handled automatically.
Start Your Free Trial →