How to Wrap Text for Every Cell in a Spreadsheet in Excel 2013

Microsoft Excel provides you with a lot of tools that let you control the width of your columns and the height of your rows. We’ve written about how to expand cells in Excel as a means to make this a little easier, but that might not provide you with the results that you needed.

You may have already found the option to wrap text in Excel 2013, but you might have noticed that it will only apply to the cell that is currently selected. This is not something that can only be done to one cell at a time, however. You can wrap text for multiple cells at once if they are all selected, and you can even wrap text for every cell in a spreadsheet in Excel 2013.

Our guide below will show you how to select all of your cells, then apply the “Wrap Text” effect to those selected cells. Your cells will then automatically resize to display the data contained within them.

How to Apply Wrap Text to an Entire Spreadsheet in Excel 2013

The steps below are going to show you how to select your entire spreadsheet, then apply the Wrap Text formatting to that spreadsheet. Wrap Text will automatically force your data onto additional lines so that it remains visible within the current confines of your column widths. The height of your cells, however, will change to accommodate the increase number of lines within the cells.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the button above the Row 1 heading and to the left of the Column A heading to select the entire worksheet. You can also select the entire spreadsheet by clicking on any cell, then pressing Ctrl + A on your keyboard.

how to resize cells in excel 2013

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

how to apply wrap text to an entire spreadsheet

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

how to wrap text for all cells in excel 2013 spreadsheet

Note that you can manually add additional lines inside a cell by clicking at the point in the cell where you want the line break, then holding down the Alt key on your keyboard and pressing Enter.

You can perform a similar function by autofitting the column widths in Excel 2013. This will automatically expand the width of the columns to display the data contained within them. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.