Shopping Cart

Copy and Paste with Column Widths

Where would we be without Copy and Paste? Probably way behind schedule, or should I say, further behind schedule than we are currently! ?

In Excel, Copy and Paste copies everything by default… except column widths! This can be a little frustrating especially if that is one of the key things you require to copy.

There is a simple solution. Once pasted, click on the paste options and select “Keep source column width”. Even quicker is to use the Keyboard Shortcuts of ctrl and then W.

If you’d like to learn Excel on a deeper level, be sure to check out our online courses, ideal for both beginners as well as those wanting to further upskill their Excel knowledge.

Want to learn more?

Receive our Excel tips and news to your inbox!

"*" indicates required fields

Choices*
This field is for validation purposes and should be left unchanged.

Request a Consultation

MS Excel Advanced Course

R 1,750

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 750

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks