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 a few ways to generate random values with the RANDBETWEEN function, including random dates, random prices, and random workdays.
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 perform a random sort with the SORTBY function, with help from the RANDARRAY function.
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.
In this video we look at how to use the REPT function, a special function for repeating text values with a numeric counter.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
