HELP!!!! I need help with EXCEL.....

[OzAurora]

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........

 

[HelloAngel]

Aren't you able to just click on the Column in question and drag? that's what I've always done....

 

[ABEL]

just make sure you have only column B highlighted when you resize it? other than that i'm not sure...

 

[Liesje]

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]

If you're really stuck, I can do it for you. It's kind of hard to explain without showing you how.

 

[jesseu2]

exactly what Livluv said about merging cells.

 

[Salome]

indeedly


excel

 

[OzAurora]

thankyou so much liv luv- you have helped me heaps.......