How to Indent in Google Sheets

How to Indent in Google Sheets

Indenting makes data easier to read and understand, thus improving productivity. Unlike Microsoft Excel, there is no native way to indent your data in Google Sheets. However, there is a workaround that allows you to quickly indent.

Indenting Google Sheets Cells

Follow the below steps to indent in Google Sheets cells:

  1. Select the cell or cells you want to indent.

    Select range
    Select the range of cells to indent.

  2. From the Format menu, choose the Number option. Then, from the sub-menu, select Custom number format.

    Custom Number Format
    Click on the Custom number format option.

  3. In the ‘Custom number formats’ dialog box, enter a blank space for each desired indentation, followed by an @ symbol, then click Apply. In this example, I specify that I need an indent of 4 space characters through “ @” (ignoring the quotes).

    Type whitespace for each desired indentation, followed by an @ symbol. Then, click on the Apply button.

  4. This is the output:

    Indented Cells in Google Sheets.

Phoebe is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.

Leave a Comment