For example, you can use the below custom number formats (use without the double quotes) to show a representation of a bulleted list. You can also get more creative and show some markers for the list. In case you want more indentation, you can use more space characters. The above steps would give you the final result as shown below.Īgain to reiterate, by adding the indentation using custom formatting, you have only changed the way text looks in the cell and not the actual text in the cell. In this step, I am manually specifying that I need an indent of 3 space characters (hence I have used three space characters followed by the sign. In the ‘Custom number formats’ dialog box, enter the following custom format (in the field at the top): ” (without the double quotes).Click on ‘Custom Number Formatting’. This will open the ‘Custom number formats’ dialog box.From the options on the right, hover the cursor over the ‘More Formats’ option.It will show additional options on the right. Hover the cursor over the Number option.You can hold the control key and then select these cells to make sure all cells are selected (even if these are non-contiguous) Select the cells for which you want to apply the indentation.Suppose you have a list as shown below and you want to show the category as normal text but the item in the category with a little indent to the right (as shown in the image below).īut when you enter these values in Google Sheets, you end up with a list with the same indentation.īelow are the steps to add indentation the items (while keeping the Category text as is):

And in this method, that’s what we are going to do.

While mostly this is used for formatting numbers, we can also give it some custom format. All these are just different formats while the value in the cell remains the same.

For example, you can have the value 44196 be displayed as 44196.00 or 44,196 or. Remember the number formatting only changes the format of the text/value in the cell, and not the value itself.

Custom formatting excel indent