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.
However, not many people realise you can RIGHT-CLICK Drag and get a few more
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