User Tag List

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Excel Help Please

  1. #1
    Regular Member jka's Avatar
    Join Date
    Jun 2005
    Location
    Kirkcaldy
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default Excel Help Please

    Morning

    I am making up a simple spreadsheet that contains a couple of large paragraphs of text.

    Can anyone tell me if there is a way to type in Excel that when you get to the page break it automatically shows the text on the next line?

    Cheers

    JKA

  2. #2
    Ex Vec-C Admin & Founder Bainie's Avatar
    Join Date
    Jun 2005
    Location
    60 Degrees North !!
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Are you typing in a cell or as a word document ?

  3. #3
    Regular Member jka's Avatar
    Join Date
    Jun 2005
    Location
    Kirkcaldy
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Typing in a cell.

  4. #4
    Regular Member Ian's Avatar
    Join Date
    Oct 2005
    Location
    York
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    dont think you can, but try this site www.mrexcel.com its very useful!

  5. #5
    Ex Vec-C Admin & Founder Bainie's Avatar
    Join Date
    Jun 2005
    Location
    60 Degrees North !!
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    So you want to type in the cell but split the cell over 2 pages ?

  6. #6
    Regular Member jka's Avatar
    Join Date
    Jun 2005
    Location
    Kirkcaldy
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Say I start typing in A1, when I finsih the text is split over the first page and the page to the right also. What I am looking for Excel to do is to allow me to type the paragraph in this cell but automatically show the text on a new line when it reaches the page break.

    I'm sure I did something similar a couple of years ago but can't recall how. I'm sure I didn't have to insert a word document but if it comes to it that's what I'll do.

  7. #7
    Regular Member
    Join Date
    Apr 2006
    Location
    Milton Keynes, Bucks
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Possible option - you can select all the cell's for a single page and right-click, select Format Cells, click on the tab Alignment, select Merge cells and Wrap Text.

    Now whenever you type in that *single* cell, all the text will be placed into that *single* cell and if the text is longer that the cell, it will wrap-around under the cell...

  8. #8
    Regular Member Tim2100's Avatar
    Join Date
    Jul 2005
    Location
    Walsall
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Select the cell, go to format , cells, in Alignment tab there is an option called 'Wrap text' Select that option, however wide you cell is it will wrap the text ie put in the same cell on multiple lines. However if you want it over the page then select the amount of cells across and click merge cells (in the alignment tab) in addition to the wrap text, or centre across selection which is easier but centre the text across all the cells (don't forget the wrap text option also)

    HTH
    Tim.

  9. #9
    Regular Member Tim2100's Avatar
    Join Date
    Jul 2005
    Location
    Walsall
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    ****** thobbs beat me to it whilst I was typing!

  10. #10
    Ex Vec-C Admin & Founder Bainie's Avatar
    Join Date
    Jun 2005
    Location
    60 Degrees North !!
    Problems Posted
    0
    Problems Solved
    0
    Best Answers
    0
    Good Answers
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Vehicle InfoStats





    Default

    Just what they said, you can also `shrink text` to make it fit, though this is sometimes a bit untidy as you get different font sizes ...

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MS Excel - Any Experts?
    By Aidi in forum The 'Off Topic' room
    Replies: 3
    Last Post: 22nd April 2012, 17:24
  2. Excel Macro's - Any Experts
    By spennny in forum The 'Off Topic' room
    Replies: 3
    Last Post: 17th July 2010, 09:26
  3. Excel and Vista
    By ED1435 in forum The 'Off Topic' room
    Replies: 12
    Last Post: 19th February 2009, 19:58
  4. excel help
    By shan in forum General Chat
    Replies: 11
    Last Post: 7th November 2007, 00:33
  5. MS Excel Experts
    By Damian in forum General Chat
    Replies: 4
    Last Post: 24th September 2006, 19:18

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!

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
  •