Microsoft Office Tutorials and References
In Depth Information
Use the Table Tool to Copy a Formula
Figure 8.26.
Figure 8.26. Double-click the fill handle to copy to the last row of your
Double-click the fill handle to copy to the last row of your
data.
data.
The fill handle double-click method is fast. Excel 2013 follows any diagon-
al path of nonempty cells to figure out where the bottom of your data set is.
You should always press End and then press the down arrow to make sure
that the formula was copied far enough.
Use the Table Tool to Copy a Formula
The table tool was improved dramatically in Excel 2007. When using this
tool, if you tell Excel that your current data set is a table, Excel automat-
ically copies new formulas down to the rest of the cells in the table.
Figure 8.27 shows an Excel worksheet that has headings at the top and many
rows of data below the headings.
Search JabSto ::




Custom Search