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
page breaks

ResolvedVersion 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:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

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.