Turn Off Wrap Text in Pasted Data

August 31, 2023 - by Bill Jelen

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.

When pasted from the web, there are tiny icons in many cells, and Wrap Text is turned on. — Figure 1299. 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.

Turn off Wrap Text after pasting from a web page. — Figure 1300. The pasted data now has normal formatting.

This article is an excerpt from Power Excel With MrExcel

Title photo by Jose Aragones on Unsplash