Thread: How to Print?
View Single Post
Old 05-13-2010, 10:03 PM   #7
speakingtohe
Wizard
speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.
 
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
Steps for 2 column printout in excel 2007 (calibre CSV catalogue)
  1. Delete columns C-O by clicking on C in top row and then holding shift key scroll over and click on O
  2. Right Click in selection and click delete
  3. Do same for last 4 columns(now D-G) and then first column A
  4. Click on the 1 by authors and delete row
  5. Click small box by A to select all (if you don't select all it will only sort one column and then everything is mixed up)
  6. Click data in top toolbar and then click sort
  7. Sort by column A

You should have a reasonable 2 column printout at this point.
Of course excel has all kinds of printing options as well so you can make it pretty if you wish
Hope this helps

Last edited by speakingtohe; 05-13-2010 at 10:06 PM.
speakingtohe is offline   Reply With Quote