- Selecting all sheets Deselect sheets Deselecting a selected sheet is a very simple process. The following table shows you the deselect methods for various selections. SN Selection Type Deselect process Single Sheet Click on any unselected sheet Multiple continous sheets Click on any unselected sheet Multiple non- continous sheets Click on any unselected sheet All sheets Click on any sheet To deselect the already selected sheets, Right-click → Deselect All Sheets option from the pop-up menu is selected. .
– Renaming Worksheets The default name of a new sheet is Sheet-n, where n is a number. There are two methods to give a more meaningful name to a sheet. Method : • Double-click on a Sheet in which you want rename • A small “Rename Sheet” box is appears as shown in Figure . Figure.
. Rename Sheet dialog box • Type a new name and click “OK” button. Method : • Right-click on a sheet tab and choose Rename Sheet option from the pop-up menu now. • Now Rename Sheet dialog box appears and type a new name and then click on ok button.
Sheet names must start with either a letter or a number or some special characters like &,!,@ etc. Attempting to rename a sheet with an invalid name will produce an error message. Right -click on a sheet Rename box with default name Type a New Name here Figure . Renaming a sheet .
. – Inserting and Deleting Worksheets When you create a new worksheet, three sheets are there by default. If needed, one or more new worksheets can be added or deleted. .
. – Inserting Worksheets There are different ways to insert a new sheet. Step : • Right-click on a sheet tab and choose Insert Sheet option from the pop-up menu now. (or) • Choose Insert → Sheet option from the menu bar.
(or) • Click the Enter Key between last sheet and horizontal scroll bar. Choose Insert → Sheet Click Insert Sheet Right Click or Figure . Inserting more sheets Step : • “ Insert Sheet ”