Invoice Printing Issue in excel

akshaythakare7

New Member
Joined
Feb 25, 2022
Messages
1
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
I wants to make Invoice printing template for my shop in excel.
i made basic template in which specific number of items (we can assume 30) are printed on invoice and at the downside of the print total amount is calculated.
but for more items i want solution that how can i make invoice for more than 50 items where on first printed page there is only 30 items description and other 20+ remaining items should be printed on next page with total amount calculation.
and also on first page at the downside there should be sentence " to be continued"
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,215,734
Messages
6,126,542
Members
449,316
Latest member
sravya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top