Editing multiple sheets simultaneously:

Take the example of our monthly budget for each month for which we use a worksheet.

We need 12 sheets (one sheet for each month of the year ). By default, a new Excel file has 3 sheets, so we create 9 more new sheets (see Excel 2007 Lesson 6, Excel 2010 Lesson 9 ). Next, we rename the pages with the months of the year (see Excel 2007 Lesson 6, Excel 2010 Lesson 9 ) (1)

Click on the tab for “Jan”, press the “Shift” key and keep it pressed while you click on the “dec” tab. Now all sheets are selected and you can see this on the white background of the tabs (2).

With all the sheets selected, format the data in cells B2 to D22 of the first sheet, (Of course, you can rearrange your sheets later in this example).

The formula for cell D22 = SUM (D2: D4)-SUM (D6: D22)

If you have finished formatting the layout, right-click on a sheet tab and select “Ungrouping sheets” (1). We now have 12 identical sheets.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats