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.
Hi Lijadaka
Quickest way I can think of:
1. Type 1936 into A2.
2. In the Home tab, use the Find & Select > Go To... and type A2:A5852 in the Reference box.
3. Press OK and Excel will select that range of cells.
3. In the Home tab, under Editing, use the Fill command and choose Down.
You should now have 1936 filled for the entire range.
Hope that does the trick. Let me know?
Cheers and best wishes
Damien
Thanks for thatDamien_Rosario I couldn't find it anywhere in Help - and I'll use it a lot.
