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
Bookmarks