Excel page formatting and column wrapping ?

H

hyoomen

An interesting conundrum for anybody who is up to the challenge.

Essentially what I'd like to do is have a small code book printed fro
an Excel spreadsheet. Each page would come out looking roughly like
this' (http://www.licious.net/misc/spreadsheetcapture2.gif) .
Currently all of the formatting is being done by hand where each pag
is hand-formatted with extra cells near the bottom (for futur
additions) and each half of the page being divided up into two sets o
columns. Basically the columns snake from top to bottom, left t
right. Then the next page is done in the same fashion, leaving page
that look something like ' this
(http://www.licious.net/misc/spreadsheetcapture1.gif) .

What I would prefer to have is a set of columns (and possibly some V
or macros) that would autowrap up and to the right to do the same thin
as what is currently hand-formatted.

Is it possible to have Excel do this? If not, could I do it with
mixture of Excel and Word? It seems odd that there isn't a mor
elegant solution.

Thanks in advance
 
H

hyoomen

Anybody an expert with print formatting Excel? I remember coming acros
a few articles related to column snaking in past research, but I wasn'
sure if it could quite accomplish what I'm looking for.

The best way I can describe it is this: in print design softwar
(Quark, Pagemaker, etc.) you can create a series of text boxes that ar
linked one to the other so that when text fills up one entire box, i
spills over to the next section. Is it possible to do this same thin
with Excel (either with Excel and another program, two Exce
spreadsheets, or any other way)
 
D

Dave Peterson

Excel doesn't make a very good word processor.

Maybe you could play around with bringing a subset of your data over to MSWord.

Format|Columns to have it snake.

And Table|Heading Row Repeat.

But in my short testing, I couldn't put a page break where I wanted. The table
had to be contiguous for the headings to repeat to work.
 
H

hyoomen

Thanks. I've played around with this a fair amount without muc
success. I'll keep trying.

I researched other spreadsheet software and it is shocking that perhap
NO package offers this feature which seems so basic in word processin
software
 
Top