| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Combine 2 columns to make one column without merging | Excel Discussion (Misc queries) | |||
| How can I make a range "dynamic"? | Excel Worksheet Functions | |||
| How do I make some columns all caps and others proper? | Excel Discussion (Misc queries) | |||
| how can i find total width of the columns in a printing area ? | Excel Discussion (Misc queries) | |||
| Field , Date range and Sum from worksheet import | New Users to Excel | |||
Threaded Mode
