excel training microsoft - printing
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Printing

excel training microsoft - Printing

resolvedResolved · Low Priority · Version Standard

replyReply Thu 26 Jul 2007, 12:39Delegate Lauren said...

Lauren has attended:
Excel Intermediate course
Excel Introduction course

Printing

How do i print a selected area of a page?

For upcoming training course dates see: Pricing & availability

replyReply Thu 26 Jul 2007, 16:24Trainer Amanda said...

RE: Printing

Hi Lauren

Thanks for your question.

You can do this either by selecting an area, then going to File - Print - Selection - then OK.

If it's the same area of the spreadsheet that you're going to be printing multiple times, then you can set a print area. Select the cells to be printed, then File - Print Area - Set print area. Then you can print just that area of the spreadsheet by hitting the Print button.

Amanda

 

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard