A ahhhmed Member Jun 2, 2012 #1 Hi all, Is it possible to display two worksheets from the same workbook at the same time so that we view the changes in one worksheet when we enter data in the other? How can this be done?
Hi all, Is it possible to display two worksheets from the same workbook at the same time so that we view the changes in one worksheet when we enter data in the other? How can this be done?
N NARAYANK991 Excel Ninja Jun 2, 2012 #2 Hi , Click on View -> New Window. Click on Arrange All. Select Vertical. Check the Windows of active workbook checkbox. Click on View Side by Side , if you want to view the same area in both the worksheets. Click on Synchronous Scrolling , if you need it. Narayan
Hi , Click on View -> New Window. Click on Arrange All. Select Vertical. Check the Windows of active workbook checkbox. Click on View Side by Side , if you want to view the same area in both the worksheets. Click on Synchronous Scrolling , if you need it. Narayan
Hui Excel Ninja Staff member Jun 3, 2012 #3 You can also use Freeze Frames and Split to achieve different views of the same sheet Access from the View Ribbon
You can also use Freeze Frames and Split to achieve different views of the same sheet Access from the View Ribbon