There are many partners who don’t know how to clone a table in Excel, but it doesn’t matter. Below, the editor specially shares the operation method of cloning a table in Excel. I hope friends in need can come and learn together.

​​ ​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​ off, using the following simple example as an example.

Right-click on any empty space in the upper function bar, select [Customize Quick Access Toolbar], select [Commands not in the Ribbon], and find [Camera] below, and add it to the right toolbar.

Finally, select the table you want to clone, click the camera icon above, and drag a box where you want to place it, so that a table will be cloned.

Many friends will ask what is the difference between this and simple copy and paste? The difference is that if the data in the original table changes, the table cloned by the camera will also be changed simultaneously, so you no longer have to read the data in each table.

Come and learn how to clone a table in Excel. It will definitely help everyone.