J
Jerri1031
Hello:
Unfortunately I am going to make this sound more difficult than I should
and I apologize for that fact up-front. I got stuck trying to create a
template in Excel.
I burn many cd's with identical song lists, place them in cd sleeves (not
the larger cases), and mail them. Paper size that fits a sleeve is approx.
4.2" width by 4.5" length --- the four identical lists can fit onto one piece
of regular letter paper with custom margins: currently I have it set up to
print with no header or footer; "0.25" for top and bottom; "0.12" for right
and left. Nothing fancy for borders, pictures, designs, etc.
Note: most of these CD's do not have many songs (avg. is 6 songs per cd):
Ideally I would like a template that:
I can type the title of CD on top [should this be a header?].
Below it would be the list of songs:
Track number (possibly automatically populate?)
Name of song
[Possibly a third column for length of song but not necessary]
I would like a to fit each song on one line instead of it going onto a
second one but sometimes that is not practical
Bottom of list: space for notes if necessary; one or two lines [footer?]
Could a template automatically change the size of the font depending upon
how much space is used?
-- I've tried to write the description multiple times but above is the best
I can do and I apologize for that fact (especially since all I am trying to
get is four boxes -- almost squares -- on one sheet of paper!) Any help with
this will be greatly appreciated, especially by the recipients of the cd's,
since my handwriting is as bad as my communication skills. === Be well, -
Jerri
Unfortunately I am going to make this sound more difficult than I should
and I apologize for that fact up-front. I got stuck trying to create a
template in Excel.
I burn many cd's with identical song lists, place them in cd sleeves (not
the larger cases), and mail them. Paper size that fits a sleeve is approx.
4.2" width by 4.5" length --- the four identical lists can fit onto one piece
of regular letter paper with custom margins: currently I have it set up to
print with no header or footer; "0.25" for top and bottom; "0.12" for right
and left. Nothing fancy for borders, pictures, designs, etc.
Note: most of these CD's do not have many songs (avg. is 6 songs per cd):
Ideally I would like a template that:
I can type the title of CD on top [should this be a header?].
Below it would be the list of songs:
Track number (possibly automatically populate?)
Name of song
[Possibly a third column for length of song but not necessary]
I would like a to fit each song on one line instead of it going onto a
second one but sometimes that is not practical
Bottom of list: space for notes if necessary; one or two lines [footer?]
Could a template automatically change the size of the font depending upon
how much space is used?
-- I've tried to write the description multiple times but above is the best
I can do and I apologize for that fact (especially since all I am trying to
get is four boxes -- almost squares -- on one sheet of paper!) Any help with
this will be greatly appreciated, especially by the recipients of the cd's,
since my handwriting is as bad as my communication skills. === Be well, -
Jerri