I have to simulate a sheet with more or less 200 columns x 200 rows. When I add the data manually, Excel shows the message "not responding" and I have to wait about 20 minutes till it fills all the cells. As a matter fact, I'd like to know if there is a faster way to insert a big amount of data in a sheet.
The way I'm doing:
I'm writing the data in the first cell (A1), and then, with the mouse, I'm dragging it until the cell (GU1); it goes quite fast, but when I select from A1:GU1 until A100:GU100 (to fill the half of the "matrix" I want), it takes too long (20min or more).
To fill the second half of it, I tried to replicate the data of the first row (A101) until (A200), and then drag it all until the column GU, but it still takes too long.
I also checked this blog but I couldn't find useful information for this issue, so, I'd like to know if someone knows if there is a way to copy a single value to a big "matrix" of cells in excel in a faster way.
- processor: Intel Core2Duo CPU E7500 @ 2.93Ghz,
- Ram memory: 8Gb Excel,
- Excel Version: 2010
System's consummation while replicating data to cells: