Adjust spacing of numbers in Excel - how to do it

Excel is a good choice if you want to display data and numbers clearly. However, this simple overview is visually compromised if the spacing of the numbers is different. We'll show you how to give your folders a unified look.

How to adjust the spacing

Although it sounds petty, consistent number spacing will make your Excel folder look neat and tidy - this is especially interesting if you need the file for professional purposes.

• If you want to change the spacing of the numbers in only one cell, then click the cell in the corresponding row.
• Drag the upper or lower boundary line in the corresponding direction. This procedure requires a sense of proportion, so that the result is uniform.
• If you want to achieve a uniform look of the complete folder, then you should change the spacing of all rows. To do this, select all rows with the key combination "CTRL" and "A".
• Select one of the selected rows and move the boundary line so that you have reached the appropriate spacing of the rows.
• Excel will now apply the cell that you have set up manually as a template for all rows within the present folder. This will give you an absolutely uniform look.

What you should pay attention to

Get an overview in advance of what line spacing you need so that all content remains clearly legible. Base this on the cell that needs the most space so that all content is displayed properly. In addition, you should consider whether you want to present the folder in printed form. If that is the case, make the spacing of the numbers more generous to make it easier to read.