Set Print Area

[az!]

Hello,

I would like to set the printer area of an Excel worksheet. I would like to print one page starting from row A3005-V3220. However, I cannot change the print area. Excel wants each row to be another page. When I drag the blue print area lines, nothing happens. So right now I have 216 pages and only want one!

Thank you in advance for your help!

~az!

[humdingaling]

under page setup
have you set your scaling to fit 1 page long - 1 page wide?

[az!]

Hello humdingaling,

I have set the scaling to fit one page long and 1 page wide as well as try the adjust to setting. It won't change from 216 pages (one page per row).

[humdingaling]

hmmm then i am not sure what the problem is
are you able to upload a sample ?