Automatic data fill-in works on a variety of data ranges, including simple number increments and various date and time patterns. For example, you can create a column of the months of the year in a ...

How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.