Excel question

[Fitnessfreakk366]

Hopefully there is an Excel guru out there. Need some help. I'm new to this program and I just completed my first spreadsheet. Yay!

How do you type more then one line in one row? For instance, I have to get all this on one line in a column width that is too small:

R003-R003; R005-R005; B001-B999; C001-C003

The C001-C003 goes into the next column and I don't want it there, I want it to go right under R003 without going in the next cell below. I can't figure out how to do it. I widened the row height, but it still won't let me hard return under R003. Can it be done in Excel?

So I want it to look like this in one cell:

R003-R003; R005-R005; B001-B999;
C001-C003

Help!

 

[Liann]

If you are using Windows 7, this might not work, but for anything else:

Put your cursor over the cell and do a right click.
Pick "Format Cells" from the drop down list
Click on the "Allignment" tab and select "Wrap Text"
You'll then have the resize the cell to show all the text how you want it, but the text will now automatically go to the next line in the cell instead of flowing across to other cells.

We are upgrading to W7 next week at work, so I'll be able to answer for W7 in another week.

 

[Fitnessfreakk366]

We have Windows XP but I'll try that. Thanks Liann!

 

[Liann]

It should work in XP. Windows 7 just has a different menu set-up, so I'm not sure what happens when you right click on something.

 

[Fitnessfreakk366]

It did work, thank you very much! I'll probably be back with more questions!!

 

[Liann]

No problem, glad to help!

 

[Autumn68]

I've actually been teaching myself advanced excel to improve my skills in hopes that it helps me get a job. I know the basic's and some advanced work; I've been learning a lot from free tutorials on you tube. You can learn just about anything there. Here is a link for the "basic excel".
autumn
http://www.youtube.com/results?search_query=tutorial+basic+excel&page=&utm_source=opensearch

 

[morningstar]

You can also use "ALT+Enter" to wrap the text.

 

[Fitnessfreakk366]

Thanks Autumn and Morningstar.

Autumn, I took a tutorial on Excel on advanced stuff but unless I actually start using it, I forget what was taught. I need to really start using Excel, not sure why I haven't been? I like it and it seems fairly easy to use. Thank you for the link, I will definitely check it out!

 

[carres1973]

morningstar - THANK YOU for the Alt+Enter tip. I have used Excel for YEARS and have always hit the space bar to get things to the next line. I am such a blonde!

Carrie

 

[Fitnessfreakk366]

morningstar - THANK YOU for the Alt+Enter tip. I have used Excel for YEARS and have always hit the space bar to get things to the next line. I am such a blonde!

Carrie

I know, I tried Shift + Enter and CTRL + Enter but never thought to try ALT + Enter.

Duh!