Copy Paste functionality

Hi, was wondering is it possible to have this functionality for copy and paste:



If you copy 1 cell, then paste it into multiple cells, the value is repeated for each cell.



If you copy N cells, and paste it into N cells, the exact values are copied.



It would be a useful feature if a user just wanted to fill up a row or column of data with a single value.



Thanks