View Multiple Worksheets in Excel To view multiple worksheets at a time, follow the steps below. 1. Open a workbook. 2. Click “New Window” on the View tab. Excel opens another copy of the same workbook. 3. Now, click “Arrange All” on the View tab. 4. Select any orientation you like from the dialog box. … Read more

Consolidate Data in Excel Consolidation in Excel is a powerful way to do some simple mathematical operations from two or more worksheets from either a workbook or separate workbooks. To show how to consolidate data in Excel, let’s calculate the sum from three individual Excel files by following the steps below. 1. First of all, … Read more

Group Excel Worksheets In Excel, grouping worksheets will enable the user to add or delete data in multiple worksheets at the same time. Follow the steps below to group worksheets. 1. Hold down CTRL and click the sheets from the sheet tab that you like to group together. For instance, we click Sheet1 and Sheet2. … Read more