Copy and paste a range in Excel and you get everything except the column widths. They get left behind and sometimes that’s a big nuisance. When you need to paste column widths too, paste your cells and don’t move. Choose Edit, Paste Special and click Column widths and the column widths of the new cells adjust to match the source.

Easy when you know how…

Related posts:

  1. Random numbers in Excel
  2. Automatic Excel cell entries
  3. Excel – finding duplicates
  4. Error Checking in Excel
  5. Widening chart columns in Excel 2007