Tame your computer - duplicate your data


In her weekly series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes a way to quickly duplicate data from the previous row (Microsoft Excel*) ...

Full credit for today's tip to Donna and Gill (Thanks, guys!) During a recent Microsoft Access course I told them about the tip to quickly copy the data from the previous record using [CTRL] + ['] (apostrophe).

"Aha", they said. "A bit like [CTRL] + [D] in Excel".

Here's how:

1. Click on the cell or row heading to select the entry you want to copy.
2. Press CTRL+D. (For duplicate; so you can remember! ;-)

If you want to copy row one in all 65536 rows (why? ;-) simply click on the Select All button in the upper-left corner of the worksheet frame and  press CTRL+D.

* Unless stated otherwise, these tips were written for Microsoft Office 2003.
Most of what is covered however will also apply to earlier versions.

23 July 2007

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 http://www.roem.co.uk


Karen Roem
Microsoft Office-ionado

Roem Ltd – software training and support