How do I make all columns in a range in a worksheet the same w
Wonderful, thank you very much!!
"Ron Coderre" wrote:
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" wrote:
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?
|