Can you set Individual Cell Widths ??

[tmb]

Can you set individual Cell Witdhs? Like...

A1 = 2 inches wide
A2 = 1 inch wide
A3 = 3 inches wide

etc?

thanks for any help.

 

[Niek Otten]

No. You can set the width of a column.
In addition to that, you can split windows and you can merge cells. Both
will cause you trouble one way or another (in trying to achieve what you
require).
But you can give it a try, of course.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[David McRitchie]

Hi tmb,
Don't know what Niek meant by splitting windows, if I create a
new window any change to a column width is shown in the
other view as well if for the same worksheet.

He probably meant you can "split" columns by inserting a
new column and then merge the ones that you don't want
"split". You then have two columns but some cells are
merged. In Microsoft Word you can actually split cells.
But as Niek indicated merged cells can cause problems
when sorting and with automatic height adjustments of rows.

Another possibility is the use of a graphic on top of the
worksheet such as a picture, or of a textbox. You would
have to move them where you want, and you can align
them with a cell boundary. They would simply obscure
what they are on top of. Textbox is found in the Drawing
toolbar.

 

[Niek Otten]

Yes, I made a mistake there! Thanks, David!


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel