Choose the row beneath the one where you want the page to break. Choose the column to the right of the one where the page should be broken. Click Breaks, then Insert Page Break, on the Layout tab, under Page Setup.
Select the column to the right of where you want the split below the row where you want it.
Click Split in the Window group on the View tab. Click Divided once again to remove the split panels.
After that, go to View > Window > Split. Simply click the Divide button one more to undo the split. A worksheet can also be divided into columns. Use the Split command on the column to the right of the one where you want the split to go.
Learner's Ratings
4.7
Overall Rating
82%
10%
5%
3%
0%
Reviews
I
Ibrahim Khalil
5
Very good
S
Sathi Nanda
5
Very good teaching quality
S
Soibol Debnath
5
It a very good course.
S
syed enterprise
5
thank you dear
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
Share a personalized message with your friends.