Column widths

L

Linda Gearhart

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?
 
G

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
 
R

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

Linda Gearhart said:
I'm tying to create a form. Can there be different column widths at the
Click to expand...
top of the worksheet, and then another width at the bottom?
 
Top