Microsoft Office Tutorials and References
In Depth Information
All the formatting is
carried over and the
size of all the elements
is now equal.
Excel's implementation of drag-fill shortcuts helps with the formatting of the source cells,
allowing you to easily duplicate the format patterns of styles on a canvas. For example, we
can use drag-fill to easily fill in areas on a prototype worksheet, as shown in the following
procedure. Furthermore, Excel-implemented drag-fill is a way of dragging a selected
series of cells and then dragging them up or
down;thiscausesaseriesofnumbersorpatterns of numbers to be filled in based on the cells you have selected. How drag-fill works
in general can be found in the Excel help file, but suffice it to say, it begins with the small
handle you will find in the lower-right corner of any selection. However, just because it is
in the lower-right corner does not mean you can drag only to the right or down; drag and
fill works in any direction. This spreadsheet functionality also works with cell formatting,
making the creation of regular formatted areas uniquely simple in Excel.
To Apply Drag-Fill:
1. Select the last three columns of cells in both the All Contacts Toolbar and the
Recent Contacts sections, as pictured Figure A.14, (page 220).
2. Drag the selected cells horizontally to the edge of alignment with the outer
edge of the table (Figure A.15, page 220). Be careful not to drag a cell row
above or below. (If you do, simply redrag it and drop it back into place.)