Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Disabling Formula Replication In Excel

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
29K views 10 years ago
Added to the 2007 release of Excel, Tables are one of the most important features added to the application in twenty years. One of the primary advantages associated with using tables in Excel is formula replication – formulas that automatically copy down a column in a table, even as the volume of data changes. However, in some cases you may not want this feature to engage. In this tip, you will learn how to disable formula replication in Excel tables. ...more
...more
Disabling Formula Replication In Excel
60Likes
29,394Views
2014Jul 29
Added to the 2007 release of Excel, Tables are one of the most important features added to the application in twenty years. One of the primary advantages associated with using tables in Excel is formula replication – formulas that automatically copy down a column in a table, even as the volume of data changes. However, in some cases you may not want this feature to engage. In this tip, you will learn how to disable formula replication in Excel tables.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers