I have a spreadsheet of 5000+ rows, and I need to insert a YEAR column at the beginning with "1936" in every cell. The spreadsheet is too long for me to drag from top to bottom. Is there a formula that allows me to populate, say, A2:A5852 with the value "1936"?
@Lijadaka , as a comment, simple dragging is not quite bad as well - dragging the cell down position mouse outside Excel window, e.g. on task bar - speed of scrolling will increase dramatically. For 5000 rows it takes about 10 sec all together. That's not a preferable option, but it also works good enough.