Excel Magic Trick 1240: Double Click To Copy Formula Down When Formula Is Not Next To Data Set

preview_player
Показать описание


Learn how to Double Click To Copy Formula Down When Formula Is Not Next To Data Set by highlighting empty cell next to data set and cell with formula before double clicking and sending it down.

Katarzyna from pmsocho from Youube's class discovered this trick!!!
Рекомендации по теме
Комментарии
Автор

Mike!!! And of course, PMSOCHO!!I've been dragging columns around for years to use that double-click copy down feature, and now I learn I didn't need to????  What a great trick.  Sometimes the smallest insights produce the biggest rewards.  Thanks!

jcook
Автор

THIS TRICK WAS BEAUTIFUL!!!! Was driving me nuts!!!!

hulkbuster
Автор

@J Cook I totally agree!!! This trick is

excelisfun
Автор

All the credits for that trick go to one of the students from my class! I learned that from Katarzyna!
Anyway - thanks for spreading that trick through the world!

pmsocho
Автор

Katarzyna from pmsocho from YouTube's class discovered this trick!!!

excelisfun
Автор

wow good tip, This has made my day!!
Thanks to all for this tip.

hoggrobinson
Автор

Hi, awesome video ! Do you suggets any keyboard shortcut to fill down without scrolling down? I've been looking for this for some time.

kiarasharian-yt
Автор

Like this. Very neat.

Why is there no keyboard shortcut to send down though? I'm constantly finding I'm moving to the mouse just to perform this action.

duffry