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: -Click the Insert Worksheet tab at the bottom of the screen. Press and hold the CTRL key, and then click Sheet1, Sheet2, and so on till you finish selecting all your worksheets.

Detailed explanation-5: -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.