Break It Up
Okay, so I’m sure most of you know the basics of inserting page breaks in MS Excel.
If you pick a cell in column A and use the Insert menu, Page Break choice, Excel will insert a horizontal page break above the selected cell.
Also, if we pick a cell in row one and try the Insert menu, Page Break choice, Excel will insert a vertical page break to the left of the selected cell.
But, what happens if we select a cell that’s not in row one or column A?
That’s a good question and fortunately, it has a fairly easy answer.
If you select a cell outside of row one or column A, Excel will insert two page breaks when you use the Insert menu, Page Break choice.
One page break will be inserted to the left of the selected cell and the other above it.
There you have it. The scoop on getting Excel to break up your worksheets. Easy as pie!