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
- Dec 18 Mon 2006 20:34
Different column widths
close
全站熱搜
留言列表
發表留言