If you want to make a change to a cell and reflect that change to a selection of cells, then pressing CTRL + ENTER will fill down or copy your action to the selected cells.
Helpful Resource:
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.
30 Days - Full Access 
