page breaks

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Page breaks

Page breaks

resolvedResolved · Low Priority · Version 2007

RE: page breaks

Hi Teresa

In Excel to get rid of Page Breaks you need to view the worksheet in Page Break Preview.

In this view the page breaks appear as blue lines on the screen

You click below the Horizontal lines and to the right of the Vertical lines and the right click the mouse.

In the menu the Remove Page Break command appears.

NB If the wrong cell is selected the normal Insert Page Break line appears

Hope thos helps

Carlos

Tue 3 Feb 2009: Automatically marked as resolved.


 

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Server loaded in 0.11 secs.