How to align text in Microsoft Excel, Calc, and Google Sheets

excel-alignment.jpg

Updated: 11/10/2017 by Computer Hope

Below are the steps on how to change the alignment of text in a word processor and most text editing programs. View the steps for the program you are using by clicking on one of the links below.

Align text in Microsoft Excel

You can change the horizontal alignment of text in a cell by selecting the cell you want to change and selecting the type of alignment you want under the Home tab as shown in the above picture. For example, if you wanted to center the text in a cell you would click the center icon.

To change the alignment of text in a cell using a keyboard shortcut follow the steps below.

  1. Select the cell you want to change.
  2. Press Alt+H
  3. Press A
  4. Press L for left align, C for center, or R for right align.

Adjusting the vertical alignment

If you want to change the vertical alignment of text in a cell, you would follow the same above steps but select Top Align, Middle Align, or Bottom Align depending on the vertical alignment you want to use.

Tip: You can also use the Orientation button to make the text vertical, at an angle, or any orientation you desire.

How to align text in Google Sheets

In Google Sheets to change the horizontal alignment of text in a cell, select the cell and click the Horizontal Align button on the toolbar (as shown above). Once done you’ll have the option to select Left, Center, and Right alignment.

or

Press one of the shortcut keys to adjust the alignment of any selected cell. For left alignment highlight the text and press Ctrl+Shift+L. For center alignment highlight the text and press Ctrl+Shift+E. For right alignment highlight the text and press Ctrl+Shift+R.

Adjust the vertical alignment

To change the vertical alignment of text in a cell click the Vertical Align icon in the toolbar (as shown above). Once selected choose Top, Middle or Bottom depending on how you want to align the text.

Tip: You can also use the Text Rotation option (shown above) to make the text vertical, a tilt, or at any angle you desire.

Aligning text in OpenOffice Calc

You can change the horizontal alignment of cell text in OpenOffice Writer by highlighting the cell you want to change and clicking on the left, center, or right align icons on the toolbar at the top of the window or the Properties window. These icons look similar to those shown in the above example picture of the Microsoft Excel.

How to change the vertical alignment

OpenOffice calc does not show a vertical align option in the top toolbar. However, there are vertical alignment options shown in the Properties window that should appear to the right of the spreadsheet when a cell is selected. From this window, you can select Align Top, Align Center Vertically, and Align Bottom.

PinIt
submit to reddit

Leave a Reply

Your email address will not be published. Required fields are marked *

Top
Web Design BangladeshWeb Design BangladeshMymensingh