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 to use conditional formatting to shade alternating groups of rows - groups of 3 rows, groups of 4 rows, and so on.
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.
One of the cool things you can do with Paste Special is make "in place" changes to numbers. This is a handy way to quickly change things like dates, prices, and times without using formulas.
