Question: how to copy same value in multiple cells in excel formula?
Answer: Select all the blank cells in a column. Press F2 to edit the last selected cell and type some data: it can be text, a number, or a formula (e.g. "_unknown_") Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.