View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default 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.