Copying data using AutoFill in Microsoft Excel 2019

The AutoFill handle allows you to copy information to an adjacentrange of cells. When you place your mouse pointer over the fill handle(the little black square located at the bottom right-hand corner of acell), your mouse changes to a small black cross.

While holding down your left mouse button, drag to a new position onthe worksheet. Any text typed into a cell with a number before or afterit will be incremented when using AutoFill, as illustrated in thefollowing screenshot:

ms office 746
AutoFill is not only used for text and values but also to copyformatting. Instead of left-clicking on the crosshair and dragging,right-click to view the AutoFill options available. These will appearonce you release the mouse after dragging to the destination location. 

Leave a Comment