Printing does not match the preview page

Occasional Visitor

Hello everyone,

I am trying to print a spreadsheet. The preview page shows all the pages I need to print but it cuts off when sent to the printer.

I have tried all the options but nothing has changed.

Kindly help to resolve.

1 Reply

@Hennyb 

Did you format the data range as a table?
If so, please look under Formulas > Name Manager to find out what this table is called.
If name exists then this table is dynamic.
Select your table, go to Page Layout and set the print area.
The print area is also listed in the name manager.
Then change the print area with the name of the table,
so for "Relates to" enter for example =Table1.

 

Additional Info:

Set or clear a print area on a worksheet

 

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)