Can you set Individual Cell Widths ??

Can you set individual Cell Witdhs? Like...

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

etc?

thanks for any help.

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

"tmb" <[email protected]> wrote in message
news:[email protected]...
> Can you set individual Cell Witdhs? Like...
>
> A1 = 2 inches wide
> A2 = 1 inch wide
> A3 = 3 inches wide
>
> etc?
>
> thanks for any help.
>
>
>

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Niek Otten" <[email protected]> wrote in message news:%[email protected]...
> 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
>
> "tmb" <[email protected]> wrote in message
> news:[email protected]...
> > Can you set individual Cell Witdhs? Like...
> >
> > A1 = 2 inches wide
> > A2 = 1 inch wide
> > A3 = 3 inches wide
> >
> > etc?
> >
> > thanks for any help.
> >
> >
> >
>
>

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


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"David McRitchie" <[email protected]> wrote in message
news:%[email protected]...
> 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.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Niek Otten" <[email protected]> wrote in message
> news:%[email protected]...
>> 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
>>
>> "tmb" <[email protected]> wrote in message
>> news:[email protected]...
>> > Can you set individual Cell Witdhs? Like...
>> >
>> > A1 = 2 inches wide
>> > A2 = 1 inch wide
>> > A3 = 3 inches wide
>> >
>> > etc?
>> >
>> > thanks for any help.
>> >
>> >
>> >
>>
>>
>
>