When the data content of more than one width, Microsoft office 2010 Excel will always be the first print left part of the right part on the new page, this would print out the data can not be completely displayed on one page. How to be better able to solve this problem?
When faced with the following circumstances, the data micro printing print on one page:
When the data content of more than one width, Excel always prints first the left part of the right part on the back of the page alone, but the right half of the data does not, may be twelve;
When the data content of more than one, Microsoft Office Standard 2010 Excel, always the first print in the previous section, the excess portion on the back of the page, but not much in excess, may be one or two lines.
Above, whether alone or simultaneously, if not adjusted directly to print, then print out the effect is not satisfactory, but also more waste of paper.
First, the "Page Break Preview view to adjust the specific steps are as follows:
A. Open the need to adjust the worksheet, the implementation of the menu bar "View" → "Page Break Preview" command into the "Page Break Preview view.
Two. A blue dotted line between the columns L and M columns can be seen from the figure, this line is the vertical page breaks, its right part is beyond a wide part of. Following it and the left part on the same page width: Move the mouse pointer between the blue dotted line in the column L, and M columns, the mouse pointer into the left and right double arrow, then press and hold the left mouse button, drag to O column right edge of the drop it.
Adjusted can see the blue dotted line and O line the edge of the blue solid lines overlap, indicating that the vertical page break to be re-set the original excess of M, N, O column of data can be printed on the same page a.
3. Horizontal page break settings and vertical page breaks.
Second, through the Page Setup dialog box to adjust
"Page Setup" dialog box to adjust. The specific steps are as follows:
A. Open the need to adjust the worksheet, perform the menu bar "File" → "Page Setup" command, open the Page Setup dialog box.
Two. Open the page "tab. Area of the "Zoom" option is selected and adjusted to "radio button, then enter in the text box on the right page width" and "1" page high.
3. Click "OK" button.