How to Indent in Google Sheets with 7 Easy Ways

Sometimes, it’s important to increase indent furthering the first text away from the cells’ border. Here’s how to indent in Google Sheets quickly.

how to indent in google sheets on pc web, android, iphone

In word processing worlds, you can indent normally by pressing the Tab key on your keyboard or by directly using its indentation feature, which is also available in Excel.

Indentation is useful to further the first text away from the closest cell’s border. It’s usually used by someone to further a list of something away from the cell’s border to distinguish it from the title of the list.

Indentation normally uses the bullet point feature which Google Sheets doesn’t have. However, you can use the alternative methods of indenting to create bullet points by using some modifications, such as empty spaces.

Here’s how to indent in Google Sheets.

How to indent in Google Sheets

By adding empty spaces before the text

This is probably the most obvious method to indent in Google Sheets. This currently works on Google Sheets at this time of writing, and you can do it just like writing regular text in a cell.

RELATED: How to Add Spaces in Instagram Post, Caption, or Bio

  1. To do it, simply click the cell where you want to add indentation.
  2. Then, press the space bar for some time depending on how many empty spaces you want to add to the indent.
  3. Write the first text and press Enter.

That’s it. Indentation is easy in Google Sheets. While this is possible, you can do alternative methods if you want something more advanced or a little complicated indents.

By creating a custom number format in Google Sheets

In Google Sheets, there are options to choose from for number formatting, and you can also create custom number formats if you want. This method can be used to indent by adding empty spaces as the format.

  1. To do this, select which cells you want to indent. You can multi-select cells by pressing CTRL and clicking on each cell at the same time.
  2. Then simply click Format.
  3. Choose Number.
  4. Select More format.
  5. Click Custom number format.how to indent in google sheets
  6. Here, type the first empty spaces (you can add spaces as many as you want) before the @. Click Apply once it’s done.add space in google sheets cells
  7. Now, those cells will be immediately indented with the empty spaces you’ve added.google sheets column with indent

Autofill indented cells in Google Sheets to indent faster

If you already have indented cells in your spreadsheet and want to create indented cells with the same empty spaces, you can spread them by using the autofill feature to the bottom or the right.

You can autofill it just like you autofill anything in Google Sheets the normal way.

  1. Simply put the mouse cursor at the bottom-right corner until it changes to the plus icon (+).
  2. Click it, and drag it to the bottom/right or anywhere you want.autofill indent in google sheets
  3. The result will be like this. It will have the same indentation you added in the cell you autofill from.indent has been added in google sheets
  4. Then, you can edit those cells with any new text quickly.changing google sheets text

Indent with symbols to create an impression of bullet points

The previous method can be modified to add any symbol you want creating an impression that the cell is part of a bullet list. This method exists because Google Sheets doesn’t have a built-in feature about it.

    1. Simply click the cell you want to indent and want to add a symbol before the text. Head to Format > Number > More format > Custom number format.
    2. Now, put one of these symbols you want to add as the cell’s symbol as if it was a bullet point:
      • ⦿
      • >>
    3. Put it before one empty space before the @. The @ is the first text you would see on the cell. Click Apply to save.apply button
    4. The result will be like this:add symbol to the indent in google sheets

RELATED: How to Change The Default Font on Google Sheets

Copy and paste indented cells to make new ones faster

There’s another method to make new cells with the same indentation than autofill it. You can copy and paste them anywhere in your spreadsheet by using a special method.

  1. Simply click the cells you want to copy. Press CTRL+C to copy.
  2. Then, paste them anywhere by right-clicking it, selecting Paste special > Paste values only.paste indent in google sheets

Now, your job is simply to replace the text with a new one.

How to remove indents in Google Sheets

If you wish to stop using indents for those cells, you can remove the indents by simply removing the empty spaces.

  1. If you manually added empty spaces, simply remove them by double-clicking the cell.
  2. Then remove the empty spaces before the text.
  3. Press Enter.

If you added empty spaces within the Format menu, you can remove them by accessing the Format > Number > More Format > Custom number format. Here, remove the empty spaces. Click Apply.

remove indent in google sheets

Alternative methods to indent in Google Sheets

These methods might not be practical enough, but for those who want different methods, then there they are.

You can align horizontally the text to the center to make it look different than the cell without the indent.

  1. You can do that by clicking the Horizontal align button below the menu.text align center in google sheets

 

You can also indent by putting non-indent cells in the previous column and the “indented” cells afterward. This might not really “indent” those cells, but it works to create an impression of doing one.

add indent by using more column


While Google Sheets doesn’t have built-in features that let you increase indent, you can still do a similar kind of indent by using the above methods as the alternative.

RELATED: How to Add Trendlines in Google Sheets

Similar Posts

Leave a Reply

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