The Excel fill handle can be dragged up and left too!

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.

Can I use autofill to the left and upwards too?

The Excel fill handle can be dragged up and left too!

Most people are aware that the Excel Fill Handle (the black square in the bottom right hand corner of a selected cell) can be dragged to the right and down to extend a formula. What most people aren't aware of is that you can also drag the Fill Handle to the left and up (just be careful to drag far enough, otherwise you'll just delete the contents of the cell).

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Ray Lokar