Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to indent in Google Sheets

Sheets has no indent button, but a custom number format adds spaces before the text in any cell.

Operations
8 steps 3 min Community template
1

Select the cells to indent

Highlight the cells to push in.

docs.google.com/spreadsheets/
Select the cells to indent
2

Click Format

Open the Format menu.

docs.google.com/spreadsheets/
Click Format
3

Click Number

Hover over Number to open its submenu.

docs.google.com/spreadsheets/
Click Number
4

Click Custom number format

Choose Custom number format at the bottom of the list.

docs.google.com/spreadsheets/
Click Custom number format
5

Click the format box

Click the box at the top of the window.

docs.google.com/spreadsheets/
Click the format box
6

Type " "@

Type " "@ - quote marks around four spaces, then @ for the cell text.

7

Click Apply

Click Apply to format the selected cells.

docs.google.com/spreadsheets/
Click Apply
8

Text indented

The selected labels now start a few spaces in. Change the number of spaces for a deeper indent.

docs.google.com/spreadsheets/
Text indented

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.