excel training courses london - page break

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses london - Page break

excel training courses london - Page break

resolvedResolved · Low Priority · Version Standard

Page break

I have a page break on a spread sheet, which is greyed out, and when I printed it will only give me a page underneath the greyed out area, how do I undo the grey area, and reset the page break so all info is printed out

RE: Page break

To print the exact amount of pages you want, you can use the Page Break Preview view to quickly adjust page breaks. In this view, manually inserted page breaks appear as solid lines. Dashed lines indicate where Microsoft Excel will break pages automatically.

On the View menu, click Page Break Preview.

Do one of the following:

To move a page break, drag the page break to a new location.
Note Moving an automatic page break changes it to a manual page break.

To insert a vertical or horizontal page break, select a row or column below or to the right of where you want to insert the page break, right-click, and then click Insert Page Break.
To remove a page break, drag the page break outside of the page break preview area.
To remove all manual page breaks, right-click any cell on the worksheet, and then click Reset All Page Breaks.


 

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips


Server loaded in 0.09 secs.