« Fixing Web Browser Printouts That Are Too Small To Read | Main | Mad Tech Skillz »

Fill 'er up!

FillHandleI keep learning cool things to do with the "fill handle" in Excel.

Using the fill handle
First, here's a video (6:06) that runs through using the fill handle to easily create a list of months, days of the weeks, numbers, and custom lists. (did you know you could create custom lists for auto-fill? I didn't! Now I'm thinking about all the lists that I might want to autofill again and again.... a list of our member libraries, a list of LINKcat libraries, a list of employees...)http://www.youtube.com/watch?v=_MPguASIPz0

So handy.  For example, for days of the week just type "Mon", drag the fill handle, and there's your full week!   Here are some other fill examples:Fill Examples

Double-clicking to fill
Next, here's a short video (1:54) that shows how you can quickly copy a formula down to the end of your data with a simple double-click (this is the one that I thought was really cool, as I sometimes have 65,000 rows of data when looking at log files.  If I couldn't double-click, that would mean a lot of dragging and scrolling!)  http://www.youtube.com/watch?v=x1fRZwm1Uqc


Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment