ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Scrolling in Excel (https://www.excelbanter.com/excel-worksheet-functions/24096-scrolling-excel.html)

DeTonya@sunbridgecapital

Scrolling in Excel
 
Is there a way to take an excel spreadsheet workbook, split it, and then be
able to do synchronous scrolling on the split windows? I'm trying to do this
without copying the data into a new worksheet.

Niek Otten

From the menu:

WindowSplit

Position the cursor where you want the split before issuing the command

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"DeTonya@sunbridgecapital"
m wrote in message
...
Is there a way to take an excel spreadsheet workbook, split it, and then
be
able to do synchronous scrolling on the split windows? I'm trying to do
this
without copying the data into a new worksheet.




bj

Try <Window<new window
you get two views of the same workbook that you can work with independantly.
What you change in one you change in the other, and you can delete one
without it doing anything to the other.
Note if you save with the extra window showing it will be there when you
reopen the file

"DeTonya@sunbridgecapital" wrote:

Is there a way to take an excel spreadsheet workbook, split it, and then be
able to do synchronous scrolling on the split windows? I'm trying to do this
without copying the data into a new worksheet.



All times are GMT +1. The time now is 04:08 AM.

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