This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Turn Off Wrap Text in Pasted Data
Problem: I regularly paste information from Web pages, and I am frustrated by the way Excel wraps text in cells. Below, , column A is not wide enough for the date, and column B is wrapped so that you can see only a few rows on the screen. Using AutoFit to make the columns wider will not work when the cells have their Wrap Text property turned on.
Figure 1150 Data pasted from the Web often has Wrap Text turned on.
Strategy: Follow these steps to correct the Problem:
1. Select all cells by pressing Ctrl+A. The cells in your selection will contain some cells with Wrap Text turned on and some cells with Wrap Text turned off. Click Wrap Text on the Home tab to turn on Wrap Text cell for all cells. Click Wrap Text again to turn off the property for all cells. Each row will now be a normal height, and you can see more cells, but you still need to make the columns wider.
2. Select Home, Format dropdown, AutoFit Column Width.
Figure 1151 The pasted data now has normal formatting.