Stop dragging formulas down in Excel. How to apply formula to entire column without dragging.

Here are the hot keys featured in my video.

Select All Rows
Ctrl + Shift + Down Arrow

Copy Formula To All Rows
Ctrl + D

Select All Columns
Ctrl + Shift + Right Arrow

Copy Formula To All Columns
Ctrl + R

#tips #excel #shorts #fyp