Is there a way you can drag down data using your keyboard instead of the mouse?
crtl d
and ctrl r to drag right
I’m actually trying to do another function. Say I have a 3 columns of formulas in column A,B, and C. To drag down the formula to row 2 I would normally highlight the 3 columns and then drag the box in the left hand corner. I know there has to be a way to do this without a mouse.
highlight formula and the blank cells that you want to have the formula in and hit Ctrl D
alt e i d
That works. thx.