Dot leaders are repeated dots that visually connect a label to the corresponding information on the same line, commonly used in tables of contents but also used in accounting formats, for example:
Income ............. $ 100,000 Expenses ........... $ 80,000 Net Income ......... $ 20,000
In Excel, you can add dot leaders to any cell as follows:
- Right click on the cell and select Format Cells….
- Select the Number tab.
- Under Category, select Custom.
- In the Type field, input
- Click OK.
After the cell's content (represented by the
@ in the Type field input), this will display a space followed by however many periods it takes to fill the cell, i.e., a dot leader.
Apart from the obvious way of just manually putting in a bunch of periods at the end of each cell, is there a way to do the same thing in Google sheets?