ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I view more than one tab at a time, within a given workshee (https://www.excelbanter.com/excel-discussion-misc-queries/108252-how-do-i-view-more-than-one-tab-time-within-given-workshee.html)

JoeOvercoat

How do I view more than one tab at a time, within a given workshee
 
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

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

JoeOvercoat

Window-New Window How do I view more than one tab at a time...
 
Thank you. Two or more fully active windows appear. I can use the mouse to
build formulas across two or more tiled windows.

"Dave Peterson" wrote:

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



All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com