Learn to take advantage of Excel's ability to link and synchronize multiple worksheets in the same workbook.
If most of your Excel workbooks contain only one worksheet, you are losing the power and flexibility of using several worksheets in a single workbook. By storing multiple Excel worksheets in the same workbook, you can link them all to save time and effort. You can make the same data and format changes in all your worksheets at once. You can create formulas in a worksheet that refer to data in another sheet. And if any data changes in a worksheet, it also changes in any linked worksheet.
In this tutorial, I'm using the latest version of Excel, courtesy of Office 365, but the information offered will work similarly in the last two editions of Excel. To illustrate the examples, I created a workbook with five different sheets for selling products. The first four Excel spreadsheets show results from different regions: North, South, East and West. The fifth worksheet is for the totals of each of the other sheets. Each sheet has columns for the first six months of the year and rows for four different products.
MORE INFORMATION: Prices and features of Office 365 Consumer
The first thing we are going to do is to format the key rows and columns on the five sheets. But instead of formatting each sheet individually, we will select them all and format them in one shot.
To select more than one sheet, we will use the well-known Ctrl or Shift maneuver. It can be on any sheet for this to work. To select non-contiguous sheets, such as the first sheet, the second sheet and the fourth sheet, hold down the Ctrl key and click on the tab of the first sheet, then the second sheet and then the fourth sheet. To select several contiguous sheets, hold down Shift, click on the tab of the first sheet you want to include, and then click on the tab on the last sheet. In this case, we want to select the five sheets of the workbook. Hold down Shift, select the first sheet tab and then select the last sheet tab. Now all sheets are selected ( Figure A ).
Let's change the format. Select the active cells in the top row. Apply any format of your choice, such as a specific style or combination of attributes (font, size, bold, italic, color, etc.). Do the same with the cells in the first column that contain the names of the products ( Figure B ).