How to hide parts of worksheet

I am using Excel 2000.

I have a form which covers the cells from A1 through I51. The information in
cells A1 through I6 is never edited and I would like to hide it, but this
information must print with the rest of the form.

The date in A1 to I6 is too much to put in a header. When I tried, it told
me it could only accept a maximum of 256 characters.

If I hide rows 1 thru 7, they won't print unless I unhide them each time
which is a huge hassle.

Is there a way that I can save the file so that each time it opens cell A7
is the top left visible cell, but if I print the file, it will still print
rows 1 thru 6??

Thanks for any help.
--
Jim

How about using a macro to print.

You could record a macro that unhides the rows, prints the worksheet, then
rehides the rows.



Jim wrote:
>
> I am using Excel 2000.
>
> I have a form which covers the cells from A1 through I51. The information in
> cells A1 through I6 is never edited and I would like to hide it, but this
> information must print with the rest of the form.
>
> The date in A1 to I6 is too much to put in a header. When I tried, it told
> me it could only accept a maximum of 256 characters.
>
> If I hide rows 1 thru 7, they won't print unless I unhide them each time
> which is a huge hassle.
>
> Is there a way that I can save the file so that each time it opens cell A7
> is the top left visible cell, but if I print the file, it will still print
> rows 1 thru 6??
>
> Thanks for any help.
> --
> Jim

--

Dave Peterson

One way that I hide data that is required in my worksheet, but I want to
prevent others from seeing it, is to format the font color to white. The
cell appears blank, but the value is there.

Dan

"Jim" <Jim@discussions.microsoft.com> wrote in message
news:8E0A6A13-BB1C-4324-BABC-B4F227CA3C81@microsoft.com...
>I am using Excel 2000.
>
> I have a form which covers the cells from A1 through I51. The information
> in
> cells A1 through I6 is never edited and I would like to hide it, but this
> information must print with the rest of the form.
>
> The date in A1 to I6 is too much to put in a header. When I tried, it told
> me it could only accept a maximum of 256 characters.
>
> If I hide rows 1 thru 7, they won't print unless I unhide them each time
> which is a huge hassle.
>
> Is there a way that I can save the file so that each time it opens cell A7
> is the top left visible cell, but if I print the file, it will still print
> rows 1 thru 6??
>
> Thanks for any help.
> --
> Jim

"Jim" <Jim@discussions.microsoft.com>ha scritto nel messaggio
8E0A6A13-BB1C-4324-BABC-B4F227CA3C81@microsoft.com

> I am using Excel 2000.
>
> I have a form which covers the cells from A1 through I51. The
> information in cells A1 through I6 is never edited and I would like
> to hide it, but this information must print with the rest of the form.
>
> The date in A1 to I6 is too much to put in a header. When I tried, it
> told me it could only accept a maximum of 256 characters.
>
> If I hide rows 1 thru 7, they won't print unless I unhide them each
> time which is a huge hassle.
>
> Is there a way that I can save the file so that each time it opens
> cell A7 is the top left visible cell, but if I print the file, it
> will still print rows 1 thru 6??

You can try using Freeze Panes from menu Window:

scroll down until your first row is row 7, then select cell B7 and tehn menu
window, Freeze Panes.
--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------