Results 1 to 4 of 4

How to prevent wrap text?

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2021
    Posts
    43

    Question How to prevent wrap text?

    Hello,

    After pasting some text in a cell, I see the [Wrap Text] button will be automatic pressed down by Excel 2021. (screenshot 1)

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

    I want the Wrap Text button to be unpressed permanently regardless of anything I do to all cells in Excel 2021, 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))

    screenshot 1 [Wrap Text] button pressed automatically by excel after I input some text in a cell or if I click the cell then add or edit text.
    wrap text button is press down (i do not want).PNG

    screenshot 2 [Wrap Text] I need to click Wrap Text button to manually unpress the Wrap Text. I want my sheet to look like this permanently.
    wrap text button is not press down (i want it).PNG

    Using Excel 2021
    Last edited by rowrow; 04-27-2024 at 09:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-05-2016, 05:49 PM
  2. [SOLVED] How do I align text left the horizontal axis labels and wrap text them?
    By rs1aj in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-11-2015, 03:52 AM
  3. [SOLVED] Wrap Text in ListView: how to wrap text in the columns of a list view
    By TommyToe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 07:02 AM
  4. Cell wrap text: Some cells have blank white space above text
    By stuckagain in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 06-09-2009, 06:47 AM
  5. Text wrap and allow cell height to increase with wrap
    By tpenterprize in forum Excel General
    Replies: 1
    Last Post: 10-19-2007, 02:30 PM
  6. Text not continuing to wrap for large block of text in Excel cell
    By Mandra in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2006, 02:15 PM
  7. Replies: 1
    Last Post: 05-19-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1