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.
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.
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
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
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
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
Perfect, thank you so much. Donna
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)
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
Graeme, thats a really good ideaThat 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks