Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setup wrksht w/ column widths of 10 then 2 then 10 then 2 etc
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
setup wrksht w/ column widths of 10 then 2 then 10 then 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: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
setup wrksht w/ column widths of 10 then 2 then 10 then 2 etc
Set column A to 10, then column B to 2. Then drag mouse over A & B Right
mouse Copy, Then highlight all other columns you wish to modify, Right mouse Click, Paste Special, Column widht. VOILA! HTH Gilles "jmeg" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Varying Column Widths for Text Import | Excel Discussion (Misc queries) | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |