Hi Leonard, Leonard Mada schrieb:
I needed today to fill up exactly 30,000 rows. How do I do this?
Enter the cell range - for example A2:AMJ30001 - into the 'Name Box' (the drop down list on the left side of the formula bar) and hit enter. Now the range is marked.
If you do not know, that the last column is AMJ, then click the head of the first row. The Name Box will show the last column. Then you can adapt the line number to your needs.
kind regards Regina --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
