View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I view more than one tab at a time, within a given workshee

Window|New Window
will create another window into that workbook
Window|Arrange (horizontal/vertical/tiled???)
(and check that windows of active workbook if you want)

(You can select any worksheet in any window--even the same worksheet and view
different locations.)


And when you're tired of this, select a window to close and hit ctrl-w to close
it.

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

JoeOvercoat wrote:

How do I view more than one tab at a time, within a given worksheet, without
opening copies of that worksheet? Neither splitting the window nor freezing
panes appear to provide this function.


--

Dave Peterson