FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Group selected worksheets Press and hold down the Ctrl key, and click the worksheet tabs you want to group. Tip: If you want to group consecutive worksheets, click the first worksheet tab in the range, press and hold the Shift key, and click the last worksheet tab in the range.

Detailed explanation-2: -A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.

Detailed explanation-3: -On the Data tab, in the Outline group, click Group. Then in the Group dialog box, click Rows, and then click OK. The outline symbols appear beside the group on the screen. Tip: If you select entire rows instead of just the cells, Excel automatically groups by row-the Group dialog box doesn’t even open.

Detailed explanation-4: -By keyboard: First, press F6 to activate the sheet tabs. Next, use the left or right arrow keys to select the sheet you want, then you can use Ctrl+Space to select that sheet. Repeat the arrow and Ctrl+Space steps to select additional sheets. Right-click a sheet tab, and then click the Select All Sheets option.