The worksheets (or tabs) in an Excel workbook are a nearly indispensable tool for organizing data. (I know some of you remember when tabs were a new feature.) But how many times have you repeatedly jumped back and forth between tabs trying to compare information? There’s a much better way. You can actually show both (or several) at the same time.
Go to the View tab on the ribbon and click the New Window button. Depending on how your windows are arranged it may look like nothing happened, but Excel will open the same workbook in a new window. Now click the Arrange All button (right next to New Window) and choose how you want your windows arranged. Now you can select a different tab in each window. No more jumping back and forth.
You can even enter or edit data in either window, and all windows will automatically be updated.
