Make All Text Visible in One Cell in Excel 2010

Occasionally you will need to put a lot of data into a single cell in Excel. You may already know how to manually adjust the size of a cell to make that text visible, but this may not be the ideal solution for every situation. Excel has a “Wrap Text” feature that you can use to automatically adjust the size and appearance of a cell so that you can read all of the text contained within the cell.


Using Wrap Text in Excel 2010

Excel is automatically going to to determine the necessary row height for the information contained within your cell. The current column width will remain the same once you click the Wrap Text button. If you find that, after using the Wrap Text tool, you are not happy with the appearance of the data displayed inside the cell, you can manually increase the column width or the row height until you are happy.


Step 1: Open your spreadsheet in Excel 2010.


Step 2: Click the Home tab at the top of the window.

click the home tab



Step 3: Click the cell containing the text that you want to display.

select the cell you want to edit



Step 4: Click the Wrap Text button in the Alignment section of the ribbon at the top of the window.

how to make text visible in one cell in Excel 2010



All of the text inside the cell will now be visibly displayed on your spreadsheet.

sample of wrap text



As mentioned previously, you can manually resize the rows and columns as needed to improve the appearance of the text as well.

Everyone should be backing up their important pictures and files in case something happens to their computer or hard drive. One of the best ways to do this is with an external USB hard drive, which can be purchased at very affordable prices. Click here to check out a 1 TB option at Amazon.

Our article about how to fit a spreadsheet on one page in Excel 2010 offers an easy option to simplify Excel printing.


Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides