1 --> 150

[Adapted]

Hey,

Im trying to create a table, with columns 1 to 150. Is there a function
to automatically put in all the numbers to save me typing in every
single number?

Any help would be greatly appreciated

 

[Frank Kabel]

Hi

two possible solutions:
1. Insert 1 in A1 and 2 in B1; highligh both cells; goto the lower
right corner of this area (the cursor will change to a cross); while
holding the left mousebutton down move right).
2. If you realy need a formula, insert the following in A1:
=Column(A1)
copy this for all columns

Frank