varying column width by row

[Guest]

Can I make the column widths in one row different from the other rows?

 

[Chip Pearson]

No, the column width applies to all rows in the column. You could
merge cells, but merged cells cause a lot of problems with
copy/paste and sort.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[Guest]

Oh Blast!
Thanks for the info.
Tammie

No, the column width applies to all rows in the column. You could
merge cells, but merged cells cause a lot of problems with
copy/paste and sort.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message

 

[RagDyeR]

You could however give an appearance of differing column widths by
selecting, say B10 and C10, and then:
<Format> <Cells> <Alignment> tab,
Expand the 'Horizontal' box and click on,
"Center Across Selection"

Then, you could judiciously place borders around your cells to create the
desired display.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Oh Blast!
Thanks for the info.
Tammie