Show header in cell

I want to be able to show my header in a cell of the associated spreadsheet?
Any ideas??
--
Thanks,
Darrin

Assuming the information you want as your header is in row 1 go to File>Page
Setup. Go to the Sheet tab and select the button next to "Rows to repeat at
top:" then click on row 1. Push Enter then click OK. If I understand your
question correctly this should give you the results you're looking for.

Regards,
Mike

"tonywig" <tonywig.1r016x_1119395127.8784@excelforum-nospam.com> wrote in
message news:tonywig.1r016x_1119395127.8784@excelforum-nospam.com...
>
> How about turning things around and having a value in a cell (or cells)
> on your worksheet that then forms the header for your report.
> I'm not sure myself but this thread seemed to work OK for someone else
> ...
>
> http://www.excelforum.com/showthread...ht=cell+header
>
> Hope this helps
>
>
> --
> tonywig
>
>
> ------------------------------------------------------------------------
> tonywig's Profile:
> http://www.excelforum.com/member.php...o&userid=18985
> View this thread: http://www.excelforum.com/showthread...hreadid=379847
>

I can't believe I didn't see that. You are the best!!!
--
Thanks,
Darrin


"James Malone" wrote:

> Assuming the information you want as your header is in row 1 go to File>Page
> Setup. Go to the Sheet tab and select the button next to "Rows to repeat at
> top:" then click on row 1. Push Enter then click OK. If I understand your
> question correctly this should give you the results you're looking for.
>
> Regards,
> Mike
>
> "tonywig" <tonywig.1r016x_1119395127.8784@excelforum-nospam.com> wrote in
> message news:tonywig.1r016x_1119395127.8784@excelforum-nospam.com...
> >
> > How about turning things around and having a value in a cell (or cells)
> > on your worksheet that then forms the header for your report.
> > I'm not sure myself but this thread seemed to work OK for someone else
> > ...
> >
> > http://www.excelforum.com/showthread...ht=cell+header
> >
> > Hope this helps
> >
> >
> > --
> > tonywig
> >
> >
> > ------------------------------------------------------------------------
> > tonywig's Profile:
> > http://www.excelforum.com/member.php...o&userid=18985
> > View this thread: http://www.excelforum.com/showthread...hreadid=379847
> >
>
>
>