Jul 12 2024 12:31 PM
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.
Jul 12 2024 01:40 PM
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.