Recent

Author Topic: Excel stuff  (Read 6615 times)

0 Members and 1 Guest are viewing this topic.

Offline Joe

  • Master of Nothing
  • Administrator
  • Ninja Warlord
  • *****
  • Posts: 38490
  • Gender: Male
    • B4Print.com
Excel stuff
« on: March 16, 2018, 09:21:35 AM »
This site looks like a good place for Excel info should you need it.

https://chandoo.org/wp/
Mac OS 11.4 Big Sur | Prinergy 9.0.1 | Adobe Creative Cloud 2021 | TWO Fuji CTP Units

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

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15911
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #1 on: November 06, 2019, 02:02:56 PM »
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

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15911
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #2 on: November 06, 2019, 02:34:48 PM »
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.
« Last Edit: November 06, 2019, 04:37:48 PM by DigiCorn »
"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

Offline Tracy

  • Ninja Master
  • **
  • Posts: 8221
  • Gender: Female
Re: Excel stuff
« Reply #3 on: November 07, 2019, 11:27:51 AM »
under view select normal
and under page setup select fit to 1 page

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15911
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #4 on: November 07, 2019, 11:43:17 AM »
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

Offline Tracy

  • Ninja Master
  • **
  • Posts: 8221
  • Gender: Female
Re: Excel stuff
« Reply #5 on: November 07, 2019, 12:01:07 PM »
Ah! well that doesn't work then
did you try to change under view?

excel is something I have to fight too sometimes!!

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15911
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #6 on: November 07, 2019, 01:55:13 PM »
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