Printing a document

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

Resolved · Low Priority · Version 2003

Printing a document

CARRIE-ANN has attended:
Excel Intermediate course

by - delegate CARRIE-ANN [1 post] (2008 Apr 24 Thu, 16:02) Reply

I have a document that seems to have 3 pages, but only 1 with info on, so when I print I get 1 page with info and 2 blank, how can I get rid of the other 2 pages

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: printing a document

by - trainer Pete platinum contributer [600 posts] (2008 Apr 24 Thu, 16:19) Edited on 2008 Apr 24 Thu, 16:21 Reply

Hi Carrie-Ann, Thank you for the post, welcome to the forum, to fix your problem, select the Menu command, View>Page Break Preview and check where/how your pages are set up, ie if your size of page is greater than the paper size etc. Also, check to see if you have any hidden entries on any of your extra pages such as a space bar press somewhere in the last page shown or similar; if nothing is immediately obvious, select the columns/rows that are extra to your requirements, and select the Menu option Edit>Clear>All.
I hope one of those will help, if so please click the resolved link, best regards Pete.

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Reasons Why VBA for Excel Training Fails
· Microsoft Excel Training: Essential for Today's Employees
· Tap the Power of Recorded Macros with MS Excel Courses
· Take the Anxiety out of Domestic Finances with Microsoft Excel

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

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.