• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Align Text in Excel

July 23, 2021 by Andrew Childress
Text alignment in Excel

Aligning text is the perfect way to control how values are displayed on your spreadsheets. Let’s learn how to align text in Microsoft Excel.

Aligning text is the perfect way to control how values are displayed on your spreadsheets. Excel offers an array of alignment options that are quite easy to work with. These help you control where content is placed within cells. Let’s learn how to align text in Microsoft Excel.

How to Align Text in Excel

Fundamentally, Excel offers six alignment tools to control content placement in cells. These operate on both the horizontal and vertical axes. For most cells, only horizontal alignment is necessary. Vertical alignments become necessary when you’ve merged cells within a column or wrapped the text.

To align text in Excel, begin by selecting a cell containing any values. This can be numbers, text, and more. Cell alignment works with any and every type of content that you can add to Excel spreadsheets.

Then, go to the Home tab and click on it. The Home tab is on Excel’s ribbon, the list of menus found at the top of your screen.

The Alignment group sits immediately to the right of the Font section. In the center, you’ll see three options: Align Left, Center Text, and Align Right. Click on any of these options, and your text will format accordingly.

Align text in Excel

Above these options, you’ll see the vertical alignment controls. These are Top Align, Middle Align, and Bottom Align. Again, these will produce visible changes only if you have cells taller than the default 16 pixels.  If you do, simply click on any of them, and you’ll see your values shift along the vertical axis.

Text alignment in Excel

Of course, you can also combine alignments: for example, you can use Middle Align and Align Right to place values in the center right of a given cell.

How to align text in Excel

As you can see, it’s easy to align text in Microsoft Excel to better control the look and feel of your spreadsheets.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Custom formats in ExcelHow to Custom Format in Excel
Next Post:How to Indent in Microsoft ExcelIndent text in Microsoft Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top