if you want to go to 1,000,000th row press CTRL+G and in "reference"
window insert A1000000, then press OK


On 23 Maj, 12:00, "John McCabe" wrote:
Was trying to show how 2007 will go to 1 mill rows. *Can do it * open new
* BLANK worksheet.
How can I do it if the worksheet is already existing and just want to show
HOW it can go to more rows than will ever need.