Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Synchronous scrolling in all sheets of a wokbook.
I have a need to scroll (up and down) in any sheet of a workbook of excel and
then when I switch between sheets in the same workbook - I would like to find myself in the same place on the new sheet. Is this possible in anyones experience? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Synchronous scrolling in all sheets of a wokbook.
If you are using Excel 2007, go to View on Ribbon. Find Windows group and
click on View Side By Side. Make sure Synchronous Scrolling is pressed. Choose you required sheet. Both sheets will be open side by side. This would do the trick. In Excel 2003, Click Window -- New Window. Select the sheet you want to view. Click again on Window menu and choose Compare Sheet Side by Side. Make sure that Synchronous Scrolling button is click on Compare tool box. Hope this works for you... -- Sheikh Saadi "Oily Rag" wrote: I have a need to scroll (up and down) in any sheet of a workbook of excel and then when I switch between sheets in the same workbook - I would like to find myself in the same place on the new sheet. Is this possible in anyones experience? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Synchronous scrolling in all sheets of a wokbook.
---Sorry missed one step, Please see Caps in Excel 2007's area---
Also note, if you dont use New Window Option, rest will work for comparing two diffirent WorkSheets. If you are using Excel 2007, go to View on Ribbon. Find Windows group and click on View Side By Side. Make sure Synchronous Scrolling is pressed. ---CLICK ON NEW WINDOW---. Choose you required sheet. Both sheets will be open side by side. This would do the trick. In Excel 2003, Click Window -- New Window. Select the sheet you want to view. Click again on Window menu and choose Compare Sheet Side by Side. Make sure that Synchronous Scrolling button is click on Compare tool box. Hope this works for you... -- Sheikh Saadi "Oily Rag" wrote: I have a need to scroll (up and down) in any sheet of a workbook of excel and then when I switch between sheets in the same workbook - I would like to find myself in the same place on the new sheet. Is this possible in anyones experience? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Un-Synchronous Panes | Excel Worksheet Functions | |||
Auto-scrolling multiple sheets | Excel Worksheet Functions | |||
Split Wokbook | Excel Discussion (Misc queries) | |||
How do I NOT get synchronous scrolling in multiple panes in Excel | Excel Worksheet Functions | |||
Scrolling across multiple sheets? | Excel Discussion (Misc queries) |