When using Excel, we may be familiar with various cell tips, but we are very unfamiliar with worksheets. So, what is the worksheet? When we create a new worksheet, Excel will automatically generate a workbook, and then create a worksheet under the workbook. Multiple worksheets can be created under the same workbook at the same time, which greatly facilitates our operations.
For example, if we want to make a consumption table for the whole year, then we can create multiple consumption tables for January, February, and March under one workbook, which is very convenient to browse. In the process of making worksheets, we will inevitably encounter many problems. Here are a few common questions and some worksheet tips, which can greatly save your production time.
1. Find a table quickly
When there are many worksheets in a workbook currently, the names of the worksheets are densely packed underneath, and some of them are hidden. In such a situation, how can we quickly locate the desired table?
If you choose to point one by one, it must be undesirable and will waste a lot of time.
If you only need to find the first or last sheet, then directly press the CTRL key and click the left or right triangle symbol in the lower left corner, and the table label will automatically slide to the first or last sheet.
If you want to find a table quickly, move the mouse to the scrolling worksheet area in the lower left corner, and then right-click to see a list of all tables. Then click directly on the form what you need.
2. Quickly turn pages
In Excel, if you want to switch worksheets quickly, you usually click the worksheet tab below. But if you want to switch worksheets continuously, do you also click page by page?
Of course not. Here is a shortcut key trick for turning pages.
Use the shortcut key “Ctrl + Page up” to turn pages forward, and use the shortcut key “Ctrl +Page down” to turn pages backward.
Some laptops also need to add the “Fn” key.
3. Select multiple worksheets at the same time
Sometimes we need to perform the same operation on multiple worksheets. If you select page by page and then perform related operations, it will be time-consuming and laborious. At this time, we can select several pages in a workbook to process at the same time.
As with our daily file selection, first select one page, and then hold down the Shift key and click another page to select these consecutive pages. Select one page, then hold down the Ctrl key and click on other pages in turn to select several non-contiguous pages at the same time.
In addition, there are two very convenient shortcut keys:
Use “Ctrl +Shift +Page up” on the keyboard to select more forward.
Use “Ctrl +Shift +Page up” on the keyboard to select multiple backward.
4. The role of multiple choices
The above explains how to perform multiple selection operations, so what is the effect after multiple selections? Let’s take a look at it in detail below.
First select three tables at the same time, and then use the shortcut key “Ctrl +A” to select all the table contents. Use the shortcut key “Alt”+”=” to perform the sum operation. You can find that all the totals in the current form have been filled in automatically. Then we clicked on the other two selected tables and found that the total of all tables has been completed.
This is the function of multiple selection that the total of each worksheet can be calculated in an instant.
5. Hide the worksheet
In the work, if you find that there is still one page that has not been completed of the form to be checked by the boss, but you cannot delete it directly. After all, you have already done half of it, and you cannot restore it after deletion. At this time, we can use Excel’s worksheet hiding function.
Select the worksheet to be hidden, then right-click and select “Hide”. It is invisible in the worksheet tab.
It is also very simple if you want to restore the hidden worksheet. Right-click the worksheet tab below. Choose the Unhide, and select the sheet you want to restore in the pop-up window.
6. Move the worksheet
Sometimes we edit the worksheets separately in different workbooks, but we are required to put all the worksheets under one workbook. At this time, we need to move and copy in turn.
Select the table to be moved and copied, and then right-click. Select “Move or Copy”. Click the first drop-down box in the pop-up window. Select the workbook to be placed. Then click the position you want to place in the “Before sheet” below. Check “Create a copy”. Click OK.
Open the workbook you just moved, and you can find that the table has been copied in. If you need to move multiple tables again, you can use the third method of the article to select multiple tables at the same time, and then repeat the above operation.
7. Add color to the worksheets
In Word, we can add colors or add horizontal lines to important text, and you can quickly notice it the next time that you edit. So how do you add marks to important worksheets in Excel?
Right-click a worksheet. Select the Tab Color, and then click a favorite color to add color to the worksheet Tab.
If you haven’t finished this worksheet, then after adding colors to it, you can see it directly next time when you open this workbook, which is clear at a glance. Or you can add the same color to the same kind of worksheets to group them.
The above is some of the common Excel tips introduced today. After using them, you can obviously find that Excel is easier and more convenient to use. And they can not only save time, but also make the worksheet more perfect.