Hi,

I have 4 items in 4 rows and rather than go to file-> print and print each row (using print setup) to print each row on a separate page .........is there a way to print multiple pages based on a number I enter in a cell.


Data on 4 rows:

Apples
Oranges
Banana
Onion

Expected out put would be 4 pages of print.......For example if I enter "4" in a cell, can excel prints 4 pages labeled page 1 of 4, page 2 of 4, page 3 of 4, page 4 of 4.............page 1 would have apples , page 2 would have oranges and so on

Thx