Traditional Culture Encyclopedia - Photography and portraiture - How to nest tables in Excel?

How to nest tables in Excel?

I believe that friends who often use Excel may encounter this situation, and sometimes it is necessary to insert another table into one table, and the row width and column height of this table are difficult to adjust and are often ignored. In the process of using Excel, I found some tips to solve this problem and share them with you.

Select customization in the Excel Tools menu, select the command tab, select tools in the category, find and select photography in the command, and drag it to the format bar.

After the preparations are finished, we can start making watches. First, make a bottom table in Sheet 1, then make a table to be inserted in Sheet2, select the part to be inserted, click our "camera" to take a photo, then select Sheet 1, move the crosshairs to the place to be inserted, and click the mouse. How's it going? Is it convenient? In addition, the table inserted in this way will be automatically updated when you make changes in Sheet2. Making a beautiful nested table is as simple as that.