In Excel, sometimes, the cell contents are too many to display fully in the cell as below screenshot shown. Here in this tutorial, it provides some ways to display all content in a cell for users 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.
Display all contents with AutoFit Column Width function
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.
Display all contents with Enhanced Edit Bar
If there are large of contents in cells which you do not want to change the row height and column width of cells for keeping good-look of the worksheet, you can view all contents by using Kutools for Excel’s Enhanced Edit Bar function, which can display all contents in a prompt dialog while you click at the cell.
Click Kutools > Enhanced Edit Bar to enable the Enhanced Edit Bar.
From now on, while you click at a cell, a dialog will prompt to display all contents of the active cell, and also, you can edit contents in this dialog directly to update contents in the cell.
Other Operations (Articles) Related To Text
Convert date stored as text to date in Excel Occasionally, when you copy or import dates from other data sources to Excel cell, the date might become formatted and stored as texts. And here I introduce the tricks to convert such these dates stored as texts to standard dates in Excel.
Add text cells together into one cell in Excel Sometimes, you need to combine text cells together into one cell in some purpose. In this article, we will show you two methods to add text cells together into one cell in Excel with details.
Allow only numbers to be input in text box In Excel, we can apply the Data Validation function to allow only numbers to be entered into cells, but, sometimes, I want only numbers to be typed into a textbox as well as in cells. How to accept only numbers in a textbox in Excel?