Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Is it possible to indent text within a spreadsheet cell?

Copper Contributor

Spreadsheet indented list.JPG

For example by changing cell boundaries.

Thank you.

7 Replies
Whether it is or is not, in Excel, if what you're working with is text along the lines of your example, why not simply use Word, where there is a LOT more available vis-a-vis formatting? Word's tables give you all that Excel does in terms of cells, rows and columns, and with far more flexibility.

Or is there something else in your situation, beyond what you're showing and asking about, that requires it to be Excel?
best response confirmed by Hans Vogelaar (MVP)
Solution

@Clive_Beardmore 

Excel isn't a Word processor :). Though, you can Indent with:

Sample.png

 

With your sample, select cells with a., b.,...f. and click the above icon (you can click several times)

@Clive_Beardmore 

Another standard approach is to use 2 or 3 narrow columns and inset the text simply by placing it in the adjacent column.  Naturally the View would be set to hide Gridlines.

PeterBartholomew_0-1701638412305.png

 

@mathetes 

Thanks but a spreadsheet is vital for this task I have.

Thank you, I had not spotted that and does exactly what I need, excellent.
Kind regards
Clive
Thank you Peter, I am using that, however the formatting is long winded so I was looking for something quicker, which has been suggested on another answer,
Thank you
Clive

You're welcome @Clive_Beardmore 

Note that you can also do it with Custom cell styles

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Clive_Beardmore 

Excel isn't a Word processor :). Though, you can Indent with:

Sample.png

 

With your sample, select cells with a., b.,...f. and click the above icon (you can click several times)

View solution in original post