On the View tab, in the Window group, click View Side by Side.Open both of the workbooks that contain the worksheets that you want to compare.View two worksheets of different workbooks side by side To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window. If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.Note This option is available only when View Side by Side is turned on. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.In the workbook window, click the worksheets that you want to compare.On the View tab, in the Window group, click New Window.View two worksheets in the same workbook side by side in Excel 2007, 2010, 2013 & 2016
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |