Enter same formula/ values in multiple Excel cells (at once)

00:00 Enter formula into many Excel cells at the same time
00:10 Subtotal formula in multiple non-adjacent cells WITHOUT Copy/ Paste
00:20 Highlight non adjacent cells (CTRL shortcut)
00:30 WITHOUT clicking again, type formula into active cell
00:48 CTRL + ENTER enters that formula in ALL the highlighted cells
01:00 Skip the Copy/ Paste step of copying formula to many cells

An Excel trick shortcut to enter the same formula into multiple (often non adjacent) cells in one go without having to create the formula and then copy/ paste it to all the other cells.