excel training courses

excel training courses - Print Area

Resolved · Low Priority · Version Standard

Print Area

Debbie has attended:
Excel Advanced course

by - delegate Debbie [1 post] (2007 Sep 13 Thu, 09:45) Reply

How can you set the print area?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Bloomsbury	0	FULL
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
Full Schedule: See all 110 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Print Area

by - delegate Katie [6 posts] (2007 Sep 17 Mon, 14:33) Reply

highlight the area you wish have as your print area. then go onto the layout ribbon and click the "print area button". this will lead you to "set print area". then you are good to go.

· Advanced Excel Training - takes you to the next level
· Customized Financial Excel Courses in London
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Improve Performance Of Your Excel Macros
· Features of Microsoft Excel that assist in Analysis of Financial Data

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

Rate this page: