Limited Print Area

N

nitsa

When I try to print an excel sheet, one of my files does not allow me to
print the whole page. (it is a large file with about 6,000 lines)

When I am in a page beak view it is impossible to drage the blue printing
border down to include some more lines.
 
J

jetted

Hi Nista

I would try this

_SETTING_A_PRINT_AREA

This feature allows you to select what part of the spreadsheet you wan
to print.
1. Click and drag to select the region of the spreadsheet that you wan
to print.
2. Click File>Print Area> Set Print Area.
3. The Print Area has now been set.



_CLEARING_THE_PRINT_AREA

1. Click File>Print Area> Clear Print Area.
2. This should clear the print area and set Excel back to its defaul
print settings
 
Top