Sorting a DVD list in Excel that spans multiple columns?

[Bruck]

Lets say you are making a spreadsheet of your dvd collection for printing purposes and you want 5 movies across on the page, so you make your list of column A row 1 - 40 and then you start again in B 1 - 40 etc. Is there a way to sort this? I don't do this cause I think its a mess, but my boss does this and is wondering if he can sort in alphabetical order without uncutting up the sheet and then re-cutting it back to 5 columns.

My guess is that its inherintly impossible based on the way the spreadsheets handle data, they do not expect you to carry over to another column.

 

[MustISO]

Why not use DVDProfiler or Movie Manager? Something made for this sort of thing.

Excel may be able to do it but another way to do it would be to list all the DVD's in column A and sort. Then break up the list into four columns for printing.

 

[warcrow]

...are those proggy's free?

 

[Blayze]

DVDProfiler has a free version. Never used Movie Manager.

 

[MustISO]

DVDprofiler is all you really need. Great program, very easy to use. As Blayze said, it's free for the basic version. The paid version gives you hi-res scans of the covers (who needs that).

 

[PowerEngineer]

Originally posted by: MustISO
Why not use DVDProfiler or Movie Manager? Something made for this sort of thing.

Excel may be able to do it but another way to do it would be to list all the DVD's in column A and sort. Then break up the list into four columns for printing.

I'd go a step further by build a print template. Keep the complete list of DVDs in a single column on the first sheet (so that you can add/edit/sort them as you described. Format the second sheet to look the way you want it for printing (i.e. that four colmns of 40 rows layout with what ever borders, shading, etc that you want. Put OFFET (or maybe INDEX) formulas (that point to entries in the list on the first sheet...i.e. 1-40,41-80,81-120,121-160) in the columns and rows of the second sheet. That way the print sheet will change automatically as the list on the first sheet changes.

If you have more than 160 DVD's you'll need to either increment the OFFSET indicies by 160 to bring up the second page. There a bunch of ways you can do this. If you're comfortable with VisualBasic, you can easily write a macro to print out all pages through that template. Or you could write the whole thing in VisualBasic!

😀

Good luck

 

[randomlinh]

is there any other software out there besides these two things? Excel works for my needs minus the publishing to web part. All I need is alternating colored rows and i'd be set

 

[WW]

Originally posted by: lnguyen
is there any other software out there besides these two things? Excel works for my needs minus the publishing to web part. All I need is alternating colored rows and i'd be set

alternating colored rows can be done with conditional formatting

select the rows you want, FORMAT > CONDITIONAL FORMATING

in the first drop down select "Formula Is" and in the formula box enter =MOD(ROW(),2)=0

then go to the format button, and patterns and pick whatever color you want

 

[WW]

as for the original question...snake columns in excel...

wouldn't it just be easier to keep the list in Word? or one long list in excel that you could simply copy into word, and format columns?

If you wanted to get all fancy, you could write an excel macro that loads word, does the column formatting and prints it...