How to look my data in one cell not overlapped

Copper Contributor

Hello everyone, 

 

A quick question - how to make/look my data in highlighted green area to be visible completely without occupying more space(or extending cell length as we used to print the document on one page. My purpose is to show data in a way so that it prints on page corrcetly.

2 Replies

@MSTS0022 

Select the cells.

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

Clear the check box 'Wrap text'.

Tick the check box 'Shrink to fit'.

Click OK.

 

Alternatively, select a smaller font size.

Thanks much for helping!