TIPS - AutoFill Your Cells

Summary

AutoFill Your Cells

Body

AutoFill Your Cells

AutoFill

This is a no-brainer, but so easily overlooked. You start typing a series of repetitive things like dates (1/1/23, 1/2/23, 1/3/23, etc.) and you know you're in for a long day. Instead, begin the series and move the cursor on the screen to the lower-right part of the last cell—the fill handle. When it turns into a plus sign (+), click and drag to select all the cells you need to fill. They'll magically fill using the pattern you started. It can go up or down a column, or left or right on a row.

Even better—try Auto Fill without much of a pattern. Again, pick a cell or cells, move to the fill handle, right-click, and drag. You'll get a menu of options. The more data you input at first, the better the Fill Series option will do creating your AutoFill options. Check out this Microsoft tutorial.

Details

Details

Article ID: 8609
Created
Wed 10/18/23 10:19 AM
Modified
Wed 10/18/23 10:19 AM