Column widths

[Guest]

I'm tying to create a form. Can there be different column widths at the top of the worksheet, and then another width at the bottom?

 

[~Alan]

you will need to merge columns

a|b|c|d|e
|merge|
| | | |

 

[Gord Dibben]

Linda

The column width property is for the entire column, top to bottom, and cannot
be changed.

You could experiment with Format>Cells>Alignment>Horizontal and choose "center
across columns".

Another method, which I hesitate to mention, is "Merged Cells".

The hesitation comes from the problems that merged cells cause when trying to
copy, paste, sort and filter.

Gord Dibben Excel MVP

 

[Ragdyer]

I would definitely agree with Gord and recommend *against* using merged
cells.

Here's an old post with pointers on creating forms and reports that might
help:

http://tinyurl.com/3btek

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

I'm tying to create a form. Can there be different column widths at the

top of the worksheet, and then another width at the bottom?