close

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

quot;Duke Careyquot; wrote:

gt; A single column cannot have different widths in different parts of the
gt; spreadsheet, absent using merged cells which is something many of us loathe.
gt;
gt; If you need to do this for presentation purposes, you can set up the bottom
gt; portion of your presentation on another worksheet or to the right of your top
gt; section and set the column widths there to whatever you need. Format this
gt; section just the way you want, then select that range, hold down the Shift
gt; key and click on the Edit menu. Choose 'Copy picture..' Now navigate the
gt; area below your top section, hold the Shift key down and choose Edit-gt;Paste
gt; Picture Link
gt;
gt;
gt; quot;Holyhabaneroquot; wrote:
gt;
gt; gt; One more question. I have a worksheet with two different sections on it, one
gt; gt; on top of the other. The top section needs to have wider columns, while the
gt; gt; one below it needs to have skinny columns. Short of putting these two
gt; gt; sections onf different worksheets, is there a way to have different sized
gt; gt; columns in the same worksheet?
gt; gt;
gt; gt; To get a better idea of what I mean, see this image he
gt; gt; 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-gt;Paste
Picture Linkquot;Holyhabaneroquot; wrote:

gt; One more question. I have a worksheet with two different sections on it, one
gt; on top of the other. The top section needs to have wider columns, while the
gt; one below it needs to have skinny columns. Short of putting these two
gt; sections onf different worksheets, is there a way to have different sized
gt; columns in the same worksheet?
gt;
gt; To get a better idea of what I mean, see this image he
gt; i14.photobucket.com/albums/a3...o/prod_rpt.jpg

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()