wrath help required: Excel

Received an Excel file with 6 worksheets in it.

I need to save each one as a pdf.

Because of the native page breaks the pdfs are being split over multiple pages.

I have tried moving page breaks manually, but they keep defaulting.

Any ideas?

Posted By: malkybarkid on March 4th 2020 at 15:35:44

Message Thread

wrath help required: Excel (General Chat) - malkybarkid, Mar 4, 15:35:44
- usually do Print to PDF and in the setting do Fit to One Page (n/m) (General Chat) - Ralf Scrampton, Mar 4, 16:48:18
- Ok - this is how you do it.. (General Chat) - shoddy, Mar 4, 16:29:05
- Print or save as PDF. But first set each sheet to a 1 page x 1 page fit (page layout) (n/m) (General Chat) - essexcanaryOTBC, Mar 4, 16:24:21
  - This is what I eventually did. (n/m) (General Chat) - malkybarkid, Mar 4, 17:12:50
  - ^^^ yeah, this (n/m) (General Chat) - Ralf Scrampton, Mar 4, 16:48:43
- Up the cods (n/m) (General Chat) - yellowman, Mar 4, 16:17:02
- Copy the cells you want to print to a new workbook. (General Chat) - Trent_Canary, Mar 4, 15:56:46
- Pens has flounced off to Bruges with Tristram I’m afraid malky (General Chat) - Old Git, Mar 4, 15:53:24
  - Saw Tristram's man, Tolly over the weekend. Him and Bunty got caught having it off in the (General Chat) - malkybarkid, Mar 4, 16:01:17
    - Quite right too! I mean, standards (n/m) (General Chat) - Old Git, Mar 4, 16:42:22
- Word to your mother, do a smell up the USB (n/m) (General Chat) - Jumbo1, Mar 4, 15:45:02
  - First thing I tried. (n/m) (General Chat) - malkybarkid, Mar 4, 15:47:08
    - Tech 101. Obviously he’d have tried that (n/m) (General Chat) - Old Git, Mar 4, 15:53:54
- .... (General Chat) - KetteringRyu, Mar 4, 15:41:36
  - Tried that - still splits at pre-defined page break. Played with breaks as well and (General Chat) - malkybarkid, Mar 4, 15:44:15
  - Or next to it is "breaks" so have a tinker with that (n/m) (General Chat) - KetteringRyu, Mar 4, 15:42:21
- Mate, corona beer is killing people and this is all you care about? (n/m) (General Chat) - Charles21, Mar 4, 15:37:53
  - At the moment, yes. (n/m) (General Chat) - malkybarkid, Mar 4, 15:39:37
    - what you can do is go to the Workbook View in the view tab then (General Chat) - Worzel Scrimmage, Mar 4, 15:54:43

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.