Excel printing

  kimtrnc 05:04 22 May 2009
Locked

I have been asked to help with a local charity library. There are approx 10,000 books, which need updating/removing regularly. Handling the data is not a problem - but how can I print alternate pages (approx 300) please? May also need to alternate margins, but I can manage that, I hope.....
TIA
Kim

  wiz-king 07:18 22 May 2009

What version Of Excel are you using?

  kimtrnc 07:50 22 May 2009

Wiz King - OFFICE 97. Thanks

  Picklefactory 08:02 22 May 2009

Can you not do that via your printer software. I have HP at work and Epson at home, and on one I can select either odd or even page numbers to print, and on the other I can select to print both sides (Printer is NOT duplex), so it only prints odds and then requests the paper replacing other way up to print evens.
Is that an option at all?

  kimtrnc 09:28 22 May 2009

Picklefactory, you got me all excited there! However, my laserjet 1000 does not support this function, and all HP can suggest is upgrading the printer to a newer model......what a surprise!
Thanks anyway

  Picklefactory 13:01 22 May 2009

It can be done within Excel, but I think it would require some VBA. I'll see what I can find, but someone will probably be along before I get there, and with a better answer than I'll find anyway.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique