Is there an easy way to set column widths...or do I have to change each
column separately? Want a worksheet with Col A = 10, Col B = 2, Col C = 10,
Col D = 2, etc.
Select column A, then control-click on B, C, ...
Adjust the columnwidth to 10
Then select column B, ctrl-click on D, ...
and adjust the columnwidth to 2.
jmeg wrote:
gt;
gt; Is there an easy way to set column widths...or do I have to change each
gt; column separately? Want a worksheet with Col A = 10, Col B = 2, Col C = 10,
gt; Col D = 2, etc.
--
Dave Peterson
Set column A to 10, then column B to 2. Then drag mouse over A amp; B Right
mouse Copy, Then highlight all other columns you wish to modify, Right mouse
Click, Paste Special, Column widht. VOILA!
HTH
Gilles
quot;jmegquot; gt; wrote in message
news
gt; Is there an easy way to set column widths...or do I have to change each
gt; column separately? Want a worksheet with Col A = 10, Col B = 2, Col C =
gt; 10,
gt; Col D = 2, etc.
column separately? Want a worksheet with Col A = 10, Col B = 2, Col C = 10,
Col D = 2, etc.
Select column A, then control-click on B, C, ...
Adjust the columnwidth to 10
Then select column B, ctrl-click on D, ...
and adjust the columnwidth to 2.
jmeg wrote:
gt;
gt; Is there an easy way to set column widths...or do I have to change each
gt; column separately? Want a worksheet with Col A = 10, Col B = 2, Col C = 10,
gt; Col D = 2, etc.
--
Dave Peterson
Set column A to 10, then column B to 2. Then drag mouse over A amp; B Right
mouse Copy, Then highlight all other columns you wish to modify, Right mouse
Click, Paste Special, Column widht. VOILA!
HTH
Gilles
quot;jmegquot; gt; wrote in message
news
gt; Is there an easy way to set column widths...or do I have to change each
gt; column separately? Want a worksheet with Col A = 10, Col B = 2, Col C =
gt; 10,
gt; Col D = 2, etc.
文章標籤
全站熱搜
