Share via

Add more items to the invoice tracker - Excel Template

Anonymous
2016-11-21T12:18:44+00:00

Hello,

I downloaded the Sales invoice Tracker and did not copy paste into any other work sheets, I am working in the original downloaded file.

I have more than 25 items per invoice and I dont not know how to printed showing all my the items; also I need more pages.

How can I add more pages to this template so I can show all my items and also print it completely?

Thanks for your answers,

Mauro

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-12-09T15:33:30+00:00

    Hello Herbert:

    I was  not able to share the file, however I took some screen shots to try to explain myself:

    Screen 1. All the items for my invoices. As you can see all invoices are named and there are a lot of them in red. That means the red invoices won't fit in the 25 items template

    Screen 2. Invoices with all their values. please note invoice No. 2 CC+FN_CHANGE has a total value of $228.981.oo

    Screen 3. Invoice CC+FN_CHANGE; the total value on the invoice is $104.598.oo with 25 items, but the invoice has 82 items with a total value of $228.981.oo I am missing 52 items

    I need to be able to use the template to have all the items, for that reason I need to generate new pages. In this particular case my invoice must have 4 pages to show the 82 items. 

    I hope this one was a better explanation.

    Thanks a lot again.

    Mauro

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-12-09T20:10:44+00:00

    My suggestion was/is to abandon this or any other template that is cell-based,

    and go with PowerPivot and/or Power Query

    which is Table or column based.

    If you share a small, sanitized/fictitious, non-template file of your data

    I might generate a modern version.

    It would also require you to learn PP and PQ, a months long effort.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2016-11-26T14:24:07+00:00

    Hi Mauro,

    Right-click a row in the invoice tracker and select "Insert". After adding a row, press F4 to continue adding rows. Let us know if it helps.

    Regards.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2016-11-23T12:17:59+00:00

    Hello Kaven,

    Thanks for the link. My real problem is that my invoice have 75 items, that means must add at least 3 additional pages. I was not able to add them.

    Mauro

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-11-22T12:37:14+00:00

    Hello Mauro,

    Let's work on this together. Have you tried inserting rows on the worksheet? If you haven't tried it yet, you can follow the steps on this link. We'd also like to know if you're trying to add pages or worksheets.

    Regards.

    Was this answer helpful?

    0 comments