View Single Post
  #4   Report Post  
Tim Paine Tim Paine is offline
Junior Member
 
Posts: 27
Default how to show full cell contents in excel?

In Excel, the Wrap Text function will keep the column width and adjust the row height to display all contents in each cell.

Select the cells that you want to display all contents, and click Home Wrap Text.
Then the selected cells will be expanded to show all contents.
If you do not want to change the row heights of cells, you can use the AutoFit Column Width function to adjust the column width of cells for showing all contents.
Select the cells that you use, and click Home Format AutoFit Column Width.
Then the cells will be adjusted the column width for displaying the cell contents.

I hope this helps!
Tim Paine