Page breaks excel 2007

The UK's most regular instructor-led training courses.
Training information: training courses in excel · Microsoft+excel+training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Xavier has attended:
Excel Introduction course

by - delegate Xavier [1 post] (2008 Mar 10 Mon, 16:47) Reply

If got page break on saved data sheet and is saved there how do i get it off?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: page breaks excel 2007

by - trainer Pete platinum contributer [799 posts] (2008 Mar 18 Tue, 08:53) Edited on 2008 Mar 18 Tue, 11:48 Reply

Hi Xavier, Thank you for your post, In answer to your question go to the Ribbon command View and choose the option Normal. It sounds as though you are in Page Break Preview mode. I hope that sorts it for you, best regards Pete.

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Training: Not Just for Newbies Anymore
· How to Create Better Excel Spreadsheets: Part Four
· Prepare for your MOS Certification with MS Excel Courses
· How to check for and reduce errors in Microsoft Excel

Please browse our web site to find out more about
training courses in excel and other Microsoft training courses.

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

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

Enter the constant´s name as 'VAT' (no spaces allowed) in the 'Names in Workbook' line.

Enter the constant value of '0.175' in the 'Refers To' text box - making sure any other text has been deleted.

Click OK.

In Excel you may have cell 'B10' as containing an amount and in 'C10' you want to work out the VAT on the amount in 'B10'.

The formula would be

=B10*VAT

This formula will generate the amount of VAT only.