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.
