00:00With a simple indentation, you can exponentially help improve the visual organization and hierarchical
00:04readability of your spreadsheet yet. No one does it. Well, I do not know the reason why.
00:09It only requires seven clicks and here's how you do it. The first click will be to select the cell
00:13that you want to apply indentation to. Then you go format, number, custom number format. And after
00:19that, you're going to apply the number of spaces or indentation. I'm going to indent it with three
00:24spaces. So one, two, three. And you're going to put a string or text placeholder which is going
00:29to be ampersand like this. If it's a number, you're going to say pound like this. Since
00:34it's a string text for me, I'm going to say ampersand and hit apply. And you also can apply
00:38to multiple cells. Select the very first cell, hold the shift button and select the last cell
00:44on your spreadsheet and then follow the same step. Format, number, custom number format.
00:49And then let's say this one I want to give six indentation space. One, two, three, four,
00:53five, six and ampersand to indicate string and hit apply.
00:59Seven.
Comments