ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to view tiled Excel worksheets by locking rows for scrolling . (https://www.excelbanter.com/excel-worksheet-functions/6968-how-view-tiled-excel-worksheets-locking-rows-scrolling.html)

Ralph S Bryant

How to view tiled Excel worksheets by locking rows for scrolling .
 
Is there a way to set up tiled workbooks or worksheets which will scroll row
by row two or more sheets together? For example, one sheet is scrolled
down, while the other sheet follows in unison.

tjtjjtjt

Excel 2003 can do this:
Window | Compare Side by Side with
There is no way built-in way to do it in earlier versions.

tj

"Ralph S Bryant" wrote:

Is there a way to set up tiled workbooks or worksheets which will scroll row
by row two or more sheets together? For example, one sheet is scrolled
down, while the other sheet follows in unison.



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

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