With the help of this function, a whole column can be filled either with a sequential number or with a constant. Among other things, ID columns can thus be easily created in Excel files.