Automatically Replicate Formulas in Excel with Tables

While a worksheet in Excel looks and feels like a table, a true Excel table (sometimes referred to as a Ctrl + T table) comes with a lot of bells and whistles. One of those bells, is automatic formula replication. As new rows are added to a table, formulas are automatically replicated for the new row. Without a table, the formulas need to be retyped, copied and pasted, or autofilled to new rows. 


Start by selecting your data and inserting a table from the insert ribbon (or use the keyboard shortcut Ctrl + T). Any formulas added to the table will automatically replicate to the other rows, including rows added later. 


Watch the video to see it in action! 


2021.04 Excel Table Formula Replication


Don't miss another one of our live training sessions - subscribe here.

If you are interested in more training videos, or if you're ready to create a culture of training in your organization, discover all that Affinity Insight has to offer. Or, if you have any questions about Microsoft Excel, CTRL + T tables or any other functions, or Affinity Insight, contact us at 877-676-5492, or request a consultation. Our team of experts is ready to help

Danielle DavisRoe

Written by Danielle DavisRoe

Danielle’s many responsibilities at Affinity include training, CLE/speaking, writing, management consulting, and document automation. Prior to joining the Affinity family, Danielle practiced family law. She discovered, however, that she enjoyed making efficient use of technology more than practicing law, making her a perfect fit for consulting. Danielle describes her superpower as “herding cats,” and her favorite parts of her job are making others’ jobs and lives easier.

New call-to-action

Recent Posts