SOLVED

Standard spacing in an Excel cell

Copper Contributor

Hi there,

 

A quick query, I am working in excel and I need to know how to add a standard spacing to within a cell. I only want to add 5 spaces to the start of a cell, so that any text is offset a little. THe indentation button provides an indentation however how do you change the size of this? Can it be customised?

Perhaps there is a better way?

 

Thanks,

Lou

5 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@LouRy80 

Select the cell or cells.

On the Home tab of the ribbon, click the arrow in the lower right corner of the Alignment group.

Set the Indent to 4 or 5 - you'll have to experiment what works best for you. It also depends on the font that you use.

S1563.png

Thank You! @Hans Vogelaar 

thanks
My problem is excel indents about 4 characters with each click, far too many. How can that be reduced?

@KBrohF 

Do you mean that setting Indent to 1 indents 4 characters? That's not how it should work. Which font are you using?

1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@LouRy80 

Select the cell or cells.

On the Home tab of the ribbon, click the arrow in the lower right corner of the Alignment group.

Set the Indent to 4 or 5 - you'll have to experiment what works best for you. It also depends on the font that you use.

S1563.png

View solution in original post