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 highlight the results of approximate match lookups with conditional formatting.
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.
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 use conditional formatting to shade alternating groups of rows - groups of 3 rows, groups of 4 rows, and so on.
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.
