In the daily life of dealing with excel, we should be most exposed to a thing called "worksheet", so do you know what tips related to worksheets?
A worksheet refers to the page where data is edited and saved in Excel, and the worksheet name is at the bottom of the window.
Add a worksheet
You can add multiple worksheets in one file in Excel, just click the "+" after the worksheet name.
If you need to change the name of the worksheet, you can right-click and click "Rename", or double-click the name of the current worksheet.
Move or copy the worksheet
If you want to copy a worksheet, you can hold down the Ctrl key and drag the worksheet behind it, or right-click the mouse, click "Move or Copy", check "Make Copy", select "Move to Last", and finally "OK".
Composite worksheets
Excel worksheets provide the function of a workgroup, and you can edit and manipulate multiple worksheets in a unified way: press the Ctrl key, click on each worksheet separately, and you will enter the mode of "group" of work.
To cancel the mode of a workgroup, you can right-click the mouse, and then click Ungroup Worksheets.
Hide the worksheet
When we don't need certain worksheets for the time being, we can use a function to "hide" worksheets: right-click and select "Hide".
If you want to unhide, you can right-click on any worksheet name and select "Unhide".
In addition to the above basic and commonly used excel sheet setting skills, what other good ways do you use it in the process of use, welcome to share it together!
Autumn and Winter Check-in Challenge