Tame your computer - paste perfect

In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to keep the column width when pasting (Microsoft Excel*)...

 

When you copy and paste data from one spot to the other in Excel you sometimes end up with the column width being all over the place. Perhaps you only see hash marks instead of the cell contents? You probably know how to adjust the column width, but did you know it is very easy to keep the same measurements when you paste?
 
Here’s how:

  1. Copy and paste the data, as normal. (CTRL + C and CTRL + V, I hope ;)
  2. Press CTRL to open the Paste Options button (or click on it, if you must ;)
  3. Press W to select the Keep Source Column Widths option or use the arrows on your keyboard to flick through the various paste options.

There are obviously other ways to do this, but I like to encourage you to explore faster ways of doing your day-to-day tasks and break free from old habits developed in previous versions of Microsoft Office.

By the way, if you do only see hash marks instead of the cell contents, as mentioned in the first paragraph, it means the column is too narrow to display its content. Simply, hover your mouse pointer to the right of the column heading you want to resize and double-click when it becomes a double-headed arrow.

* Unless stated otherwise, these tips were written for Microsoft Office 2010.

9 November 2015


Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email ( Karen@roem.co.uk) or visit her website at www.roem.co.uk

Please note: Cambridge Network's Learning Collaboration members have the opportunity to book places on Roem Ltd courses at a reduced rate.



Looking for something specific?