How to increase rows in ms 2007 to 1 million
Hi,
If you need to do this for a test purpose:
---Manual Way---
1. fill a couple of line with some kind of data, or open an existing excel sheet.
2. selact all via CTRL+A key combination
3. copy selection CTRL+C
4. Go to the end of selection CTRL+END
5. Paste the copied rows CTRL+V
Repat this until you have 1 million rows.
Note that, you are limited with the resources of your computer. If you do not have enough memory and CPU capacity, your operation may be stop with and excel error.
Regards.
×