Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Ctrl+V pasting to multiple non-adjacent cells
Maybe I'm regressing, but I find that more and more I prefer using the
keyboard rather than the mouse. I love to Ctrl + C copy, but I can't figure out how to CNTRL + V paste that copy to multiple non-adjacent cells. If I were using my mouse, I would click on one the target paste cells while holding down the Ctrl key and the repeat the procedure for other cells. Anyone know the trick? Thanks for your time to whomever responds. Sam |
#2
|
|||
|
|||
Hi,
You can use Ctrl+v to paste in multiple non-adjacent cells.To do that go to the first location, press ctrl+v and then go to the next location and press ctrl+v again. When you do a ctrl+v, the copy in the clipboard doesn't go away and hence you can keep using it any number of times. However if you press Enter instead of doing Ctrl+v, you won't be able to paste multiple times since the clipboard copy is erased in this case. Regards Govind. -----Original Message----- Maybe I'm regressing, but I find that more and more I prefer using the keyboard rather than the mouse. I love to Ctrl + C copy, but I can't figure out how to CNTRL + V paste that copy to multiple non-adjacent cells. If I were using my mouse, I would click on one the target paste cells while holding down the Ctrl key and the repeat the procedure for other cells. Anyone know the trick? Thanks for your time to whomever responds. Sam . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
background formatting across multiple cells | Excel Discussion (Misc queries) |