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