Posted by John Howells on 01/15/66 11:57

"Stan Brown" <the_stan_brown@fastmail.fm> wrote

> Would you care to share a sample file? Maybe I'm just stupid today,
> but I can't see how to do the formatting comfortably in Excel.

I tried to add an example here, but I don't think it got through.

Anyway, in this case the printable area is set for rows 1 to 42 and columns
A to O, with the row height at 12.5 and the column width at 8.71, except for
column H which is the spine, and 5.86 wide. For column H you select all the
cells in the printable area and "merge" them, and in "format cells" you set
the text rotation to -90 degrees, so that whatever goes in the spine area is
automatically printed vertically.

In my case got cells I10 to O20 merged to form a title space on the front
cover, with a 16pt font, and cells I28 to O33 merged for any other relevant
information, such as the original source, with a 12pt font. If I've got more
than one episode column B contains the episode number and column D contains
the title, which will automatically flow into columns E to G. I can make
column C narrower as long as another cell on the left of the spine area is
widened to compensate.

After that you've got the myriad options to handle cells available to
produce whatever format you want, within the limits that Excel allows. Of
course, you could not produce professional grade covers this way, but it
more than fits the OP's requirements.

John Howells

[Back to original message]