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.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
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
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.