+ Reply to Thread
Results 1 to 10 of 10

Setting up margins for new Excel sheet

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    Berrien Springs, mi
    MS-Off Ver
    Excel 2010
    Posts
    4

    Setting up margins for new Excel sheet

    Okay I know some basics of Excel. I start to write my information on a new Excel sheet and it continues across the page (for ever), how do I set up a page so that when it gets to the side margin it will go to the next line (like in Word)? I just can not figure it out, so I would really appreciate any help. Thank you.

  2. #2
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Huntsville, AL
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: Setting up margins for new Excel sheet

    I believe you want to use the Wrap text feature on your home ribbon. You can move the cell out to the length that you see fit. Please be aware that Excel only allows you 255 characters per cell.
    Therefore, it is not the best tool for word processing.

    Thanks,

    Gregg
    Please let me know if it works. Also add to my reputation.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: Setting up margins for new Excel sheet

    Hi and welcome to the forum

    What exactly are you trying to do?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    09-19-2013
    Location
    Berrien Springs, mi
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Setting up margins for new Excel sheet

    Thank you Gregg, I did try that feature, but did now move the cells, so it just went down, which didn't work for me. I will try your suggestion and see if I can get it to work for me. I do agree it is not the best tool for word processing, but I am creating an application, which Excel works wonderful for, just this one part had a small paragraph that I needed in there and as I was typing it it just kept going and going. Thank you again. Donna

  5. #5
    Registered User
    Join Date
    09-19-2013
    Location
    Berrien Springs, mi
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Setting up margins for new Excel sheet

    Thank you for the welcome. I am creating an application in excel and in one part of it I need to write a small paragraph of description. As I type the paragraph it just keeps going and going and going across the page. I don't know how to set up parameters, margins or what ever the right term is to keep my typing in the space of a piece of paper so that when I print it my typing won't go off the page. Thank you for your response. Donna

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: Setting up margins for new Excel sheet

    OK as suggested, set the cell (range of cells?) to Wrap Text - Home tab/alignment, and then widen that column to an acceptable width. As you type, it will wrap the text within the cell, and should increase the row height to accomodate the wrapped text

  7. #7
    Registered User
    Join Date
    09-19-2013
    Location
    Berrien Springs, mi
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Setting up margins for new Excel sheet

    Perfect, thank you so much. Donna

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: Setting up margins for new Excel sheet

    you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 at the bottom of my FIRST post to this thread)

  9. #9
    Registered User
    Join Date
    05-13-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Setting up margins for new Excel sheet

    Your other option is to Insert Text Box, which will give you a drag-to-size box which functions a little like rudimentary word-processing, auto-wrapping at the end of a line, and so on.
    regards,
    Graeme

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: Setting up margins for new Excel sheet

    Graeme, thats a really good idea That has its own problems though - the data in the boxes will not be (easily) available to formulas for searches/counts etc, and the OP will have to create a new text box (and position/size it) for every row

+ 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. Macro for setting margins
    By floricita in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-14-2010, 05:03 AM
  2. [SOLVED] Setting up margins in excel so data wont continue
    By krazygmtrk in forum Excel General
    Replies: 1
    Last Post: 03-08-2009, 12:47 PM
  3. [SOLVED] Need help setting the worksheet header/Footer margins based on string height?
    By Doug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2006, 12:15 PM
  4. Replies: 0
    Last Post: 08-19-2006, 09:10 PM
  5. Replies: 0
    Last Post: 03-30-2005, 10:06 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