HELP!!!! I need help with EXCEL..... - U2 Feedback

Go Back   U2 Feedback > Lypton Village > Lemonade Stand > Lemonade Stand Archive
Click Here to Login
 
 
Thread Tools Search this Thread Display Modes
 
Old 04-12-2004, 09:36 PM   #1
Refugee
 
OzAurora's Avatar
 
Join Date: Nov 2000
Location: The Sunshine Coast, Queensland, Australia
Posts: 1,612
Local Time: 02:59 AM
crys HELP!!!! I need help with EXCEL.....

Howdy all, I am going mental trying to find this out, I cant find it on the excel help and I am not having any luck on the net, so hopefully someone here can help me, this is what I am trying to do....

I am doing up a table in excel and I need to be able to adjust the width of multiple columns.........so lets say the title in Row A takes up 1 cell, however I want the data that I enter into Row B to only take up half a cell, but when I go to resize the column it makes the entire column smaller and I dont want Row A to be smaller, so how do I do this??????? please help........
__________________

__________________
OzAurora is offline  
Old 04-12-2004, 10:31 PM   #2
ONE
love, blood, life
 
HelloAngel's Avatar
 
Join Date: Sep 2001
Location: new york city
Posts: 14,534
Local Time: 11:59 AM
Aren't you able to just click on the Column in question and drag? that's what I've always done....
__________________

__________________
HelloAngel is offline  
Old 04-13-2004, 12:27 AM   #3
An Angel In Devil's Shoes
 
ABEL's Avatar
 
Join Date: Jan 2001
Location: Netherlands
Posts: 18,844
Local Time: 09:59 AM
just make sure you have only column B highlighted when you resize it? other than that i'm not sure...
__________________
ABEL is offline  
Old 04-13-2004, 12:32 AM   #4
Blue Crack Addict
 
Liesje's Avatar
 
Join Date: Mar 2002
Location: In the dog house
Posts: 19,557
Local Time: 10:59 AM
If I were at work and you called/e-mailed, I'd say "send me the document as an attachment and I'll see what I can do..."

Anyway....here's what (I think) you're getting at. Say you time into the first cell "this is a long sentence in this cell blah blah blah" and then right under it you type "short haha". If you re-size the column to fit all of the first sentance, it looks huge with the short one. If you resize it to fit the short one, the long one is cut off.

I think you want to merge the cells of the longer data entries. Like, when you type the longer sentance, it runs into columns B, C, etc. Highlight the whole thing, right click, Properties, Alignment, Merge Cells. Here's a visual:



__________________
Liesje is offline  
Old 04-13-2004, 12:33 AM   #5
Blue Crack Addict
 
Liesje's Avatar
 
Join Date: Mar 2002
Location: In the dog house
Posts: 19,557
Local Time: 10:59 AM
If you're really stuck, I can do it for you. It's kind of hard to explain without showing you how.
__________________
Liesje is offline  
Old 04-13-2004, 03:45 AM   #6
Refugee
 
jesseu2's Avatar
 
Join Date: Jan 2001
Location: Washington D.C.
Posts: 1,984
Local Time: 11:59 AM
exactly what Livluv said about merging cells.
__________________
jesseu2 is offline  
Old 04-13-2004, 03:55 AM   #7
you are what you is
 
Salome's Avatar
 
Join Date: Jul 2000
Location: Netherlands
Posts: 22,016
Local Time: 04:59 PM
indeedly


excel
__________________
“Some scientists claim that hydrogen, because it is so plentiful, is the basic building block of the universe. I dispute that. I say there is more stupidity than hydrogen, and that is the basic building block of the universe.”
~Frank Zappa
Salome is online now  
Old 04-13-2004, 04:20 AM   #8
Refugee
 
OzAurora's Avatar
 
Join Date: Nov 2000
Location: The Sunshine Coast, Queensland, Australia
Posts: 1,612
Local Time: 02:59 AM
thankyou so much liv luv- you have helped me heaps.......

__________________

__________________
OzAurora is offline  
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 10:59 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Design, images and all things inclusive copyright © Interference.com