In this video, I will show you how to view and compare two sheets side by side in Excel (in the same view).
This can be made possible by using the NEW Window functionality in Excel. When you use the New Window option, it creates an exact replica of the workbook.
This means that you have two exact same workbooks open at the same time. Now you can arrange these vertically and view these side by side.
You can also enable synchronous scrolling for each worksheet.
This is a great way to view and compare different sheets in the same Excel file, or view different parts of the dataset in the same view.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #Excelin2Minutes