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](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-JvDc90Ky/w:365/h:230/q:auto/https://addnewskills.com/wp-content/uploads/2022/01/image-113.png)
Step 2: Select all the items in the list.
On your list select all the items in the cell which you want to indent.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-Oz1QWazd/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/01/image-114.png)
Step 3 : Go to Format Menu
- Now go to the main menu and select Format menu
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-mHzxzKz-/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/02/image-38.png)
Step 4: Click on Number under Format Menu
- Under Format menu drop-down, go to Number .
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-ihQCWnN5/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/02/image-39.png)
Step 5 : Select Custom number format
Under Number select custom number format.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-m_4Tb-In/w:1024/h:699/q:auto/https://addnewskills.com/wp-content/uploads/2022/01/image-115.png)
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
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-SekjdqCS/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/01/image-116.png)
Step 7 : Click on Apply
You will get an indented list for the select items as per your requirement.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-E1RsJOQX/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/01/image-117.png)
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