Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
how to hide section of worksheet based on a condition (e.g. tick . | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |