Hello,
Sometime after I input some text in a cell then I see the [Wrap Text] button is 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? Using Excel 2021. Thanks.
screenshot 1 [Wrap Text] button pressed automatically by excel after I input some text in a cell
screenshot 2 [Wrap Text] button not pressed
Cut back on the text or paste the text in as a document box on Excel.
Last edited by bro67; 1 Week Ago at 18:12.
Thanks but this is not what I am looking for. I need to input the text inside a cell and unable to cut back on the text. I want my cells to always appear like screenshot 2 permanently (wrap text button unpressed permanently), but sometimes it will appear like screenshot 1 then I need to manually select all cells and then click wrap text button to make it appear like screenshot 2.
Last edited by comcom; 1 Week Ago at 20:22.
There may some useful videos in youtube
Paragraph row in Excel cells. Create new line within a cell - YouTube
How To Fit Longer Text or Text Wrapping In Excel. Excel Tip - YouTube
Right click cell > Format cell ... > Alignment > Untick Wrap text
To do the whole worksheet, Ctrl+A to select all cells and repeat the above steps, making sure all cells stay selected during the process. If they don't, more than likely there has been a mouse click slip/error, which has cancelled the select all process. Just repeat the steps.
If it happens all the time, sounds like a change has been made to the default template, either the whole workbook or maybe individual worksheet(s) within the workbook. If this is a "permanent" (default thing) you'll have to change the default Excel template
- open a blank workbook
- select all the sheets in the workbook
- select all the cells in every worksheet (Ctrl+A) (just do one worksheet; if they're all selected then the others will be auto fully selected)
- right click any cell (all cells/worksheets should stay fully selected) > Format cells > Alignment > untick Wrap text
- save workbook as the default opening workbook (special steps for Excel, unlike Word, your search engine will be your friend)
I have tired your steps but the problem still happens.
In my current excel file, I done these steps below and the problem still happens.
Right click cell > Format cell ... > Alignment > Untick Wrap text
To do the whole worksheet, Ctrl+A to select all cells and repeat the above steps, making sure all cells stay selected during the process.
Then I test by I copy long text (e.g. first 8 paragraphs from Software testing - Wikipedia ) and paste into a Excel 2021 cell (double click a cell then paste) then the Wrap Text button will automatically be press down and I see the text are Wrap Text mode
In a new excel file, I done these steps below and the problem still happens.
- open a blank workbook
- select all the sheets in the workbook
- select all the cells in every worksheet (Ctrl+A) (just do one worksheet; if they're all selected then the others will be auto fully selected)
- right click any cell (all cells/worksheets should stay fully selected) > Format cells > Alignment > untick Wrap text
Then I test by I copy long text (e.g. first 8 paragraphs from Software testing - Wikipedia ) and paste into a Excel 2021 cell (double click a cell then paste) then the Wrap Text button will automatically be press down and I see the text are Wrap Text mode
That's because the formatting in the copied text is carried into the spreadsheet
If you copy the selected text (say, 2-3 paragraphs), then go to Excel, choose the destination cell > Paste Options, there will be 2 icons
- Keep Source Formatting
and
- Match Destination Formatting
The former copies text as wrapped (equivalent of Ctrl+V), the latter copies each paragraph separately to a new vertical cell (effectively a new line), with the rest of the paragraph text unwrapped
If you copy the selected text (say, 2-3 paragraphs), then go to Excel, then double click left mouse button on one cell, then right click on the cell then paste (there is only 1 paste button to select from), the excel auto Wrap Text button is pressed problem still happens.
Your Paste Options have 2 icons
- Keep Source Formatting
and
- Match Destination Formatting
because you are not pasting into a single cell, you single click left mouse button on one cell and right click to paste so you have 2 icons, these 2 icons will paste the data into many different rows and cells.
Quote