close

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.

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

software

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