+ Reply to Thread
Results 1 to 3 of 3

how to keep the text contents of a cell from spilling over

  1. #1
    Forum Contributor
    Join Date
    06-21-2009
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    200

    how to keep the text contents of a cell from spilling over

    In the model I'm working in there's a column for comments. These comments are often pretty long and won't fit in that cell without spilling out into other columns and looking pretty ugly. The alternative is to wrap text, but then that throws off the row height and again looks really bad.

    Is there some way to contain the contents of a cell to that cell, without changing the row/column dimensions?

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: how to keep the text contents of a cell from spilling over

    This will keep the text only into the visibnle part of the cell,but you will not be able to see it all:
    Format - Cells - Alignment tab
    under Horizontal, pick Fill
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    12-16-2015
    Location
    East Coast
    MS-Off Ver
    2016
    Posts
    33

    Re: how to keep the text contents of a cell from spilling over

    i noticed that if the text in that cell is short, it will repeat it as many times at it fits in the cell

    for example if on one cell the most I can fit is 10 characters
    then a work that uses 6 or more characters will only appear once
    a word that uses 3 characters will appear 3 times

    is that normal?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 04-21-2016, 02:15 PM
  2. Replies: 1
    Last Post: 04-13-2013, 10:17 AM
  3. Replies: 0
    Last Post: 11-16-2012, 11:42 AM
  4. Replies: 1
    Last Post: 10-30-2011, 03:16 PM
  5. Words Spilling into Next Column
    By ClaireW in forum Excel General
    Replies: 1
    Last Post: 03-13-2008, 02:21 PM
  6. Contents in cell not "spilling" into adjacent blank cell
    By bluegrassstateworker in forum Excel General
    Replies: 1
    Last Post: 08-14-2006, 02:35 PM
  7. [SOLVED] text spilling over text and colums
    By flutterby in forum Excel General
    Replies: 2
    Last Post: 01-11-2006, 10:30 AM

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