creating a second page in excel

Question

Please help 

i am using Excel 2013 and i am using one of the templates for my invoices 

now what i would like to do is to add my conditions on the back of this invoice through excel and when i print it up i can print the invoice on one side and my conditions on the back 

i have been trying different things out but nothing is working

Answer 1

I will assume the invoice in on Sheet1 (name does not matter) and take up just one page when printed

Open Sheet2 and add a textbox with you conditions - these could be copied from an existing Word doc if you have one.

We will assume for now there are no other worksheets

See screenshot 1 for silly example. Play with the Term sheet to make the print area only include the text box and in PageLayout unclick Gridlines from View and Print

Open Print dialog: ensure you are set to print on both sides of the paper (duplicate printing) and that you have told Excel to print the entire workbook.

If there are more worksheet and you just want to print two: click on the tab of the first, hold Shift and click the second (this is called grouping). Now in print dialog the first setting should be Print Active Sheets.

best wishes

Answer 2

Thank you so much pal i will try this out very soon cheers