# how to indent in google sheets

Viewport: 1910x922 @1.125x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Indent in Google Sheets
   - body: This guide will walk you through the steps to indent text in Google Sheets. Follow these simple steps to achieve proper indentation within your spreadsheet cells.
   - voiceover: This guide will help you through the steps to indent text in Google Sheets. Follow these simple steps to format your text with indentation.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rgochs00000cju85c0asbp.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Begin by opening your Google Sheets document where you want to indent text. Make sure you have the necessary permissions to edit the document.
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (725, 362), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (725, 362), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Begin by opening your Google Sheets document where you want to indent text. Make sure you have the necessary permissions to edit the document.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rgona600020cjufkbd00yx.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rgfzgt000103hu63yuxnja.png
2. step_02 [image] - Click on the cell where you want to indent the text. Ensure that the cell is active and ready for input.
   - source type: IMAGE
   - description: Select the Cell
   - target: (169.83541373033552, 196.6707801194171), rect: top=215.11111450195312 left=47.55555725097656 width=301 height=202
   - hotspots: 1
     - hotspot_01 (169.83541373033552, 196.6707801194171), rect: top=215.11111450195312 left=47.55555725097656 width=301 height=202
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click on the cell where you want to indent the text. Ensure that the cell is active and ready for input.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rgonay00030cju362haanj.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rghk4r000s03hudht6qbhc.png
3. step_03 [image] - To add 5 spaces before text, use:
= REPT(" ",5) & A1
   - source type: IMAGE
   - description: Insert Spaces
   - target: (208.5395424520007, 334.10896433403974), rect: top=295.77777099609375 left=150.3333282470703 width=122.48611450195312 height=30.22222328186035
   - hotspots: 1
     - hotspot_01 (208.5395424520007, 334.10896433403974), rect: top=295.77777099609375 left=150.3333282470703 width=122.48611450195312 height=30.22222328186035
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: To add 5 spaces before text, use:
= REPT(" ",5) & A1
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rgonbp00040cju9byr4q41.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rghhqg000q03huoq8spcnp.png
4. step_04 [image] - After typing the Formula, press Enter to apply the changes. Your text in the cell should now be indented as per your requirement.
   - source type: IMAGE
   - description: Press Enter
   - target: (236, 304), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (236, 304), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: After typing the formula, press Enter to apply the changes. Your text in the cell should now be indented as per your requirement.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rgoncq00050cjuav517fj2.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rghl5l000t03hulj8p2d5n.png
6. [Outro] Congratulations 🎉
   - body: You have successfully indented text in a cell within Google Sheets. You can repeat these steps for other cells where indentation is needed. If you need further formatting, explore additional features like text alignment and text wrapping.
   - voiceover: You have successfully indented the text in your Google Sheets cell. You can repeat these steps for other cells as needed or explore other formatting options to improve the presentation of your data.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rgfr9b0001jv0cb30qrhsl/cm8rgodyp00010cjugdjrfvnm.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm8rgfr9b0001jv0cb30qrhsl/tour