Cell alignment and wrapping in Google Sheets - Step-by-Step Guide

Introduction

Cell alignment and wrapping help you organize text inside cells so it looks neat and easy to read. Alignment moves text to the left, center, or right, while wrapping makes long text show on multiple lines inside the same cell.

When you want to center a title across a few cells to make it stand out.

When you have a long sentence in a cell and want it to show fully without spilling into other cells.

When you want numbers to line up on the right side for easy comparison.

When you want to make a table look tidy by aligning all text to the left.

When you want to avoid cutting off text that is too long for the cell width.

Steps

Step 1: Select the cell or cells

- Spreadsheet grid

The selected cells are highlighted

💡 Click and drag to select multiple cells

Step 2: Click the Horizontal align button

- Toolbar at the top (icon with horizontal lines)

A menu with alignment options appears

Step 3: Choose Left, Center, or Right

- Horizontal align menu

Text in the selected cells moves to the chosen alignment

Step 4: Click the Vertical align button

- Toolbar at the top (icon with vertical lines)

A menu with vertical alignment options appears

Step 5: Choose Top, Middle, or Bottom

- Vertical align menu

Text in the selected cells moves to the chosen vertical position

Step 6: Click the Text wrapping button

- Toolbar at the top (icon with a curved arrow and lines)

A menu with wrapping options appears

Step 7: Select Wrap

- Text wrapping menu

Long text in the selected cells breaks into multiple lines inside the cell

Before vs After

Before

Cell A1 contains the text 'This is a very long sentence that does not fit in the cell and spills over to the next cell.' and is aligned left with no wrapping, so the text overlaps into cell B1.

After

Cell A1 text is aligned center and wrapped, so the full sentence fits inside the cell on multiple lines without overlapping other cells.

Settings Reference

Horizontal alignment

📍 Toolbar > Horizontal align button

Controls text position from left to right inside cells

Default: Left

Vertical alignment

📍 Toolbar > Vertical align button

Controls text position from top to bottom inside cells

Default: Middle

Text wrapping

📍 Toolbar > Text wrapping button

Controls how text behaves when it is longer than the cell width

Default: Overflow

Common Mistakes

Not selecting the cells before changing alignment or wrapping

The changes will not apply if no cells are selected

Always select the cells you want to format before clicking alignment or wrapping buttons

Using Overflow wrapping when text is too long

Text spills into adjacent cells and looks messy

Use Wrap to keep all text visible inside the cell on multiple lines

Summary

Cell alignment moves text left, center, or right and top, middle, or bottom inside cells.

Text wrapping breaks long text into multiple lines inside the same cell to keep it visible.

Always select cells first and choose the right alignment and wrapping to make your data clear and neat.