I have asked a similar question before How to automatically increase the exponent in Google Spreadsheet?
But the new question is:
In a Google Spreadsheet, I put in the following numbers in a ROW, each number is an entry in the ROW.
100 100*1.01 100*1.01^2 100*1.01^3
The highest exponent of 1.01 is 3 for now. But I would like to keep filling this ROW until the exponent of 1.01 is 30. I can only do it by filling each entry in the ROW manually. How can I do this easier?
But this does not work.