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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
microsoft excel courses in - page breaks

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Page breaks

microsoft excel courses in - Page breaks

ResolvedVersion Standard

Sonia has attended:
Excel Introduction course

Page breaks

How do you make a new page exactly where you require it?

RE: page breaks

Hi Sonia,

To insert a manual Excel page break, place your cursor where you want the page
break to occur, and select the Insert menu and choose Page Break

Note the Page Break will occur at the top left corner of the cursor position.

To remove an existing Page Break, place your cursor in that cell select the Insert > Remove Page Break menu option

Accessing the View> Page Break Preview menu options allows you to again add, but also drag Page Breaks to a new location.



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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.