One more question. I have a worksheet with two different sections on it, one
on top of the other. The top section needs to have wider columns, while the
one below it needs to have skinny columns. Short of putting these two
sections onf different worksheets, is there a way to have different sized
columns in the same worksheet?

To get a better idea of what I mean, see this image he
http://i14.photobucket.com/albums/a3...o/prod_rpt.jpg

That's sort of what I suspected. Thanks for the advice. I'll give it a try.

"Duke Carey" wrote:

A single column cannot have different widths in different parts of the
spreadsheet, absent using merged cells which is something many of us loathe.

If you need to do this for presentation purposes, you can set up the bottom
portion of your presentation on another worksheet or to the right of your top
section and set the column widths there to whatever you need. Format this
section just the way you want, then select that range, hold down the Shift
key and click on the Edit menu. Choose 'Copy picture..' Now navigate the
area below your top section, hold the Shift key down and choose Edit-Paste
Picture Link


"Holyhabanero" wrote:

One more question. I have a worksheet with two different sections on it, one
on top of the other. The top section needs to have wider columns, while the
one below it needs to have skinny columns. Short of putting these two
sections onf different worksheets, is there a way to have different sized
columns in the same worksheet?

To get a better idea of what I mean, see this image he
http://i14.photobucket.com/albums/a3...o/prod_rpt.jpg

A single column cannot have different widths in different parts of the
spreadsheet, absent using merged cells which is something many of us loathe.

If you need to do this for presentation purposes, you can set up the bottom
portion of your presentation on another worksheet or to the right of your top
section and set the column widths there to whatever you need. Format this
section just the way you want, then select that range, hold down the Shift
key and click on the Edit menu. Choose 'Copy picture..' Now navigate the
area below your top section, hold the Shift key down and choose Edit-Paste
Picture Link


"Holyhabanero" wrote:

One more question. I have a worksheet with two different sections on it, one
on top of the other. The top section needs to have wider columns, while the
one below it needs to have skinny columns. Short of putting these two
sections onf different worksheets, is there a way to have different sized
columns in the same worksheet?

To get a better idea of what I mean, see this image he
http://i14.photobucket.com/albums/a3...o/prod_rpt.jpg