Type the Same Value in Every Cell in a Range
You would think that to type the same value in every cell in a range you could just select the range, then type your value, and it would fill the range, right? Almost.
1. Select the entire range
2. Type what you’d like to see in every cell once
3. Hit Ctrl and Enter at the same time