software

quot;column headingsquot; lt;column gt; wrote in
message ...
gt;

You don't. Excel has plenty of rows - using just one isn't a problem!
Thanks.. But then the row numbering is quot;taken upquot; by the title and the
quot;firstquot; row of data is numbered 2. Is there a way to avoid this? Also, how do
I designate this first row as a quot;Column Headingquot; so that it reprints on every
page?

quot;Stephenquot; wrote:

gt; quot;column headingsquot; lt;column gt; wrote in
gt; message ...
gt; gt;
gt;
gt; You don't. Excel has plenty of rows - using just one isn't a problem!
gt;
gt;
gt;

You could hide row and column headings and then in A2 add a formula of
=ROW(A1) and copy down. Colour the cells grey and voila.

Filegt;PAgeSetupgt;Sheet Rows to repeat as $1:$1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;column headingsquot; gt; wrote in
message ...
gt; Thanks.. But then the row numbering is quot;taken upquot; by the title and the
gt; quot;firstquot; row of data is numbered 2. Is there a way to avoid this? Also, how
do
gt; I designate this first row as a quot;Column Headingquot; so that it reprints on
every
gt; page?
gt;
gt; quot;Stephenquot; wrote:
gt;
gt; gt; quot;column headingsquot; lt;column gt; wrote in
gt; gt; message ...
gt; gt; gt;
gt; gt;
gt; gt; You don't. Excel has plenty of rows - using just one isn't a problem!
gt; gt;
gt; gt;
gt; gt;
You have to create your own numbering or use a real database like access or
something (you can hide the default headers under toolsgt;optionsgt;viewgt; and
uncheck row amp; column headers)
you can put this in row 2 and copy down

=ROW()-1

2. Do filegt;page setup, select sheet and rows to repeat at top and if you are
using row 1 use

$1:$1--

Regards,

Peo Sjoblom

quot;column headingsquot; gt; wrote in
message ...
gt; Thanks.. But then the row numbering is quot;taken upquot; by the title and the
gt; quot;firstquot; row of data is numbered 2. Is there a way to avoid this? Also, how
do
gt; I designate this first row as a quot;Column Headingquot; so that it reprints on
every
gt; page?
gt;
gt; quot;Stephenquot; wrote:
gt;
gt; gt; quot;column headingsquot; lt;column gt; wrote in
gt; gt; message ...
gt; gt; gt;
gt; gt;
gt; gt; You don't. Excel has plenty of rows - using just one isn't a problem!
gt; gt;
gt; gt;
gt; gt;