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.
