Thursday, February 17, 2011

Copy single column of values to an adjacent column- Excel 2007

We all know how to copy data in Excel, in fact there are many different ways to do it. In an effort to work smarter, not harder- copy data and eliminate a few clicks of the mouse by using the keyboard instead. 

1.  Select the column of data to be copied and the adjacent column. 












2.  Press Ctrl + Shift + . (period character), insuring both columns are highlighted prior.













Note: this trick also works with rows--> Press Ctrl + Shift + , (comma character)

No comments:

Post a Comment