Excel-Split-and-window freeze-Use

Recently, I was sorting out the Excel bill and thought-Split-and-window freezing-was a very practical function, and the effect was very professional.

 

Everyone who learns Excel must master this function.

 

Effect display:

Normally,

 

 

When turning pages,

 

 

This is just a demonstration of the effect. We need to discover the real use together.

 

 

Next, let me explain how to implement this simple operation. Step 1: Window --- split --- as shown in

 

 

 

The next step is to move the two bars and bars as needed.

 

If you do not need to split vertically, move the vertical bars to the leftmost.

 

If you think the vertical bars are ugly, click the freeze window. The horizontal and vertical bars disappear and the effect remains.