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