How to Indent within a Cell in Google Sheets

In this tutorial, we will learn How to Indent within a Cell in Google Sheets.

Do you have a list of items within a cell in Google sheets but don’t know how to indent it. Don’t worry this tutorial will guide you to indent within a cell in Google Sheets.

So let’s jump in straight to the solution and find out How to Indent within a Cell in Google Sheets.

To indent within a Cell in Google Sheets.

  • Open your Google Sheet with a list of items that you need to indent.
  • Select all the items in the list.
  • Go to Format Menu
  • Click on Number under Format Menu
  • Select Custom number format
  • Provide your custom number format .
  • Click on Apply

How to Indent within a Cell in Google Sheets : Step by Step Guide

Step 1: Open your Google Sheet with a list of items that you need to indent.

In the below example we have a list of Fruits without indent

How to Indent within a Cell in Google Sheets

Step 2: Select all the items in the list.

On your list select all the items in the cell which you want to indent.

Step 3 : Go to Format Menu

  • Now go to the main menu and select Format menu

Step 4: Click on Number under Format Menu

  • Under Format menu drop-down, go to Number .

Step 5 : Select Custom number format

How To Highlight All Cells Containi...
How To Highlight All Cells Containing A Formula In Excel

Under Number select custom number format.

Step 6 : Provide your custom number format

  • Once you click on Custome number format a new window will pop up.
  • copy and paste ____@ on the provided Custom number formats screen and apply

Step 7 : Click on Apply

You will get an indented list for the select items as per your requirement.

Congratulations you have successfully indented a list within a cell in Google Sheets -:)

We hope this tutorial on How to Indent within a Cell in Google Sheets was helpful.

Related articles :

How to recover deleted google sheets (Easy 3 Step Essential Guide)

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Rotate Text in Google Sheets