Forum Discussion
I Don't Get Named Ranges
Hi Jon,
You may select the range in column B where to enter formula, in formula bar =MyCol+5 and Ctrl+Shift+Enter (array formula)
Hi Jon,
You may select the range in column B where to enter formula, in formula bar =MyCol+5 and Ctrl+Shift+Enter (array formula)
Thanks you, Sergei. That seems too easy, but I got to admit that it works.
I have a follow-up question. In my simple example, and in your sample table, there are only a few rows. In reality, I have nearly 2,000 rows. I can cobble together the formulae for the first row of data. Is there a simple way of filling the remaining rows with the formulae, other than a cut & paste of a honkin' big range?
Hi Jon,
If with named range you may select all your rows in column B, includes first ones with formulas, and just press Ctrl+Shift+Enter.
Alternatively, without named range, you may add into B1 the formula =A1+5, after that select entire range in column B (let say B1:B2000) and press Ctrl+D to populate the formula down.