ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Display Multiple Worksheets (https://www.excelbanter.com/excel-worksheet-functions/229570-display-multiple-worksheets.html)

docfat

Display Multiple Worksheets
 
How can i display multiple worksheets within a file without opening a second
copy of a file and arranging windows?

Jacob Skaria

Display Multiple Worksheets
 
From View menu try the Split option.

If this post helps click Yes
---------------
Jacob Skaria


"docfat" wrote:

How can i display multiple worksheets within a file without opening a second
copy of a file and arranging windows?


docfat

Display Multiple Worksheets
 
I am using Excel 2003, SP 3. No View, "Split" option.
Also, on Tools, Options, View, no "split" option there either.

"Jacob Skaria" wrote:

From View menu try the Split option.

If this post helps click Yes
---------------
Jacob Skaria


"docfat" wrote:

How can i display multiple worksheets within a file without opening a second
copy of a file and arranging windows?


docfat

Display Multiple Worksheets
 
I believe I uncovered the answer:
right click on worksheet tab, click on "select all sheets"
Select Window from top menu, open "new window", then arrange all, making
sure to check "windows of active workbook"
then, when multiple sheets are visible, select a tab for each window.

"docfat" wrote:

I am using Excel 2003, SP 3. No View, "Split" option.
Also, on Tools, Options, View, no "split" option there either.

"Jacob Skaria" wrote:

From View menu try the Split option.

If this post helps click Yes
---------------
Jacob Skaria


"docfat" wrote:

How can i display multiple worksheets within a file without opening a second
copy of a file and arranging windows?


Jacob Skaria

Display Multiple Worksheets
 
Great. I am currently using 2007. I am sure this is in 2003 as well. Will
check and get back to you.

If this post helps click Yes
---------------
Jacob Skaria


"docfat" wrote:

I believe I uncovered the answer:
right click on worksheet tab, click on "select all sheets"
Select Window from top menu, open "new window", then arrange all, making
sure to check "windows of active workbook"
then, when multiple sheets are visible, select a tab for each window.

"docfat" wrote:

I am using Excel 2003, SP 3. No View, "Split" option.
Also, on Tools, Options, View, no "split" option there either.

"Jacob Skaria" wrote:

From View menu try the Split option.

If this post helps click Yes
---------------
Jacob Skaria


"docfat" wrote:

How can i display multiple worksheets within a file without opening a second
copy of a file and arranging windows?



All times are GMT +1. The time now is 02:58 AM.

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