Exceljet

Quick, clean, and to the point

Enter same data in multiple cells

Windows shortcut 
CtrlEnter
Mac shortcut 
Return

With multiple cells selected, this shortcut will enter the same data in all cells in the selection at once. This is a great way to skip a copy & paste step. Cells do not need to be contiguous; use Control (Win) or Command (Mac) to select non-contiguous cells before using Control + Enter.

Related videos

The videos below demonstrate this shortcut.
Excel contains special functions that will let you extract the day, month, and year from a valid date. Let's take a look.
In this video, we look at how to use the REPT function, a special function for repeating text values with a numeric counter.
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function, including random dates, random prices, and random workdays.
In this video, we'll look at how to highlight the results of approximate match lookups with conditional formatting.
Each character you see displayed in Excel has a number. In this video, we look at two functions that work with these numbers directly: CODE and CHAR.