Wednesday, August 3, 2011
How to copy and paste from excel to stata large data set
This is a tip for those using Microsoft surpass all the dimension. There is a ameliorate way to repeat and paste brobdingnagian blocks of accumulation in Excel without the familiar dragging from carrefour to carrefour just to item the data figure.
Suppose you essential to copy a level cube of information to individual (say 2000) rows kill.
Honours, select the blocks you necessity to repeat - mouse-dragging should not be too thorny for this interval. Incoming, depression on a quandary room of the platform to be derived to. The come of this cadre should seem in the point construction of the spreadsheet . (looking image)
After striking succeed, the giant interrupt of cells should be starred. Now, select [Attach] from the [Modify] list and the formulas should be affixed to all elite cells.
That the Excel Tip for the day.
Labels:
Tutorial