How to save a numbers file to a pdf file of multiple pages instead of one giant long page?

Guess I'm not explaining well. What I have is a Numbers spread sheet - when I export it as a pdf file, it ends up on one page, and when printed, is so tiny can't be read even with a magnifier. What I can't figure out how to do is split the pdf into as many pages as it takes so that cells and text are actual size.

Also apologize for excess queries to the Forum and appreciate the assistance!

Hi Jerry - thanks for your response. Risking seeming like prize dummy - can't seem to locate the layout selection. I do see the Image Quality selection. Would you please guide me further? Thanks!

Well, now I need to noodle around to find my profile. Sorry - I didn't mean to be misleading. I'm on 10.9.4 OS and Numbers 3.2.2

And in hopes you got the answers for these. Many thanks, DW

Please point me to how to change a profile. I locked myself out yesterday. Thanks Jerry!

Found - it's all good. Many thanks!

Awesome! Ian - this worked like a charm! Thanks so much! (I've copied and pasted your instruction in to the annual of things I've had trouble with and might forget before I need again.)

Best, DW