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.
In this lesson, we cover shortcuts you can use to to enter data in one or more cells at a time. Knowing these tips can really speed up editing in Excel.
In this video, we'll look at how use Boolean algebra in array formulas for AND and OR logic. This is a key skill when building dynamic array formulas.
In this video, we'll look at how to create a named constant. This is a useful way to create a name that doesn't appear in a cell on the worksheet.
In this video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions.
In this video, we’ll look at how to perform a random sort with the SORTBY function, with help from the RANDARRAY function.