Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Data Visualization with Excel When To Use What Type of Chart Why A Column Instead of Bar

Posted by hamsternation
hamsternation
26,616 Points

Protip: Drag the lower right corner of Aristotle Duderino 1 to autofill 2,3,4 ...

Excel has a really smart auto-completion feature where if you click on the bottom right corner of a cell, and then click and drag it down, it fills the rest of the cells with logical numbers (you can also double click on the lower right corner).

For example: Aristotle Duderino 1

Automatically gets filled to: Aristotle Duderino 1 Aristotle Duderino 2 Aristotle Duderino 3 Aristotle Duderino 4 etc...

This also works with Dates, Days of the week, Months, and other logical sequences.

1 Answer

Jordan young
PLUS
Jordan young
Courses Plus Student 5,276 Points
Jordan young
Jordan young
Courses Plus Student 5,276 Points

Gotta love that fill handle! Good tip!