Mood:
brightTopic: EXCEL2007 TIPS
Ever print an Excel worksheet or report whose cells were grotesquely cut off at all the wrong intervals from the rest of the worksheet analysis? Didn't you wish you could merge cell information better so the final print wouldn't have much of the meat lost? Having pondered some level of compromise, take advantage of Excel's page break preview to locate and fix undesirable page breaks in a spreadsheet you are going to print.
Here's how to prevent Excel from separating the most relevant information on a spreadsheet across different printed pages, and force Excel to print the most pertinent data in the same page. All you have to do is move the page break in order to keep certain clusters of information in tact and avoid Excel 2007 from printing such information on a separate page.
- Step 1: Mouse-click View, then click Page Break Preview.
- Step 2: Mouse-over the page break you wish to move (the page break in preview mode will be represented by dark lines and your mouse pointer will transform into double-headed arrows), then drag and drop the page break to a new location.
- Step 3: Now you're ready to print your spreadsheet.
To return to your normal window, mouse-click View then click Normal.
Email a link of our website to a coworker.
Why deprive your friends of all the good stuff!
Copyright 2007 The Q-bicle. All rights reserved.
www.theqbicle.com
The Q-bicle neither warrants expressly, written or otherwise, neither is liable for any representations in content, delays or errors in content, nor actions taken due to content
