CHAPTER Functions and Chart SpreadSheet Unit III If you want unselect the selection, click on any unselected sheet. . . .
Selecting multiple continous sheets The following steps should be followed to select multiple continuous sheets. • Click on the sheet tab for the first desired sheet. • Hold down the Shift key and click on the last sheet tab . All the tabs between these two sheets will be selected and will turn white.
Any actions that you perform will now affect all highlighted sheets. For example, if you want to select from sheet1 to sheet5 . Do the following, Step : Click on Sheet1 to select first sheet Step : Press and hold down “Shift” key and Click on the Sheet i.e., last sheet All the sheets between Sheet1 and Sheet5 will be selected and their sheet colour turns to white as given in the Figure . and any actions that you perform will now affect all highlighted sheets.
Selected sheets Unselected sheets Figure . Multiple continous sheets If you want to unselect the selection, click on any unselected sheet. . .
Selecting multiple non-continous sheets. If you want to select multiple non-continuous sheets the following steps will be followed. • Click on any sheet, • Hold down the Ctrl key, • Click another sheet. Ctrl + Click on any sheet is used to select multiple sheets.
Selected sheets tab colour turns into “White”. For example, if you want to select Sheet1, Sheet3 and Sheet ; Step : Click on Sheet1 and then Step : Hold down the Ctrl key Step : Click on Sheet4 , Sheet6 and Sheet8 . Selected Sheets colour becomes “White” and any actions that you perform will now affect all Selected sheets. Multiple non-continuous Sheet1, Sheet4, Sheet6 and Sheet8 Figure .
Selecting Multiple non-continous sheets . Selecting all sheets To select all sheets, Right-click any one of the sheet tabs and choose Select All Sheets option from the pop-up menu. Right Click any Sheet Click "Select All Sheets" Figure . (a) - Selecting all sheets Total Sheets Selected Selected Sheets Figure .