Excel Tip – Copy & Paste and keep Column Widths


To copy a Range of Data to a new sheet, without having to resize all the Column Widths to how you had it in the original, use Paste Special > Column Widths.

There are 2 ways to do this.

Option 1: First Copy, then right click to get your Pop-up Menu. Hover over the Paste Special arrow (>) and click on the Column Widths icon.

Option 2: First do a Normal Copy (ctrl + C) and Paste (Ctrl + V). Then Paste the Column Widths over the top using the Paste Special Dialogue Box. (Ctrl + alt + V, W – to select column Widths and then press enter to select OK). This is a 2-step process but enables you to do it using Keyboard Shortcuts.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Archive
Search By Tags

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions