Apply Excel worksheets to workbooks

Source: Internet
Author: User
Tags split

Since a workbook has multiple worksheets and they can't be displayed on one screen at the same time, we have to constantly switch between worksheets to do different work. For example, the first worksheet is the current year sales statistics report, the second form is the annual monthly sales curve, and the third form is the distribution table by region.

In Chinese Excel, you can use the worksheet tabs to quickly switch between worksheets. During a switch, if the worksheet's name is in a tab, you can switch to the worksheet by clicking on the tab. If you want to switch to the previous sheet on the worksheet, you can also press the [Ctrl]+[page down] key or click the tab of the worksheet, or you can either press the [ctrl]+[page up] key or click the tab of the worksheet if you want to switch to the next sheet in the workbook. If the worksheet tab we want to switch does not appear in the current Table tab, we can toggle through the scrolling button, as shown in Figure 3-14.

The scrolling button is a handy switch tool. Click it to quickly switch to the first worksheet or the last sheet. We can also change the position of the tab split bar to show more worksheet tabs, and so on.

3.3.2 Insert or delete a worksheet

Typically, a newly opened workbook contains the default 3 worksheets, named "Sheet1", "Sheet2", "Sheet3", respectively. In practical work, we may use more than 3 or less than 3 sheets in a workbook. Excel can change the number of worksheets.

Insert a sheet

To insert a worksheet, first click the sheet tab to select the worksheet, then select the Sheet command on the Insert menu and we'll see a new worksheet inserted and named "Sheet8" (I'm using a workbook that's already 7 worksheets), as shown in Figure 3-15. Also, the newly inserted worksheet becomes the currently active worksheet.

If you want to insert multiple worksheets, you can press the button (repeat action) to insert more than one sheet.

Note: Although you can have up to 255 worksheets per workbook in Excel 2000, the worksheets we insert are limited by the available memory for the computer you are using.

Delete a worksheet

Similar to inserting a worksheet, to delete a worksheet, click the worksheet tab to select the worksheet, and then choose Delete on the Edit menu to see that the selected sheet is deleted, and that the following worksheet becomes the currently active worksheet.

Change the default number of worksheets

As I mentioned earlier, the default number of worksheets in Excel is 3, and we can change the default value. The action is:

(1) Execute the Options command on the Format menu, and a dialog box appears, selecting the General tab.

(2) in the "number of worksheets in the new Workbook" entry box, enter the number you want, as shown in 3-16.

(3) Press the "OK" button.

3.3.3 Move and copy worksheets

Move a worksheet in a workbook

To adjust the order of worksheets in a workbook, simply click the Selected sheet tab on the worksheet tab, and then drag the selected worksheet along the tab line to the new location, releasing the mouse button to move the worksheet to a new location. During the drag process, a black triangle appears on the screen to indicate where the worksheet should be inserted, as shown in Figure 3-17.

Move a worksheet to another workbook

The process of moving a worksheet to another workbook is as follows:

(1) Click the Selected worksheet tab on the worksheet tab of the source workbook.

(2) Perform the move or copy Sheet command on the Edit menu, and the dialog box shown in Figure 3-18 appears on the screen.

(3) Select the destination workbook in the Workbook list box, and then press the OK button.

Tip: If you have the same worksheet name in the destination workbook, the name of the worksheet that moved the past changes.

Copy a worksheet in a workbook

In the actual work, we often encounter two tables very similar situation, such as the company's "payroll." In terms of a company's payroll as a workbook, since the company's monthly salary schedule is not very small, we do not have to create a new salary every month, but only a copy of last month's payroll, and then change the changes in the individual items can be changed to other fixed items or items that do not occur, such as name, Basic salary and so on do not need to revise, thus enhances the work efficiency.

To copy a worksheet in a workbook, simply click the Selected sheet tab on the worksheet tab, press the [Ctrl] key, and drag the selected worksheet along the tab line to the new location, and then release the mouse button to insert the copied worksheet into the new location. During the drag process, a black triangle appears on the screen to indicate where the worksheet will be inserted, as shown in Figure 3-20.

Tip: Using this method is equivalent to inserting a new table containing data. The name of the sheet is named "The name of the source sheet + (2)".

Copy a worksheet to another workbook

The process of copying a worksheet to another workbook is as follows:

(1) Click the Selected worksheet tab on the worksheet tab of the source workbook.

(2) Perform the move or copy Sheet command on the Edit menu, and the dialog box shown in Figure 3-19 appears on the screen.

(3) Click the Make Copy check box, and then click Select New Workbook in the Workbook list box, and press the OK button to complete.

3.3.4 Rename a worksheet

As mentioned earlier, when Excel builds a new workbook, all worksheets are "Sheet1" ... To order. But in the actual work, it is very inconvenient to remember and carry on the effective management. We can change the names of these worksheets to have

Effective management, such as the 12 worksheets in the 97-year payroll workbook named "January", "February" ... "December" to conform to our working habits.

To change the name of the worksheet, simply "Double click" On the Selected sheet tab, and you will see the worksheet tab appear black on the screen, as shown in Figure 3-20.

Enter a new name, and when you press ENTER you will see that the new name appears in the worksheet tab instead of the old name, as shown in Figure 3-21.

Tip: Spaces are allowed in the worksheet name, which differs from other filenames.

3.3.5 Split Worksheet

We often create large tables in our work, and in the process of editing them we may want to see different parts of the table at the same time. In Excel 2000, the system provides us with the ability to split worksheets so that we can split a worksheet by "Landscape" or "portrait" so that we can observe or edit different parts of the same table at the same time. As shown in Figure 3-23, we see that there are two separate boxes on the scroll bar.

The split section is called the pane, and each pane has its own scroll bar, which we can use to scroll through the contents of this pane.

Horizontally split the worksheet, first we point the mouse pointer to the horizontal split box, and then press the mouse to drag the box to their own satisfaction, release the mouse that completes the window segmentation, or in the Horizontal split box double-click, the system will be the default way to split the worksheet. The partitioned worksheet is shown in Figure 3-23.

Note: The split worksheet is a worksheet, and any changes to the contents of any pane are reflected in the other pane.

You can also use the Split Window command (shown in Figure 3-24) on the Window menu to achieve the purpose of this split window. For vertical split windows, the method is the same as the horizontal split window, and this is no longer a repeat.

Hide/restore of 3.3.6 worksheets

We can hide worksheets that contain important data or work sheets that are temporarily unused. hiding workbooks and worksheets in a workbook reduces the number of Windows and worksheets on your screen, and helps prevent unwanted changes to hidden worksheets. Worksheets that contain macros or important data can be opened by other worksheets and can be used on other worksheets, but cannot be edited.

For a hidden worksheet, even if we can't see the hidden window, it's still open. If a workbook needs to be open but does not need to be displayed, we can hide it. To hide a worksheet, follow these steps:

(1) Select the worksheet that you want to hide.

(2) To perform the Hide command in the sheet command on the Format menu (shown in Figure 3-25), we can see that the selected worksheet disappears from the screen.

After we hide the worksheets, if we want to use them, we can restore their display. The operation process is as follows:

(1) To perform the Unhide command in the Sheet command on the Format menu, a dialog box like Figure 3-26 appears on the screen.

(2) from the "Show hidden Sheet" list, select the worksheet you want to restore, press the OK button.

3.3.7 Change the display scale of worksheets

In the default state, Excel displays the worksheet in a scale of 100%. If you want to change the display scale of the worksheet, you can do the following:

(1) To perform the zoom command on the View menu, the dialog box appears as shown in Figure 3-27.

(2) Select the desired display ratio.

(3) Press the "OK" button.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.