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" wrote in message
...
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" ha scritto nel messaggio


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)
----------------------------------------------------------------------------------------