• Excel Video Tutorials

Text Alignments in Excel 2010


Advertisements

If you don’t like the default alignment of the cell, you can make changes in the alignment of the cell. Below are the various ways of doing it.

Change Alignment from Home Tab

You can change the Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text to the left. Click on the available option in the Alignment group in Home tab to change alignment.

Change Alignment from Home Tab

Change Alignment from Format Cells

Right click on the cell and choose format cell. In format cells dialogue, choose Alignment Tab. Select the available options from the Vertical alignment and Horizontal alignment options.

Change alignment from Format cells

Exploring Alignment Options

1. Horizontal Alignment − You can set horizontal alignment to Left, Centre, Right, etc.

  • Left − Aligns the cell contents to the left side of the cell.

  • Center − Centers the cell contents in the cell.

  • Right − Aligns the cell contents to the right side of the cell.

  • Fill − Repeats the contents of the cell until the cell’s width is filled.

  • Justify − Justifies the text to the left and right of the cell. This option is applicable only if the cell is formatted as wrapped text and uses more than one line.

2. Vertical Alignment − You can set Vertical alignment to top, Middle, bottom, etc.

  • Top Aligns the cell contents to the top of the cell.

  • Center Centers the cell contents vertically in the cell.

  • Bottom Aligns the cell contents to the bottom of the cell.

  • Justify Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line.

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements