Sponsor Message:
Non Aviation Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Microsoft Excel Help, Please!  
User currently offlineUSAFHummer From United States of America, joined May 2000, 10685 posts, RR: 52
Posted (9 years 5 months 3 weeks 1 day 10 hours ago) and read 1283 times:

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
10 replies: All unread, jump to last
 
User currently offlineTedTAce From , joined Dec 1969, posts, RR:
Reply 1, posted (9 years 5 months 3 weeks 1 day 10 hours ago) and read 1279 times:

I'm guessing you need to insert another row.

User currently offlineUSAFHummer From United States of America, joined May 2000, 10685 posts, RR: 52
Reply 2, posted (9 years 5 months 3 weeks 1 day 10 hours ago) and read 1272 times:

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
User currently offlineUSAFHummer From United States of America, joined May 2000, 10685 posts, RR: 52
Reply 3, posted (9 years 5 months 3 weeks 1 day 9 hours ago) and read 1264 times:

http://img.photobucket.com/albums/v300/BuffsandEagles/anetexcel.jpg


Chief A.net college football stadium self-pic guru
User currently offlineAak777 From Qatar, joined Apr 2001, 284 posts, RR: 0
Reply 4, posted (9 years 5 months 3 weeks 1 day 9 hours ago) and read 1266 times:

I am not sure that I understand your problem but did you try merging and dividing the cells.

User currently offlineUSAFHummer From United States of America, joined May 2000, 10685 posts, RR: 52
Reply 5, posted (9 years 5 months 3 weeks 1 day 9 hours ago) and read 1254 times:

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
User currently offlineWayfarer From , joined Dec 1969, posts, RR:
Reply 6, posted (9 years 5 months 3 weeks 1 day 9 hours ago) and read 1251 times:

keep trying ... practice helps ...  wink 

User currently offlineGreasespot From Canada, joined Apr 2004, 3086 posts, RR: 20
Reply 7, posted (9 years 5 months 3 weeks 1 day 9 hours ago) and read 1250 times:

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?"
User currently offlineDiamond From United States of America, joined Apr 2004, 3279 posts, RR: 63
Reply 8, posted (9 years 5 months 3 weeks 1 day 8 hours ago) and read 1255 times:

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.
User currently offlineUSAFHummer From United States of America, joined May 2000, 10685 posts, RR: 52
Reply 9, posted (9 years 5 months 3 weeks 1 day 8 hours ago) and read 1235 times:

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

Greg



Chief A.net college football stadium self-pic guru
User currently offlineSccutler From United States of America, joined Jan 2000, 5615 posts, RR: 28
Reply 10, posted (9 years 5 months 3 weeks 1 day 7 hours ago) and read 1232 times:

Even better, stop using MS software and upgrade to Quattro Pro / WordPerfect.


...three miles from BRONS, clear for the ILS one five approach...
Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
Microsoft Excel Help, Please! posted Mon Feb 21 2005 05:15:32 by USAFHummer
Microsoft Word Help! Please! posted Fri Nov 18 2005 02:24:21 by Pdxtriple7
Microsoft Outlook Problems—Help Please! posted Mon Oct 30 2006 04:35:02 by RJpieces
German Poster Help, Please posted Fri Nov 10 2006 05:12:07 by Alitalia777
ITunes/iPod Help Please posted Fri Nov 3 2006 20:47:31 by Demoose
ITunes Artwork Help Please posted Wed Oct 4 2006 23:14:02 by DeltaGator
Liquid Vol/weight Calculation Help, Please posted Mon Sep 25 2006 15:03:49 by Cptkrell
Computer Help, Please posted Sat Sep 23 2006 17:21:40 by FSPilot747
Help Please: Slow Loading XP PRO Settings posted Wed Jul 5 2006 17:27:01 by SA7700
Virus Problem (autsie.dll) - Help Please! posted Mon Jun 19 2006 05:23:29 by Misbeehavin