excel training microsoft - printing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Lauren has attended:
Excel Intermediate course
Excel Introduction course

Printing

How do i print a selected area of a page?

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:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips


Server loaded in 0.09 secs.