Excel and height of columns

Hi all,

I have what is probably a relatively simple Excel question. I am making a table and need a different height for each column than what is set as default (I need 30 - 50 pixels).

Is ther a way to set this?
Also, I manually changed a whole sheet, then did c&p of the table, but it re-changed the columns back to the standard size and didn't keep the size I'd changed it to! Any clue how to keep the source formatting?

Thanks!

Height of columns?? Dont columns have widths and rows have heights?

I think UA means cell height ?

maybe you mean merging the cells?
you can select a batch of cells and merge them, and get different heights in different columns that way

what about here "conditional formatting" and writing your rules for the cells. you can add for quite a few.

perhaps if you post a screen capture we can understand better what you want to do.

I'm trying to upload a Snag It picture of what I mean but it doesn't work (wrong type of file).

I think I mean cell height. I don't understand the conditional formatting thing Nor can I find 'merge cells'. Isn't merging something where you want to combine 2 lots of information though? (I know it from Word).

I can't post a piccie but you've got a little icon with

<-a->

on it

that merges a batch of cells and centers the text (but you can switch it back to left-aligned if you want)
it works with horizontal and vertical merging

I highlighted the text I wanted to C&P, clicked on the <a> but it took away all of the individual cells and made it into 1 and deleted all the text :S I'll just do it manually.

soz, i thought that's what you wanted them to do
looks like i haven't really understood what you were after

I'll try again The cell heights are stuck at a default height of 15 (25 pixels). I want this to be double the height without having to manually change every single one, as I need 100 or so rows. I've done 65 manually now but am getting tired of it, plus a headache

this may help.


If you want what the second example shows, you can merge cells by: first selecting the group of joining cells you want to merge, hit CRTL-1 keys, in tab Alignment check box Merge hit ok - then pay bill gates 5 cents.

without merging cells, the height of all cells in a row must be the same (as in the first example).

it also sounds like you are having trouble with the copy paste between worksheets. in this case, it may be best to select the ENTIRE worksheet for copy. do this by clicking that little grey waste-of-space box where the column letters (A, B, C ...) meets the row numbers (1, 2, 3...) in the upper left of the speadsheet. then copy and paste to the new - formating should carry across. for this privelidge, be sure to pay bill gates 15 cents.

When you copy and paste you may want to try the Paste Special function where you also paste the format.

Thus:
Edit
Paste Special
Formats

Are you copying from one sheet to another sheet? Let us know if this works.

It's example 1 where I want all of the rows to be as 'high' as row 3 in your example, all the same height.

I'm not switching between different worksheets though, it's the same sheet.

in that case, simply select cells A1:A100, click menu Format -> Row -> Height, in the pop-up box, type the desired row height then OK. sorted, yea?

@Mork - that didn't work either, but paste special sounds about right. When I did your suggestion it deleted all the text and the cells remained the same height as default, they didn't change.
*growls at Excel*

Try selecting the whole row you want to copy and before pasting, select the rows in which you want to paste.

Hoorah! Thanks Chicago, that's exactly what I wanted. Thanks everyone for your help.

in that case you're basically f**ked. the new Microsoft apps have some problems in this area (in my experience / opinion).

or, you may want to try menu Edit -> Paste Special, in the pop-up box select "Format" and/or "All".

Chicago - no worries, your last suggestion worked using 'format'.