+ Reply to Thread
Results 1 to 6 of 6

Left side spacing within a particular cell

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Toronto, Ontario
    MS-Off Ver
    Professional 2016
    Posts
    2

    Left side spacing within a particular cell

    Hopefully I can explain this correctly:
    How do I line-up items like the attached illustration, where things are lined up one underneath each other within a particular cell? Is there a special setting for this?

    Capture.PNG

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Left side spacing within a particular cell

    If I understand you correctly, after the word "claims" in the first line, Alt + Enter
    HTH
    Regards, Jeff

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Left side spacing within a particular cell

    Hello and welcome to the forum.

    You can go to a new line by hitting Alt + Enter.

    That being said, this is not a god habit to be getting into. This type of data layout will make it very difficult to actually use the data for anything short of looking at it.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Left side spacing within a particular cell

    In addition to what Jeff (and 63FD) told you, you will have to do it in every cell where you want it to appear.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Registered User
    Join Date
    01-11-2019
    Location
    Toronto, Ontario
    MS-Off Ver
    Professional 2016
    Posts
    2

    Re: Left side spacing within a particular cell

    You guys are awesome! Many thanks.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Left side spacing within a particular cell

    You are very welcome and thanks for the feedback. We are happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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: 14
    Last Post: 09-03-2018, 01:45 PM
  2. [SOLVED] Data shift from right side to left side
    By nur2544 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-03-2014, 11:37 AM
  3. [SOLVED] How can I change Chart.Axes(xlValue) from left side to right side ?
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-15-2014, 02:18 PM
  4. [SOLVED] Why Minus (-) Symbol Coming Right Side Instead of Left Side ???
    By jd16 in forum Excel General
    Replies: 9
    Last Post: 10-20-2013, 12:16 AM
  5. [SOLVED] How to shift numeric number from left side to right side of a particular word
    By nur2544 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-13-2013, 09:05 AM
  6. [SOLVED] How to move data from right side to left side, please check the attachment
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2013, 03:43 AM
  7. Excel 2007 : How to Get Value from Left Side Cell?
    By agusbagus in forum Excel General
    Replies: 7
    Last Post: 09-23-2010, 08:36 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