Forum Discussion
Copying the same value in one column in a large spreadsheet
As Damien_Rosario suggests, type the number 1936 or text '1936 into the top cell A2.
Then double-click the fill handle at the bottom right of the cell and the value will fill down to match adjacent columns.
Another possibility to consider is inputting the value 13150. That is the date value for the 1/1/1936 and the custom number format can be set to display 1936.
The options make no difference if the value is just for visual effect but if the field is referenced by formulas it is worth getting it right.
As Damien_Rosario suggests, type the number 1936 or text '1936 into the top cell A2.
Then double-click the fill handle at the bottom right of the cell and the value will fill down to match adjacent columns.
Another possibility to consider is inputting the value 13150. That is the date value for the 1/1/1936 and the custom number format can be set to display 1936.
The options make no difference if the value is just for visual effect but if the field is referenced by formulas it is worth getting it right.
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.
