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.