Introduction of sheets in Excel
Sheet, Worksheet or Worksheet is a part of the hierarchy of Excel files that holds cells, data, formulas, charts and in general everything that we work with in Excel software and we will from now on and in this section We will call it a worksheet from the book.
Show the environment of Excel sheets
In recent versions of Excel, by default, a worksheet is created for each new file, but you can change its number. For this purpose, enter the File tab and go to the Options section and follow the steps according to the next image:
Due to the importance of Excel files, how to unprotect excel sheet and users can protect their data with a password.
But for any reason, you may not have access to the password, or you may have forgotten the password;
Changing a number of default sheets in Excel
Through the include this many sheets option, you can change the default number of worksheets in new Excel files. After changing, any new file you create will contain the number of sheets you want.
Manage sheets
Managing worksheets means changing their name, color, deleting or moving and their security settings. To make most of the changes on the worksheets, just right click on them.
Right click on the sheets
Insert
This option is used to insert a new worksheet.
Delete
This option is used to delete the worksheet. Of course, if you have only one worksheet, by clicking this option, you will encounter the following message, which means that an Excel file must have at least one visible worksheet. In the text of this message, we notice that even if there are other worksheets in this file but they are hidden, we still cannot delete the current worksheet unless we reveal another worksheet.
Hidden sheets in Excel
The function of this option is clear. Rename the worksheet.
The name of the worksheets can be Farsi. You can also use space in this naming. But duplicate name is not allowed. To change the name of worksheets, we can also double click on their name.
View Code
This will take you to the VBA Editor page and display the coding page of the current worksheet. This page brings us macro writing and VBA programming capabilities. With this option, we will have an interesting example at the end of this section.
Protection Sheet
In general, to apply restrictions on the worksheet after making the relevant settings, you should use the Protect Sheet option.
Protecting sheets in Excel
By entering the Protect Sheet window, you can define various accesses for the worksheet. Some of the options in this window are:
Select Locked Cells
By selecting this option, we allow the user to select the lock cells after entering the worksheet.
Select Unlocked Cells
By selecting this option, we allow the user to select unlocked cells after entering the worksheet.
Format Cells
Enabling this option means providing access to change the format of cells to all users who enter the worksheet.
After determining the desired access in the worksheet, it is better to define a password at the top of the Protect Sheet window and confirm it again. After that, if you save the file, the settings applied to the worksheet will be saved forever and only the person who has the password can change the settings.
Unlock the sheet
Tab Color
I am sure the operation of this option is clear to you. Changing the color of worksheets tab to display them better.
Hide
Use this option to hide worksheets.
Unhide
This option is used to reveal hidden sheets. But if you don't have a hidden worksheet, it will be disabled.
Select All Sheets
Selection of all worksheets is done with the help of this option. This is used to perform a batch task on worksheets. To disable the selection, you can right-click again on a worksheet tab.
Ungroup sheets
To select a certain number of worksheets, you can select them by holding the Ctrl key and clicking on the worksheets you want. By doing this, the title [Group] will be displayed in the Title Bar of Excel.
Grouping sheets in Excel
Managing multiple sheets in Excel
When there are many worksheets in an Excel file, in addition to the possible problems that arise in the operation of the file, we also have problems navigating between the worksheets.
Excel sheets
The presence of the sign... indicates that there is not enough space to display all the worksheets. Therefore, we must use the Navigation section to navigate between worksheets. By clicking on the arrows in this section, we move between worksheets. But if the number of worksheets is too many, this will not help much. There are some good shortcut clicks in this field:
Move between sheets
Important shortcut keys of Excel sheets
The figure below shows the mode that opens the list of worksheets by right-clicking on the Navigation section. After opening this window, you can type the beginning of the name of the desired worksheet to be selected. Then press Enter and enter that worksheet.
List of sheets in Excel
Changing the direction of sheets in Excel
The direction of displaying Excel worksheets is left-to-right if Windows operating system with English language is installed on your computer. To change the orientation of the sheets, we use the Page Layout tab. Of course, provided that a right-to-left language like Persian is active on your operating system.
Sheet orientation in Excel
Sheet Right-to-Left: Right-to-left direction for the worksheet
Sheet Left-to-Right: Left-to-right orientation for the worksheet
An Excel file can have different worksheets, each of which has different directions, and there is no limit for this.
Change Direction
- ۰۱/۱۲/۱۶