Thread: viewing data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default viewing data

Click Window in the menu and a select New Window. I opens another copy of
the workbook and assigns the window the filename followed by a colon plus an
incremental number. Repeat as needed until you have all windows accounted
for. You can then set each window to view a different worksheet, or the same
worksheet in 2 different windows showing two different areas.

When done, click the Close Window button on the right side of the menu bar.
Repeat for each window.

Hope this helps


--
Kevin Backmann


"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?