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: 53
Posted (9 years 4 weeks 1 day 17 hours ago) and read 1197 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 4 weeks 1 day 17 hours ago) and read 1193 times:

I'm guessing you need to insert another row.

User currently offlineUSAFHummer From United States of America, joined May 2000, 10685 posts, RR: 53
Reply 2, posted (9 years 4 weeks 1 day 17 hours ago) and read 1186 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: 53
Reply 3, posted (9 years 4 weeks 1 day 16 hours ago) and read 1178 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 4 weeks 1 day 16 hours ago) and read 1180 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: 53
Reply 5, posted (9 years 4 weeks 1 day 16 hours ago) and read 1168 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 4 weeks 1 day 16 hours ago) and read 1165 times:

keep trying ... practice helps ...  wink 

User currently offlineGreasespot From Canada, joined Apr 2004, 3078 posts, RR: 20
Reply 7, posted (9 years 4 weeks 1 day 16 hours ago) and read 1164 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 4 weeks 1 day 16 hours ago) and read 1169 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: 53
Reply 9, posted (9 years 4 weeks 1 day 15 hours ago) and read 1149 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, 5491 posts, RR: 28
Reply 10, posted (9 years 4 weeks 1 day 14 hours ago) and read 1146 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