Type the Same Value in Every Cell in a Range

Automate Excel

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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.