I want to make three sub colums under an original colum
 

can anyone explain how I do this

I have a headed colum and half way down this colum I need to insert 3 sets
of data
hence the sub clolums

Dottie

The width of a column is the property of the column and remains the same
throughout the column.

One way to do what you want is to enter your title in A1 then select A1:C1 and
FormatCellsAligmentHorizontalCenter Across Selection.

You can also "merge" A1:C1 but I do not recommend this method. Merged cells
cause no end of problems with sorting, copying. pasting, filtering and others.


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 09:22:06 -0700, dottiem22
wrote:

can anyone explain how I do this

I have a headed colum and half way down this colum I need to insert 3 sets
of data
hence the sub clolums

Use column B for the 1st half of the data.
Use columns A,B and C for the 2nd half of the data.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"dottiem22" wrote:

can anyone explain how I do this

I have a headed colum and half way down this colum I need to insert 3 sets
of data
hence the sub clolums