How to Set the Default Cell Value in Excel 2007 | Chron.com

Step 5 Select the entire column for which you want to set a default value, and press "Ctrl-V", or select "Paste" from the "Edit" menu. This will apply the formula to each cell in the column, changing the value of the current row accordingly.

smallbusiness.chron.com