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.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1979) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Write out a check and you need to include the digits for the amount of the check and the value of the check written out in ...
Discover MoreOne common type of workbook used in offices is one that contains a single worksheet for each month of the year. If you need ...
Discover MoreEver notice that if someone types in all CAPS, it appears they are shouting? If your worksheets include lots of text, you may ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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 © 2017 Sharon Parq Associates, Inc.
Comments