SOLVED

how to automatically make the Excel cells width increase (and decrease) ?

Honored Contributor

How to automatically make the Excel cells width increase (and decrease) based on the length of the data typed in them.

 

I found this option

 

Annotation 2019-11-27 163735.png

 

but couldn't make it work the way I want. 

I tried CTRL + A to select all of the empty cells and then used that option on them but none of the cells width increased (or decreased) when I typed in them.

 

is there any way to achieve what I want?

I'm using Office 365 Insider.

Thanks in advance

4 Replies
best response confirmed by HotCakeX (Honored Contributor)
Solution

@HotCakeX 

Please check this https://www.get-digital-help.com/auto-resize-columns-as-you-type/. To my knowledge there are no changes on Insiders Fast from this point of view.

Thank you, worked perfectly, that website also had some useful tips that I didn't know of.

@HotCakeX , you are welcome. No one from us knows all tips...