There are a number of ways to copy data in Excel, but if you're like me, you're always looking for shortcuts that eliminate a few clicks. Here's one that's handy when copying a single column of values to an adjacent column:
- Select the column and the adjacent column. If the column of values is already selected, you can press [Ctrl]+[Shift]+[Right Arrow] to extend the selection.
- With both columns highlighted, press [Ctrl]+[Shift]+. (that's the period character).
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.