Home |
Search |
Today's Posts |
#1
|
|||
|
|||
There is no way to view multiple sheets from one workbook
It would be nice if there was the ability to view multiple sheets from the
same workbook. Currenlty, you are forced to work on each sheet individually, but often I'd like to be working on Sheet 1 while viewing Sheet 2 - of the same workbook (as an example). A Work Around? Yes, I have one: create a new worksheet, copy the sheet you'd like to view into this new worksheet. |
#2
|
|||
|
|||
You can create new windows (Window New Window) and then
arrange them (Window Arrange) so you can view multiple sheets of the same wb simultaneously. HTH Jason Atlanta, GA -----Original Message----- It would be nice if there was the ability to view multiple sheets from the same workbook. Currenlty, you are forced to work on each sheet individually, but often I'd like to be working on Sheet 1 while viewing Sheet 2 - of the same workbook (as an example). A Work Around? Yes, I have one: create a new worksheet, copy the sheet you'd like to view into this new worksheet. . |
#3
|
|||
|
|||
k,
The actual way to do this is to use View | New Window then View | Arrange.... windows of activeworkbook checked, then horizontal or vertical. HTH, Bernie MS Excel MVP "kstub" wrote in message ... It would be nice if there was the ability to view multiple sheets from the same workbook. Currenlty, you are forced to work on each sheet individually, but often I'd like to be working on Sheet 1 while viewing Sheet 2 - of the same workbook (as an example). A Work Around? Yes, I have one: create a new worksheet, copy the sheet you'd like to view into this new worksheet. |
#4
|
|||
|
|||
kstub
You gotta be careful when stating "there is no way" when posting to these Excel groups<g Gord Dibben Excel MVP On Fri, 17 Dec 2004 10:01:01 -0800, "Jason Morin" wrote: You can create new windows (Window New Window) and then arrange them (Window Arrange) so you can view multiple sheets of the same wb simultaneously. HTH Jason Atlanta, GA -----Original Message----- It would be nice if there was the ability to view multiple sheets from the same workbook. Currenlty, you are forced to work on each sheet individually, but often I'd like to be working on Sheet 1 while viewing Sheet 2 - of the same workbook (as an example). A Work Around? Yes, I have one: create a new worksheet, copy the sheet you'd like to view into this new worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
how do i switch between multiple sheets in the same workbook (key. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Updating sheets within a workbook | Excel Discussion (Misc queries) |