welcome to just answer
it would be my pleasure to assist you on this
tell me when you are ready to chat
I'm ready. Thank you.
did you try going toExcel printing preferences setting it to one page wide and one page tall
no I didn't...let me just try that now
Sorry...I'm working in Japanese here....is that under the print menu?
let me try to get you a screenshot
thank you very much!
I just found it!
it should be under file -> page setup
and in the fit to section set it to 1 page wide
1 page tall
I never knew that was there!
You are a super genius!
Thank you very much
however to apply this to all your worksheets You have to select all the worksheets and then do the change. Hold the shift or command key while clicking them.
Don't forget to leave me a positive rating as it helps me help you better. A bonus will be highly appreciated
OK. Now......to complicate things...some of my worksheets have more than one page. I assume this will not work. Or, rather, that it will make everything one page.
you can only select one page wide
and don't specify the one page tall option
you can apply this for a single worksheet or a group by selecting a bunch of them then applying the page setup
Aha. Like I said, super genius. Thank you so much. This has been driving me up the wall for about 3 years!
wow 3 years
I know...I just gave up and used my vaio.
Poor little MacBook
I am glad that i was able to help you get rid of this nightmare.
I think i deserve a nice bonus :D
Now I can use it with confidence and not curse at it. Yes, you did. Many thank-yous. I
Yes, I think you do, too!
OK....I'll be sure and ask you if I have more such questions. Thanks again!
In case you need my help anytime, just post a question starting with " To Ehab Tutor" and i will be at your help
Will do. Have a nice morning!