Thread: viewing data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MrAcquire MrAcquire is offline
external usenet poster
 
Posts: 62
Default viewing data

It sounds like you want to freeze the panes with the names in column A and
your data in columns B through whatever. Assuming you have a header row in
row 1 and your names in column A, position your cursor in cell B2 and click
Window - Freeze Panes. Now you can scroll right to your heart's content (it
is, after all, Valentine's Day), and your names will continue to show in the
leftmost column.

"pattyf" wrote:

I'm not sure I'm going to make sense with this question, but here it goes:

I have a spreadsheet with data on multiple subjects for multiple people. Is
there a way to freeze the window, or split the document, in multiple places
so I can see each subject and scroll through the names within each subject?