We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. And also you can follow us on Twitter and Facebook. If you liked our blogs, share it with your friends on Facebook. This is the way by which we can select the data through the address bar and copy & paste cell content to thousands of other cells in Microsoft Excel. For example, type A1:D1.Ĭopy and Paste by selecting rows and columns:.

Paste the data in column E by pressing the key Ctrl+V on your keyboard.

Press Ctrl+C on your keyboard to copy the selected rows.

To copy and paste the cell content to thousands of cells, follow below given steps:. contains a Smart List or the database to which youre connected supports. We have data in range A1:D5000 in which column A contains Name, column B contains Score (1st Day), column C contains score (2nd day), and Column D contains total score. The cells will paste into the first visible cell and into the next three hidden.

Let’s take an example to understand how we can copy and paste cell content to thousands of other cells. In this article, we will learn how we can copy and paste cell content to thousands of other cells in Microsoft Excel.

How to paste list into excel