How to disable wrap text permanently?

[man]

Sometimes I type text in a cell and the [Wrap Text] button automatic pressed down. (screenshot 1)

I do not want the [Wrap Text] button to be pressed down permanently. I want it to look like screenshot 2 permanently

How to disable wrap text permanently? Thanks.

screenshot 1

screenshot 2

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to prevent wrap text?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Trevor G]

You could try selecting the column(s)/sheet cells and then select format cells (Ctrl + 1 or right click) and then select the Alignment tab and deselect the wrap text option.

Please also note Fluffs advice on Cross posting.

 

[Alex Blakenburg]

The default is for Wrap Text to be turned off. You said that you manually entered that text, was that really the case ? That is quite a bit of text to enter manually.
The Wrap Text getting turned on is more likely to be related on how you are getting the data into the spreadsheet.
Are you copying it in or importing it or using VBA ?
Another possibility is do you have Workbook (Book.xltx) or Sheet (Sheet.xltx) template in your startup folder (XLStart) that you are using ? And is Word Wrap turned on in that ?

PS: I believe you are using Excel 2021. It is not showing in your profile. Can you please you update your Account details (or click your user name at the top right of the forum) to show the new version number. It will save contributors from asking you each time you post a question.

 

[man]

You could try selecting the column(s)/sheet cells and then select format cells (Ctrl + 1 or right click) and then select the Alignment tab and deselect the wrap text option.

Please also note Fluffs advice on Cross posting.

Your solution will work for one time so the next time I paste in some text into a cell I would need to redo the deselect wrap text procedure again. I am looking for a method to permanently never wrap text automatically by excel.

 

[man]

The default is for Wrap Text to be turned off. You said that you manually entered that text, was that really the case ? That is quite a bit of text to enter manually.
The Wrap Text getting turned on is more likely to be related on how you are getting the data into the spreadsheet.
Are you copying it in or importing it or using VBA ?
Another possibility is do you have Workbook (Book.xltx) or Sheet (Sheet.xltx) template in your startup folder (XLStart) that you are using ? And is Word Wrap turned on in that ?

PS: I believe you are using Excel 2021. It is not showing in your profile. Can you please you update your Account details (or click your user name at the top right of the forum) to show the new version number. It will save contributors from asking you each time you post a question.

The screenshot are sample text to show what happened. Using Excel 2021.
Wrap Text will auto happen when I copy and paste into a cell. I forgot if it happened if I type in long text.
I am copy text from elsewhere and paste into excel, not importing or using VBA
What are "Workbook (Book.xltx) or Sheet (Sheet.xltx) template in your startup folder (XLStart) that you are using"? How to check? This is the first time I come across this. My sheet is .xlsx

My problem:
When I paste in text in a cell, the Wrap Text button is auto pressed by excel
e.g. copy text from post #4 and paste in text into Excel 2021 cell A3, this is the screenshot

Then I manually click the Wrap Text button manually once to unpress the Wrap Text button, this is the screenshot (this is what i want it to look permanently for all cells)

Then if I click A3 cell and add or edit text in A3 cell, the Wrap Text button is auto pressed by excel, this is the screenshot

I want the Wrap Text button to be unpressed permanently regardless of anything I do to the cell, how to do it? (if i want to read the contents of the cell i would click on the cell to read the contents displayed on the top (just below ribbon))

Thanks

 

[Alex Blakenburg]

To "automatically' make the cell now change the Wrap would involve and Event macro or possible sheet protection and I think both will create more issues than it solves.
It seems to me that the main issue can be addressed simply by copying in your new data as Value only.
A straight copy-paste will bring in any formatting from the source data.

Since you seem to be using the mouse to unwrap consider putting the Paste-Values button on your quick access toolbar for easy access.
Goto to the Paste Drop down > right click on the first icon in the Paste Values group > Add .. to Quick Access Toolbar
Then use this to paste in the new data without bringing in the formatting with it.

Templates don't factor into this since using copy-paste will override anything setup in the template anyway.
If you want to know more about it here is a link:

How to set a default template in Excel

Excel has the ability to use a custom template for all new workbooks. If you find yourself making the same changes to new workbooks (changing row height, font size, zoom, etc.) a default custom template can save you time and trouble.

exceljet.net

 

[man]

To "automatically' make the cell now change the Wrap would involve and Event macro or possible sheet protection and I think both will create more issues than it solves.
It seems to me that the main issue can be addressed simply by copying in your new data as Value only.
A straight copy-paste will bring in any formatting from the source data.

Since you seem to be using the mouse to unwrap consider putting the Paste-Values button on your quick access toolbar for easy access.
Goto to the Paste Drop down > right click on the first icon in the Paste Values group > Add .. to Quick Access Toolbar
Then use this to paste in the new data without bringing in the formatting with it.

Templates don't factor into this since using copy-paste will override anything setup in the template anyway.
If you want to know more about it here is a link:

How to set a default template in Excel

Excel has the ability to use a custom template for all new workbooks. If you find yourself making the same changes to new workbooks (changing row height, font size, zoom, etc.) a default custom template can save you time and trouble.

exceljet.net

View attachment 110617

I do not have Paste Values (screenshot below) so I unable to do "Add .. to Quick Access Toolbar" step.

I tried copy post #4 in this forum then I double click on A3 cell and then click on button 1 in my screenshot to paste, same problem auto Wrap Text by excel auto press the wrap text button happened as mentioned in post #6

I tried copy post #4 in this forum then I double click on A3 cell and then click on button 2 in my screenshot to paste, same problem auto Wrap Text by excel auto press the wrap text button happened as mentioned in post #6

I tried copy post #4 in this forum then I double click on A3 cell and then click on button 3 in my screenshot to paste, same problem auto Wrap Text by excel auto press the wrap text button happened as mentioned in post #6

I tried copy post #4 in this forum then paste into Notepad (my understanding is Notepad will not paste in any formatting from source data), then I copy text from Notepad then I double click on A3 cell and then click on button 1 in my screenshot to paste, same problem auto Wrap Text by excel auto press the wrap text button happened as mentioned in post #6

 

[Alex Blakenburg]

I tried copy post #4 in this forum then paste into Notepad (my understanding is Notepad will not paste in any formatting from source data), then I copy text from Notepad then I double click on A3 cell and then click on button 1 in my screenshot to paste, same problem auto Wrap Text by excel auto press the wrap text button happened as mentioned in post #6

This would be pretty damming but only if you reset the Wrap to No Wrap before you copied it in.

It looks like my Paste Special Values image wasn't clear. The icon you are using is not the Paste Values one.
The Paste Special Values icon looks like the below image

Start a new sheet or new workbook.
Use a different row for each time you experiment so that you are trying it in a clean cell.

• Goto your source data
• Ctrl+C
• Goto a previously unused cell on a new sheet and new row.
• Right click and select Paste Values from the menu - see image below

If you get that to work then we can talk about the various ways you can get to the Paste Values opton

 

[man]

Unable to see the Paste Special Values icon looks like the below image

I copy all the text in post #4 then
if I single left click on one cell A1 then single right click I see this screenshot

if I double left click on one cell A1 then single right click I see this screenshot