Uploaded December 2012 | Updated September 2026, 1 week ago

---

This is a short video on how to use the auto pattern feature in Excel, so that if you want to label the values of a column from say, 1-20, then this can do that without having to type the values individually. This can also follow a letter pattern, such as abc. Also it can even continue a number pattern that is after a letter, such as a1, a2, a3... It can be a huge time saver and works in Microsoft Excel 2010, 2007, 2003, and XP.

Check out my facebook at: facebook.com/pages/All-How-2s/198429346974010

or my twitter: twitter.com/AllHow2s

Or my website where I have a lot of other great tutorials (such as how to take a screenshot, or how to get the start button back on Windows 8): allhow2s.com