Select one or more worksheets in Excel 2007

Source: Internet
Author: User

By clicking the sheet at the bottom of the Excel window tab, you can quickly select a different worksheet. If you want to enter or edit data on several worksheets at once, you can combine worksheets by selecting multiple worksheets. You can also format or print several selected worksheets at the same time.

operation
a worksheet Click the sheet's label.

If you don't see the desired label Check, click the Label Scrolling button to display the label you want, and then click the label.

two or more adjacent worksheets > Click First tab of the worksheet, and then hold down SHIFT while you click the label of the last worksheet you want to select.
two or more nonadjacent worksheets > Click First Sheet, and then hold down CTRL while you click the tabs of the other worksheets you want to select.
all worksheets in the workbook > Right-click a job As a table, and then click the shortcut menu shortcut menu: A menu that displays a list of commands related to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10. , Select all sheets .

Tip When you select more than one worksheet, the word [workgroup] appears in the title bar at the top of the worksheet. To deselect more than one worksheet in a workbook, click any unselected worksheet. If you don't see a worksheet that is not selected, right-click the tab for the selected worksheet, and then click UngroupSheet on the shortcut menu.

Comments  

• On the active worksheet active worksheet: A worksheet that users are working on in a workbook. The name on the active sheet label is bold. ), the data you enter or edit is reflected in all selected worksheets. These changes may replace the data on the active worksheet and may inadvertently replace the data on other selected worksheets.

• Data that is copied or cut from a grouped worksheet cannot be pasted into another worksheet because the size of the copied area includes all the layers of the selected worksheet, so it is different from the pasted area on a separate worksheet. Before you copy or move data to another worksheet, make sure that you have selected only one sheet.

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.