Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to apply horizontal alignment in Excel

How to apply horizontal alignment in Excel

Transcript 

In this lesson we'll look at how to apply basic horizontal alignment to cells—these are the options to left-align, right-align, and center-align content horizontally in cells.

Let's take a look.

There are two basic paths to horizontal alignment in Excel. The first is the Alignment group on the home tab of the ribbon, which gives you access to left, right, and center alignment. The second path is the Alignment tab on the Format Cells dialog box. The Format Cells dialog is more complete and gives you access to all the cell alignment options in Excel.

As we've seen previously, Excel will, by default, align text to the left and numbers and dates to the right. In the Format Cells dialog box, this default alignment is referred to as "General" alignment.

However, you can override Excel's default alignment as you like. For basic right, left, and center alignment, it's easiest to use the buttons on the ribbon. We can, for example, align column B to the right, and center-align the numbers in columns C through G. Or, we could right-align all of these columns.

To reset alignment to defaults, visit the Alignment tab in Format Cells and choose "General" from the Horizontal alignment menu.

Be aware that if you select multiple cells that are formatted with different alignment options—for example, cells that are both right and left-aligned; the Horizontal alignment menu in the Format Cells dialog will be blank.

This is Excel's way of telling you that the current selection has more than one alignment setting applied.

As usual, the ribbon will highlight the setting for the active cell, which can vary depending on how you made the selection.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Hey, no question, I just wanted to let you know that your site is amazing and has helped me out so much. Thank you for maintaining such a great resource! It warms my heart to know this is something you accomplish with your partner.
OP
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page