FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -While multiple sheets are selected, you can modify all of the selected sheets by making changes to one of them. Functions can be entered only by typing them directly into a cell.

Detailed explanation-2: -To edit the same cell in multiple sheets, simply hold down the Ctrl key while you click on the sheets you want to edit. Then, when you make your changes, they will be applied to all of the selected sheets. This can be a huge time saver if you need to make the same change in many different sheets.

Detailed explanation-3: -View multiple sheets in one workbook Open the workbook that you want to view. On the Window menu, click New Window. Switch to the new window, and then click the tab for the sheet that you want to view. Repeat steps 2 and 3 for each sheet that you want to view.

Detailed explanation-4: -If you group a set of worksheets, any changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets. If you want to create, for example, standard tables or calculations on a large number of worksheets, grouping can save you a lot of time.

Detailed explanation-5: -On the Tools menu, click Share Workbook, and then click the Editing tab. Click to select the Allow changes by more than one user at the same time check box, and then click OK.