Current location - Loan Platform Complete Network - Big data management - Big data splitting excel
Big data splitting excel
Suppose the table needs to display two parts with column D as the dividing line, and the moving position can be controlled independently;

1. Select cell D 1, enter the View toolbar, and click Split to display two windows with columns C and D as boundary lines;

See figure 1.

2. The actual result is that the two windows are moved by independent sliders, and the sliders can independently control the movement of their respective tables;

See figure 2.