By Gaspar Desnoyers at July 31 2019 02:33:52
Microsoft Excel provides several methods for linking values across worksheets or across workbooks. Which method you choose will depend on your desired end result. This article will review the pros and cons of each method.
One of the features of Excel that is often overlooked is working with grouped worksheets. When you group the worksheets within a workbook, you can perform operations to several worksheets at one time. This eliminates the necessity of doing the same operation over and over to different worksheets. To group worksheets which are next to each other in the workbook: Click on the sheet tab for the first worksheet. Hold the Shift Key. Click on the last sheet tab to be included in the group. To group worksheets which are not right next to each other: Click on the sheet tab for the first worksheet. Hold the Control Key. Click on each sheet tab to be included in the group