How to Indent in Google Sheets | Scribe

    How to Indent in Google Sheets

    • Alai Umerez |
    • 11 steps |
    • 24 seconds

      How to Indent Manually

      1
      Double-click the cell you want to indent and press the spacebar as many times as you wish
      2
      Check if the information of the cell you indented has the correct spacing
      information ordinal icon
      Note: Manually indenting in Google Sheets by typing spaces is a slow and inefficient approach that consumes a significant amount of time While it might appear to be a simple solution, this method can cause formatting problems and make your data harder to read. Additionally, it is inconsistent, as the width of the spaces between words can vary based on the font and font size used

      How to Indent with Custom Number Formatting

      3
      Select the cells you want to indent
      4
      Click on "Format" at the top menu
      5
      In the drop-down menu, choose the option "Number"
      6
      Click "Custom number format"
      7
      Click on the "Custom number format" text field and press the spacebar the desired number of times you wish to indent the text For instance, if you want to indent the text four times, press the spacebar four times
      8
      Type "@" after the spaces and click "Apply" to save the changes

      How to Indent with a Formula

      information ordinal icon
      Formula =ARRAYFORMULA(" "&Cell you want to indent)
      9
      Click the cell where you wish to add the indented information Type "=ARRAYFORMULA"
      10
      In between quotation marks, add the number of spaces you wish to indent the text For example, if you'd like to indent the text 5 times, press the spacebar 5 times within the quotation marks Then, add "&" and select the cell reference
      information ordinal icon
      For the example above, the formula should be =ARRAYFORMULA(" "&E4)
      11
      Review the result of your indentation