ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Disable automatic text wrap? (https://www.excelbanter.com/excel-worksheet-functions/257874-disable-automatic-text-wrap.html)

Staceyglow

Disable automatic text wrap?
 
It appears that when one cuts and pastes from one Excel spreadsheet to
another, it automatically assumes that you want to wrap text if the column is
too narrow. Since I almost never want that, I have to go into the "format
cells" area and uncheck "wrap text" every time.

Is there any way to change the default treatment from "wrap text"?

PlutoNash

Disable automatic text wrap?
 
Does the copied cell have 'wrap text' set?

Have you tried 'Paste Special'?



"Staceyglow" wrote:

It appears that when one cuts and pastes from one Excel spreadsheet to
another, it automatically assumes that you want to wrap text if the column is
too narrow. Since I almost never want that, I have to go into the "format
cells" area and uncheck "wrap text" every time.

Is there any way to change the default treatment from "wrap text"?


Staceyglow

Disable automatic text wrap?
 
No, the neither one had 'wrap text' set.

And I didn't try paste special, but I am sure that will work. Should've
thought of that on my own. THanks

"PlutoNash" wrote:

Does the copied cell have 'wrap text' set?

Have you tried 'Paste Special'?



"Staceyglow" wrote:

It appears that when one cuts and pastes from one Excel spreadsheet to
another, it automatically assumes that you want to wrap text if the column is
too narrow. Since I almost never want that, I have to go into the "format
cells" area and uncheck "wrap text" every time.

Is there any way to change the default treatment from "wrap text"?



All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com