How to Indent in Google Sheet

Google Sheets is one of the famous online spreadsheets offered by Google which allows you to create and edit your sheet within the real-time world as it allows users to collaborate with each other from all over the world. Whenever creating a Google Sheet, you need to indent your data properly in the cells to make it well formatted. By using the features of Google Sheets, you can easily indent your data quickly. In this article, we will be learning how to Indent in Google Sheets in some easy and simple steps.

In Google Sheets, an indent refers to the spacing applied to the left or right of cell contents, typically used for organization or readability.

Step 1: Open Google Sheets

Open Google Sheets on your desktop by visiting the official Google Sheets website and select a sheet for applying indentation.

Step 2: Locate the Cells

After opening the Google Sheets locate the cells on which you want to indent.\

Step 3: Type Spaces

To apply indentation to the particular cell just enter the spaces before or after the text by the “Space” button, you can also adjust the spaces on your needs.

Step 1: Open Google Sheets

Open Google Sheets on your desktop by visiting the official Google Sheets website and a select a sheet for applying indentation.

Step 2: Select the Cell and Click on “Format” Menu

After opening the sheet on which you want to apply the indentation select your desired cells on which you wish to apply indentation. You can simply select the cells by using your mouse or you can also use “Shift + Arrow keys” to select the cells. And when you are done with selecting the cells click on the “Format” menu located at the toolbar.

Step 3: Select “Number” and Go to “Custom Number Format”

On the moment you will click on the Format from the toolbar, a drop-down menu will appear on the screen containing some number of options. Among all the options click on the “Number” option and “Custom Number Format” to apply the custom number formatting on the selected cells.

Step 4: Type your Custom Number Format

Now a window will appear asking you to type your custom number format just start typing the spaces you need in your indentation and at last type “@” sign, can you also manage the spaces between the indentation. After customizing the format click on the “Apply” button located next to the format number.

Step 5: Review Changes

Now when you will click on the apply button then onwards the indentation will be applied to the cells.

Step 1: Open Google Sheets

Open Google Sheets on your desktop by visiting the official Google Sheets website and a select a sheet for applying indentation.

Step 2: Select a Cell and Type “=ARRAYFORMULA(“

In the selected cell enter the formula “ARRAYFORMULA(“ to apply the indent to a particular cell by the referencing method.

Step 3: Type the Spaces >> Cell reference

After this just type the number of spaces you want to be displayed on the cell and type the cell reference.

Step 4: Indentation Applied

Now you have successfully applied the indent to the cell by using the formula method.

In the above we have learned that how we can apply indent to the particular cells by the three methods, you can use any of the method discussed in the above article. All you have to do is open Google Sheets and select a sheet on which you want to apply the indent, then select the particular cells and click on the “Format” menu. In the Format menu select the “Number” >> “Custom Number Format” to apply indentation custom. After you can specify the number of spaces in the box ended by the “@” sign and after clicking on the “Apply” button you are done with applying the indent to the selected cells.

Can we Apply Indentation to the text without affecting to the data?

Yes, by using the method of Number Formatting you can indent to the cells without affecting the data. Number Formatting method doesn’t make any changes in the data it just adds the indentation to the selected cells.

Can I Just enter the Spaces?

Yes, it comes under the manually indentation, but you cannot indent to a large number of cells in the sheets.

Can I adjust the formatting later?

Of course, you can change the formatting settings by going to the “Number Formatting” section.