Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
setting a different size header column and then smaller sub colum.
Hi,
I would like to know how to set up a workshhet using a large header column above and then below it maybe 3 smaller sized columns. What I mean is set it up this way. Header Column would be e.g. TITLE (approx 30 wide) Below it 3 columns like this: name name name (all Aprox 8 wide) Any help on this would be very much appreciated and I hope I don't sound to confusing with what I want to do. Thanksa |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
setting a different size header column and then smaller sub colum.
All cells in any individual column must be the same width, but you can make
one appear to be wider in one of 2 ways: Select the cell with the word TITLE in it and also one or two cells to the right of it and use: Format -- Cells -- Alignment and in the "Horizontal" section choose "Center across selection". Another way is to select a group of cells (2 or 3 on the row in this case) and use the "Merge" cells feature to treat them as one large cell with the text initially centered in it. You can change the alignment of the text to left, right or centered using the regular alignment icons if you want to. "Sudhir" wrote: Hi, I would like to know how to set up a workshhet using a large header column above and then below it maybe 3 smaller sized columns. What I mean is set it up this way. Header Column would be e.g. TITLE (approx 30 wide) Below it 3 columns like this: name name name (all Aprox 8 wide) Any help on this would be very much appreciated and I hope I don't sound to confusing with what I want to do. Thanksa |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
setting a different size header column and then smaller sub colum.
JLatham wrote:
All cells in any individual column must be the same width, but you can make one appear to be wider in one of 2 ways: Select the cell with the word TITLE in it and also one or two cells to the right of it and use: Format -- Cells -- Alignment and in the "Horizontal" section choose "Center across selection". Another way is to select a group of cells (2 or 3 on the row in this case) and use the "Merge" cells feature to treat them as one large cell with the text initially centered in it. You can change the alignment of the text to left, right or centered using the regular alignment icons if you want to. "Sudhir" wrote: Hi, I would like to know how to set up a workshhet using a large header column above and then below it maybe 3 smaller sized columns. What I mean is set it up this way. Header Column would be e.g. TITLE (approx 30 wide) Below it 3 columns like this: name name name (all Aprox 8 wide) Any help on this would be very much appreciated and I hope I don't sound to confusing with what I want to do. Thanksa one way would be to use the merge and center feature. Check help under merge. gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
How do I size a worksheet ? ( make smaller ) | Excel Discussion (Misc queries) | |||
Font size smaller and bigger in a formula | Excel Worksheet Functions | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
How do I break a csv file into smaller size for export? | New Users to Excel |