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 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.
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.
In this video we show you a handy shortcut for entering data into more than one cell at the same time.
In this video we'll take a look at a few reasons why you shouldn't hard code values into your formulas that may change.
In this video we look at how to simulate a random drawing to pick winners in a contest with Excel using the RAND and RANK functions together.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.