Site logo white shadow

Excel Tables 8 – Automatic copying of everything!

Yes. It is not only formulas which get copied when you extend a table. Everything gets copied. Read on to find out about Automatic copying and how much time you are wasting by not knowing this!

Automatic copying of everything

How to add more data to a table?

Two ways: Copy paste or manually type (or in case of external connections,  refresh the data).

In either case, the Table expands and copies the base formatting. I am sure you have already noticed that. We also saw that if you add raw data, calculated columns are automatically copied and filled up.

But that is not all. There is more – much more!

Table copies EVERYTHING other than values

I am trying to create a comprehensive list here. I may have missed some things but still…

Formulas, Number formatting, Conditional formatting, validations, named ranges (extends vertically), Locked and Hidden status.

Notice that items which are applied while the WHOLE COLUMN is selected get carried forward. If you select few cells in a column and apply any of the above items, those will NOT get auto-copied.

Sparklines also get copied, if they are a part of the table (inserted as a column).


Now when a new row of data is added, you don’t have to update the Sparkline data range.


Want to know how to draw these beautiful and highly informative Sparklines?
Read these articles:
Mini-charts: New method of visualizing data and
Mini Charts : Sparklines : Usage scenarios

What Next

We will see how calculated columns can be added more easily with intuitive formulas. Something you cannot even imagine!

Related Articles

This article is a part of series: Knowledge Pack – Excel Tables

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,755 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.