http://www.techrepublic.com/blog/msoffice/apply-auto-fit-property-to-multiple-columns-simultaneously/3892
What you might not know is that you can adjust the width of multiple columns at the same time by selecting a block of columns first. Here’s how:
- Select the columns in question—columns A through E using the example sheet above. (Just drag across the column headers to select multiple columns.)
- Hover the mouse pointer over the right-border of any of the selected columns until the double-headed arrow appears..
- Double-click a column header border.
I think I tended to go with Excel managing row heights but true, the same process works for fitting height and width.
No comments:
Post a Comment