Written by Allen Wyatt (last updated August 8, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
If you have worksheets that are very similar in nature, you may like to work with them side-by-side on the screen at the same time. This makes it easy to examine both worksheets for differences or for other reasons. It can be a bother, however, to scroll down at the same rate in both worksheets. First you have to scroll in one window, then in the other.
As with most tedious tasks, you can automate the process a bit. Consider the following macros:
Sub myScrollDown()
ActiveWindow.SmallScroll Down:=1
ActiveWindow.ActivateNext
ActiveWindow.SmallScroll Down:=1
ActiveWindow.ActivatePrevious
End Sub
Sub myScrollUp()
ActiveWindow.SmallScroll Up:=1
ActiveWindow.ActivateNext
ActiveWindow.SmallScroll Up:=1
ActiveWindow.ActivatePrevious
End Sub
If you add these to a workbook, and then assign them to a toolbar button or a shortcut key, you can scroll through both workbooks at the same rate. The SmallScroll method is used to move down one row at a time through a window. If you want to scroll a page at a time, simply replace all instances of SmallScroll with the LargeScroll method.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1979) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
Ever want to know how many cells in a worksheet (or a selection) are shaded in some way? You can create a handy little ...
Discover MorePaste Special is a great tool that allows you to modify the values in a range of cells in your worksheets. You may want, ...
Discover MoreOne common type of workbook used in offices is one that contains a single worksheet for each month of the year. If you ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-08-08 13:48:18
Ron S MVP
Web searches often find this "obsolete" article. It would not hurt to have a link to an updated version of this article, especially since the ribbon uses a synonym of simultaneous for the command, ie
Sychronous Scrolling (ribbon)
In View tab > Window group there are commands for “View Side by Side” and after that is enabled “Sychronous Scrolling”
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments