Thread
:
How to hide parts of worksheet
View Single Post
#
4
Franz
Posts: n/a
"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)
----------------------------------------------------------------------------------------
Reply With Quote