Mundane News

Page may contain affiliate links. Please see terms for details.
Excel is evil.

Indeed. I need to make a simple table and print it on Din A5, double sided. In theory this should mean:

  1. Make table in Excel
  2. Print

So far it has required four programmes:

  1. Make table in Excel: this of course takes ages because Excel does its own thing.
  2. Try to make second Table; nothing doing.
  3. New Excel file, copy and paste "page 1" into new file
  4. Type new data into "page 2" file
  5. Try to print "page 1" Excel takes this to mean "Spread table over three sheets of A4"
  6. Cut and paste Page 1 into Word (Programme 2). Two tables onto one page of Word.
  7. Word has nervous breakdown when I attempt to add title
  8. "Print" Word file as a PDF using PDF24 (Programme 3)
  9. Open "Gimp" photo editing (Programme 4)
  10. Paste 'pdf' into Gimp, add company Logo, title et, c. Set up page so there's two Din A5 Sheets to one Din A4
  11. Export as PDF
  12. Repeat for "Page 2"
  13. Merge two PDF's on PDF 24, print as a double sided sheet.


PDF24 and Gimp performed flawlessly; the only issue now is that the result looks a bit like a picture, not as crisp as a word file would, and that I will have to go through all this faff again to edit the thing...
 
Last edited:

tyred

Squire
Location
Ireland
Quite cold this morning. If this continues I may have to do something really drastic like put on the heating :ohmy:
 
Cool, grey and very blustery here chez Casa Reynard.

Slept really well. Morning was spent with a friend, having a lovely walk with her dogs around the local playing fields and foot paths. But goodness is that wind cold when you're away from the shelter of the hedgerows. We did set the world to rights though, which is always a good thing, but I was glad to get back to the car. Brrrrrr! :cold:

I stopped by the book swap cupboard in the village on the way home and picked out a book by Elizabeth Moon. I enjoy some of her stuff e.g. The Serrano Legacy series, but the rest can be a bit hit-and-miss. Ergo if I don't like this one, it can go back in the cabinet.

Not sure what I'm doing this afternoon. I have various things that all need my attention.

Anyways, it is almost time for luncheon.
 

mybike

Grumblin at Garmin on the Granny Gear
Indeed. I need to make a simple table and print it on Din A5, double sided. In theory this should mean:

  1. Make table in Excel
  2. Print

So far it has required four programmes:

  1. Make table in Excel: this of course takes ages because Excel does its own thing.
  2. Try to make second Table; nothing doing.
  3. New Excel file, copy and paste "page 1" into new file
  4. Type new data into "page 2" file
  5. Try to print "page 1" Excel takes this to mean "Spread table over three sheets of A4"
  6. Cut and paste Page 1 into Word (Programme 2). Two tables onto one page of Word.
  7. Word has nervous breakdown when I attempt to add title
  8. "Print" Word file as a PDF using PDF24 (Programme 3)
  9. Open "Gimp" photo editing (Programme 4)
  10. Paste 'pdf' into Gimp, add company Logo, title et, c. Set up page so there's two Din A5 Sheets to one Din A4
  11. Export as PDF
  12. Repeat for "Page 2"
  13. Merge two PDF's on PDF 24, print as a double sided sheet.


PDF24 and Gimp performed flawlessly; the only issue now is that the result looks a bit like a picture, not as crisp as a word file would, and that I will have to go through all this faff again to edit the thing...

Why do you need to make a table in Excel, it is one big table. Then why make a new file when you could just add a new sheet? Excel has a good print menu which you should be able to make it print on one sheet.
 
Why do you need to make a table in Excel, it is one big table.

I had to format the table for what I wanted; eventually Excel and I came to a compromise: I agreed to stop trying to format it when it was almost how I wanted it, and in return Excel agreed to stop trying to insert 10000 line formulas.

Then why make a new file when you could just add a new sheet?

Because Excel wouldn't let me add a sheet without smegging up the format.

Excel has a good print menu which you should be able to make it print on one sheet.

Perhaps it was hiding.
 
Last edited:

postman

Squire
Location
,Leeds
Right i have catched up wiv all the jobs now i have just cut the lawn.As i sit here the sun has just shone on me through the conservatory.All is well with Postie.Oh and my very quiet next door neighbour has given me permission to take apples off her tree,and very nice they are too,i had one for lunch.
 
oopsie
loss of coolant 9-26-22.jpg
 
Indeed. I need to make a simple table and print it on Din A5, double sided. In theory this should mean:

  1. Make table in Excel
  2. Print

So far it has required four programmes:

  1. Make table in Excel: this of course takes ages because Excel does its own thing.
  2. Try to make second Table; nothing doing.
  3. New Excel file, copy and paste "page 1" into new file
  4. Type new data into "page 2" file
  5. Try to print "page 1" Excel takes this to mean "Spread table over three sheets of A4"
  6. Cut and paste Page 1 into Word (Programme 2). Two tables onto one page of Word.
  7. Word has nervous breakdown when I attempt to add title
  8. "Print" Word file as a PDF using PDF24 (Programme 3)
  9. Open "Gimp" photo editing (Programme 4)
  10. Paste 'pdf' into Gimp, add company Logo, title et, c. Set up page so there's two Din A5 Sheets to one Din A4
  11. Export as PDF
  12. Repeat for "Page 2"
  13. Merge two PDF's on PDF 24, print as a double sided sheet.


PDF24 and Gimp performed flawlessly; the only issue now is that the result looks a bit like a picture, not as crisp as a word file would, and that I will have to go through all this faff again to edit the thing...

:wacko:
 
Top Bottom