Microsoft Office Tutorials and References
In Depth Information
Use the Table Tool to Copy a Formula
Figure 8.29.
Figure 8.29. Defining a range as a table provides formatting and powerful
Defining a range as a table provides formatting and powerful
features such as autofilters and natural language formulas.
features such as autofilters and natural language formulas.
Now when you enter a formula in the table, Excel automatically copies that
formula down to all rows of the table.
Note
As shown in Figure 8.30 , a lightning bolt drop-down appears to the
right of cell D3. This drop-down offers you the opportunity to stop
Excel from automatically copying the formula down.
Figure 8.30.
Figure 8.30. Thanks to the Table tool in Excel, a new formula entered any-
Thanks to the Table tool in Excel, a new formula entered any-
where in column D is copied automatically to all the cells in column D.
where in column D is copied automatically to all the cells in column D.
Search JabSto ::




Custom Search