Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Multiple Sheets from Same Workbook
Recently I learned how to view multipel sheets from teh same workbook. But
now every time I open that workbook the multiple sheets still open. How do I close the multiple sheets? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Multiple Sheets from Same Workbook
close by the x in the topr right corner. When you close the last one it'll
prompt for saving. Bob Umlas Excel MVP "CJN" wrote in message ... Recently I learned how to view multipel sheets from teh same workbook. But now every time I open that workbook the multiple sheets still open. How do I close the multiple sheets? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Multiple Sheets from Same Workbook
Hi,
Actually my question is that how can i see multiple sheets in the same workbook can you please explane for me how is it i am using Excel 2003 Thanks, -- Farhad Hodjat "Bob Umlas" wrote: close by the x in the topr right corner. When you close the last one it'll prompt for saving. Bob Umlas Excel MVP "CJN" wrote in message ... Recently I learned how to view multipel sheets from teh same workbook. But now every time I open that workbook the multiple sheets still open. How do I close the multiple sheets? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Multiple Sheets from Same Workbook
From the menu bar, click:
<Window <New Window Now look at the name of your WB in the title bar. You'll see that the name has a suffix of ":2", Name:2 Now, click: <Window <Arrange, And choose which configuration you would like to view your sheets. After you <OK, you'll see 2 copies of whichever sheet was active at the time you activated the feature. Now, simply click on either one and change sheet number or change views. You can repeat the <Window <New Window to open additional views as you wish. When you're done, you can, <Ctrl <W to close the extra copy. If you opened multiple copies, click <Ctrl <W as many times as necessary, until there are *no more* copy numbers appended to the WB name in the title bar. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Farhad" wrote in message ... Hi, Actually my question is that how can i see multiple sheets in the same workbook can you please explane for me how is it i am using Excel 2003 Thanks, -- Farhad Hodjat "Bob Umlas" wrote: close by the x in the topr right corner. When you close the last one it'll prompt for saving. Bob Umlas Excel MVP "CJN" wrote in message ... Recently I learned how to view multipel sheets from teh same workbook. But now every time I open that workbook the multiple sheets still open. How do I close the multiple sheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
Viewing Two Sheets within One Workbook | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Viewing multiple rows of worksheets in a workbook | Excel Discussion (Misc queries) | |||
Use the same name on multiple sheets in same workbook | Excel Discussion (Misc queries) |