Simple excel question

I have a spread sheet, I want one of the columns to all have the string "Test" in it. How can I do this?

Originally Posted by xxarmoxx

I have a spread sheet, I want one of the columns to all have the string "Test" in it. How can I do this?

Enter your string in the first row of the desired column. Do a copy (ctrl+c), then hit (ctrl+shift+down arrow) to highlight every single row, then do a paste (ctrl+v).