Main Menu

Excel stuff

Started by Joe, March 16, 2018, 07:21:35 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Joe

This site looks like a good place for Excel info should you need it.

https://chandoo.org/wp/
Mac OS 11.5.2 Big Sur | Prinergy (retired) | Adobe Creative Cloud (retired) | TWO Fuji CTP Units (retired)

I'm Sorry I Hurt Your Feelings When I Said You Were Stupid. I Honestly Thought You Already Knew

DigiCorn

Where the fuck does the damned PDF go when you print to PDF? Can't find it anywhere and save to PDF doesn't work - file is all FUBAR

on Mac OS
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

DigiCorn

#2
figured out a work around. that was stressful - had a guy waiting on it and nothing else was working for what he wanted other than the print to pdf. I did all the same procedures, but instead of print to pdf, i hit preview in preview, and then exported the pdf from there. it got what we wanted. save as pdf was making weird page breaks and not doing what was intended.
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

Tracy

under view select normal
and under page setup select fit to 1 page

DigiCorn

yeah - unfortunately for this project, that was not working. Even zamzar messed it up... I got an 11" wide x 1000" long document, 1 single page. It was a long-ass spreadsheet that was supposed to be 118 pages, 11" x 8.5".
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

Tracy

Ah! well that doesn't work then
did you try to change under view?

excel is something I have to fight too sometimes!!

DigiCorn

The document had "defined" page breaks, for whatever that is worth, and I selected and defined the print area, but it kept redefining and splitting up the document, so instead of 118 pages, I'd get like 600+ pages or something. The only way it would run 118 pages as defined was printing as a pdf... then it would write a file 118 pages long, but I don't know where the file ends up. That's why I clicked preview in preview and then exported from there.
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway