Rounding up:printing out sheets

I am trying to find a way to round from 1.1-1.9 and have it as 2

The reason I need to do this is that I am printing out sheets of paper that have store ids for some reps. I can only fit 6 on a page I have it set so if its 6 on a page I am good if I go to 7 it goes to 1.2 and 8 is 1.3 and so on. Therefore, when I get to 11 I am at 1.8 and 12 will put me at 2 pages I will use.

What I need to do is take the ones with decimals and round them up so I will see 2 pages when it’s 1.1 or higher.

Thank you,
Charles

Hi,

Using a helper column.

Enter =ROUNDUP(A1,0). Change A1 to start of your range and drag down.

Then select your column with the 1.1, 1.9 etc. Right click while selected and select hide. This will hide the column so your print area will stay the same

VBA Noob