There is a problem with normal copy-paste that you can only use a single value at a time.
But here is the kicker: When you copy a value, it goes to the clipboard and if you open the clipboard you can paste all the values which you have copied. To open a clipboard, click on the go to Home Tab ➜ Editing and then click on the down arrow.
![excel tips tricks click board open from home tab](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/images/optimized/rev-a53ee6c/wp-content/uploads/2018/01/7-excel-tips-tricks-click-board-open-from-home-tab.png)
It will open the clipboard on the left side, and you can paste values from there.
No comments:
Post a Comment