The fill handle method works for both columns and rows, while the copy and paste method can be used to populate a row, column or even an entire block of cells with the same value.

How to Copy From the Internet and Paste Into Excel. Microsoft Excel accepts data input from your keyboard, through file import and by pasting the contents of your computer clipboard into a worksheet.