eHow launches Android app: Get the best of eHow on the go.
Basic Terms in Microsoft Excel
Formulas Used in Microsoft Excel
Changing Text & Row Sizes in Microsoft Excel
Using the Formula & Display Bar in Microsoft Excel
Formatting Numbers in Microsoft Excel
Changing Date Formats in Microsoft Excel
Changing Time Formats in Microsoft Excel
View Sample Formulas in Microsoft Excel: Part 1
View Sample Formulas in Microsoft Excel: Part 2
Selecting a Range of Cells in Microsoft Excel
Auto-Filling a Series in Microsoft Excel
Formatting Cells in Microsoft Excel
Copying & Pasting Cells in Microsoft Excel
Adding Rows & Columns in Microsoft Excel
Deleting & Renaming Worksheets in Microsoft Excel
Creating Rows, Columns & Borders: Part 1
Creating Rows, Columns & Borders: Part 2
View A Sample Spreadsheet in Microsoft Excel
Using the Help Files in Microsoft Excel
How to use help files in Microsoft Excel; learn more about spreadsheet software in this free instructional… More
How to auto-fill a series in Microsoft Excel; learn more about spreadsheet software in this free instructi… More
View some sample formulas in Microsoft Excel; learn more about spreadsheet software in this free instructi… More
How to use the formula and display bar in Microsoft Excel; learn more about spreadsheet software in this f… More
How to format numbers Microsoft Excel; learn more about spreadsheet software in this free instructional video.… More
Microsoft Excel makes it easy to make a graph. All you need to do is supply the data for the graph and the… More
Microsoft Excel allows you to create lists, databases and charts that are effective, comprehensive and fun… More
Learn the basic terms used in Microsoft Excel; learn more about spreadsheet software in this free instruct… More
You can put away your calculator, there is an easier way to add up a number of figures at one time. This … More
Excel is a spreadsheet program that is part of Microsoft's Office Suite of software. Along with Word, Powe… More
As the world of software continues to rapidly improve, more user-friendly and intuitive interfaces are bei… More
Microsoft Excel spreadsheets are helpful for displaying and presenting data. Users can create databases, c… More
Microsoft Excel is more flexible and useful than most people realize. Although Excel is a popular spreadsh… More
Spreadsheets are powerful tools that allow businesses and individuals to track and manipulate information.… More
Summary: How to auto-fill a series in Microsoft Excel; learn more about spreadsheet software in this free instructional video.
"Hi, I’m Gary for Expert Village; there’s a really nice feature in Excel that lets us enter a series of text, numbers or dates, and it makes things much quicker when we are entering information into our spreadsheet. Let’s take for example months; let’s enter in first the month of January and then next to that we’ll enter in the month of February and that is enough to tell Excel that this series of cells in this row are going to be months and it’s going to do like an auto fill of the series. Now we see here when we select the two cells on the very bottom right corner we see that there is a little black mark there. We see that when our cursor goes over that little black spot on the corner of the last cell that is chosen it turns into a plus sign and if we go ahead and we drag across the row we see that it’s, it’s filling in if we look at the bottom, it’s filling in all of the months in the series, because January, February was enough to tell Excel that this is a series of months and it should go ahead and follow the series as we drag across and so now we see in our sheet, we have the column and it’s January, February, March, April and May, June, July and if I keep going it will continue to fill in the months, August, September, October so on and so forth so this is a really quick way of filling in a series and it works the same way with numbers. Let’s say that I have a number here, 789 and the number below that is going to be 790, so we go, it already tells Excel, we select those two cells and again we have this little box, see on the bottom where our cursor turns into a plus sign and we go ahead and drag it down, it’s enough to tell Excel that this is a series and it should fill in all this series of numbers all the way, so it makes it much easier when we are trying to fill in information into our spreadsheet this automatic, this automatic fill in feature of a series of numbers or dates. "
eHow Article: Auto-Filling a Series in Microsoft Excel
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
