Wednesday, September 26, 2012

Apply auto-fit property to multiple columns simultaneously


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:
  1. Select the columns in question—columns A through E using the example sheet above. (Just drag across the column headers to select multiple columns.)
  2. Hover the mouse pointer over the right-border of any of the selected columns until the double-headed arrow appears..
  3. 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