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.
Excel contains special functions that will let you extract the day, month, and year from a valid date.
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 few ways to generate random values with the RANDBETWEEN function, including random dates, random prices, and random workdays.
In this video we show you how to find all matches at the same time.
In this video we'll look at how you can use the CHOOSE function. We also compare a formula based on CHOOSE vs. a formula based on VLOOKUP.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
