- Worldstart's Tech Tips Newsletter - 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!
Article printed from Worldstart's Tech Tips Newsletter: http://www.worldstart.com
URL to article: http://www.worldstart.com/break-it-up/