excel training seminar - Excel printing

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

Resolved · Low Priority · Version Standard

Excel printing

Joan has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Joan [1 post] (2007 Feb 15 Thu, 09:52) Reply

how do I print one section of a page on excel

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: excel printing

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 16 Fri, 12:08) Reply

You can simply highlight a portion of your data with your mouse, go to print and check the option that says "Selection" at the bottom of the box, you can check this on print preview that it is the selection what you wanted and print it from there!

Good luck

· Microsoft Excel Training: Essential for Today's Employees
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel Training - Numerical excellence for all
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How to Create Better Excel Spreadsheets: Part Four

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips