USAFHummer
Topic Author
Posts: 10261
Joined: Thu May 18, 2000 12:22 pm

Microsoft Excel Help, Please!

Sun Jul 03, 2005 4:37 am

Hello...

Just a quick question here...I already have a spreadsheet full of data, but on each cell in a given column of data, I need to add a second row of information, but when I resize a cell in that column to give me that room to add the second row, the blinking cursor stays at the bottom of the cell and I can't get it to go to the top...any tips on how to get it to the top of the cell, where I can then presumably get both rows of data in, with no problem?

Thanks,
Greg
Chief A.net college football stadium self-pic guru
 
TedTAce
Posts: 9098
Joined: Sun Mar 27, 2005 12:31 am

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 4:40 am

I'm guessing you need to insert another row.
This space intentionally left blank
 
USAFHummer
Topic Author
Posts: 10261
Joined: Thu May 18, 2000 12:22 pm

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 4:43 am

Quoting TedTAce (Reply 1):
I'm guessing you need to insert another row.

No...I want to fit two rows of data in the same cell without adding another row...the way my spreadsheet is, adding another row would really screw things up...

Greg
Chief A.net college football stadium self-pic guru
 
USAFHummer
Topic Author
Posts: 10261
Joined: Thu May 18, 2000 12:22 pm

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 5:15 am

http://img.photobucket.com/albums/v300/BuffsandEagles/anetexcel.jpg
Chief A.net college football stadium self-pic guru
 
aak777
Posts: 277
Joined: Thu Apr 26, 2001 10:07 pm

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 5:24 am

I am not sure that I understand your problem but did you try merging and dividing the cells.
 
USAFHummer
Topic Author
Posts: 10261
Joined: Thu May 18, 2000 12:22 pm

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 5:38 am

Basically, what I want to do is get two rows of data, within a single MS Excel cell...whenever I hit enter, like I would in Word to start a new row, the Excel spreadsheel moves to the next cell below it, which I don't want...Im not sure if I can explain it any better than that, my apologies for the confusion...

Anyways, I've managed to sort of figure it out so that I can type the two rows of data into MS Word, then cut and paste them into Excel, but that's going to get a bit tedious...any better suggestions are still appreciated...

Greg
Chief A.net college football stadium self-pic guru
 
Wayfarer
Posts: 252
Joined: Wed Jun 29, 2005 11:32 pm

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 5:42 am

keep trying ... practice helps ...  wink 
EASTERN AIRLINES: We Are Still Here Today
 
greasespot
Posts: 2955
Joined: Sat Apr 24, 2004 10:48 am

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 5:44 am

Right click on mouse in Cell...click on format cells. Check off Wrap text in alignment tab...then type away. When you are all done you may need to re-size the cells. That is the only way to get more than one line of text in excel. Do not hit enter until you are done as then you move to next cell. NO way arround this..

GS

Note: this can be done in multile cells at once by high-lighting the cells you want to wrap txt and then going through the above exercise.
Sometimes all you can do is look them in the eye and ask " how much did your mom drink when she was pregnant with you?"
 
diamond
Posts: 3000
Joined: Sun Apr 11, 2004 8:01 am

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 5:48 am

Greg,

1. Select all of the cells in which you want the double-row feature to work (you can select the entire spreadsheet if you want).

2. With the cells highlighted, select the following menu commands:

FORMAT / CELLS / ALIGNMENT

3. Find "text control" on the popup menu and CHECK the box that is labeled "WRAP TEXT".

4. Highlight the ROWS in which you want the wrapped-text cells to expand.

5. Move your cursor in-between any two rows of the highlighted rows.

6. Double-click.


At this point, the row height should automatically adjust and become twice as tall for the rows where you have double-height cells.



P.S. If you want the line-break to happen at a certain word, press CTRL-Enter at the beginning of that word.

[Edited 2005-07-02 22:50:46]

[Edited 2005-07-02 22:52:43]
Blank.
 
USAFHummer
Topic Author
Posts: 10261
Joined: Thu May 18, 2000 12:22 pm

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 6:26 am

Thanks so much...I'll try that out in a bit!

Greg
Chief A.net college football stadium self-pic guru
 
sccutler
Posts: 5567
Joined: Thu Jan 27, 2000 12:16 pm

RE: Microsoft Excel Help, Please!

Sun Jul 03, 2005 7:23 am

Even better, stop using MS software and upgrade to Quattro Pro / WordPerfect.
...three miles from BRONS, clear for the ILS one five approach...

Who is online

Users browsing this forum: pu and 11 guests