How do I make all columns in a range in a worksheet the same width

R

Robin

In a spreadsheet with 20 columns of different widths I want to be able to
make all the columns the same width without doing so by manually adjusting
each one. Can anyone tell me how?
 
G

Guest

Hi

Click on the square to the left of column A - which will select all columns
and rows - and adjust one column to the width you want. The rest will
follow!

Andy.
 
R

Ron Coderre

Try something like this:

Left-Click and hold on the first column label (gray area at the top of the
column)
Drag across to the right to select all 20 columns
Release the mouse
Left-Click and hold on any separator between columns
Drage right or left to adjust column width.
When you release....all 20 columns will have the same width

Note: you can apply the same technique to non-contiguous columns by holding
down the [Ctrl] key while you select each column. Then adjust the width of
one to set all selected.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
B

Beege

Robin,

Select All columns that need adjustment
(this works if adjacent)
Right click in the column indicators, select "column width", adust number to
suit

Beege
 
R

Robin

Thank you so much!!

Andy said:
Hi

Click on the square to the left of column A - which will select all columns
and rows - and adjust one column to the width you want. The rest will
follow!

Andy.
Click to expand...
 
R

Robin

Thank you!

Beege said:
Robin,

Select All columns that need adjustment
(this works if adjacent)
Right click in the column indicators, select "column width", adust number to
suit

Beege
Click to expand...
 
R

Robin

Wonderful, thank you very much!!

Ron Coderre said:
Try something like this:

Left-Click and hold on the first column label (gray area at the top of the
column)
Drag across to the right to select all 20 columns
Release the mouse
Left-Click and hold on any separator between columns
Drage right or left to adjust column width.
When you release....all 20 columns will have the same width

Note: you can apply the same technique to non-contiguous columns by holding
down the [Ctrl] key while you select each column. Then adjust the width of
one to set all selected.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


Robin said:
In a spreadsheet with 20 columns of different widths I want to be able to
make all the columns the same width without doing so by manually adjusting
each one. Can anyone tell me how?
Click to expand...
Click to expand...
 
Top