- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Break It Up

Posted By On March 30, 2007 @ 3:40 PM In MS Excel,MS Office Help | Comments Disabled

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!

~ April


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/break-it-up/