Do you ever need to create a list in Excel and don’t want to type in every row or column individually? You can automate this process with Excel’s built-in common lists feature.
For example, if you want to type the months of the year from January to December:
Step 1: Type in one cell: January. Then mouse over the cell so that the bottom right corner becomes a “+” sign and drag the “+” sign down the rows vertically (for a column), or to the right (for a row horizontally).
Step 2: Release the mouse and Excel will automatically fill in the rest of the months for you!
Other built in lists available are the months of the year abbreviated (Jan, Feb, etc), the days of the week, the days of the week abbreviated, and any type of numbered list (1, 2, 3, etc…).
Leave A Comment