Enter same data in multiple cells

Keyboard shortcut options for this action in excel: enter same data in multiple cells

Sponsored Link

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.

Sponsored Link

0 votes. 0 / 5