Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a table within a large worksheet
I need to install a reference list, showing a list of data of 30 - 50 lines
that must be visible at all times while scrolling through the worksheet and also on a printout of various parts of the worksheet. I have tried a text box but the formatting does not hold when trying to input and space new data. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a table within a large worksheet
If you list is in column A then select B2 and choose Windows, Freeze panes
(xl2003) HTH Peter "TonyH" wrote: I need to install a reference list, showing a list of data of 30 - 50 lines that must be visible at all times while scrolling through the worksheet and also on a printout of various parts of the worksheet. I have tried a text box but the formatting does not hold when trying to input and space new data. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a table within a large worksheet
Right now I have a text box across the top on the worksheet that is
(rowheight) 143 and within this box I have 33 lines of text that represents oven temperatures. The problem is the text is arranged in 4 rows that i modify in xl2007 but is read by the operators on machines running xl2003. When I add new data the formatting of the rows goes all over the place on the xl2003 versions and the operators cannot make out the oven and the corresponding temps. Thanks for your suggestion Bill but as you can see the problem I have is quite aggravating and is compounded with the print outs are also not right. "Billy Liddel" wrote: If you list is in column A then select B2 and choose Windows, Freeze panes (xl2003) HTH Peter "TonyH" wrote: I need to install a reference list, showing a list of data of 30 - 50 lines that must be visible at all times while scrolling through the worksheet and also on a printout of various parts of the worksheet. I have tried a text box but the formatting does not hold when trying to input and space new data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comments at End of Large Table | Excel Discussion (Misc queries) | |||
How do I link information from a large table into new table | Excel Worksheet Functions | |||
Inserting row in 1 worksheet and updating a different row in another worksheet | Excel Discussion (Misc queries) | |||
Pivot Table Too Large? | Excel Discussion (Misc queries) | |||
Large increase in document file size after inserting jpeg | Excel Discussion (Misc queries) |