Life’S No Drag With Excel – Or Is It?

Home/Functions/ Life’S No Drag With Excel – Or Is It?

Life’s no drag with Excel – or is it?

By Wyn Hopkins

 

You may be familiar with a LEFT-CLICK drag to copy down a formula but we bet you’ve never tried a RIGHT-CLICK drag, here’s what happens…..
It’s fairly common knowledge that you can fill a list of dates by typing in one date, then clicking and dragging the “fill handle” down the page.

Wyn Tip 1

However, not many people realise you can RIGHT-CLICK Drag and get a few more

Wyn Tip 2

Extra tip: Incrementing numbers can be made easier by typing 1 in the first cell and then hold the Ctrl key while dragging the fill handle

2017-03-08T03:54:05+00:00 Functions|