Shortcut keys for Excel data chart editing operations

Source: Internet
Author: User

Word shortcuts, Excel shortcuts are the two types of office shortcuts that we often use. In fact, there are many office shortcuts. Mastering these shortcuts can greatly improve your work efficiency. We will learn together.

Create a chart and select a chart element

to Press /b> the
f11 or alt+f1
> Select the chart worker Table: Select the next sheet in the workbook until the chart sheet you want is selected. ctrl+page down
select graph Table Sheet: Select the previous worksheet in the workbook until the chart sheet you want is selected. ctrl+page up
select chart The previous set of elements. down arrow
up key
right arrow
left button

Select embedded chart

1. Display the Drawing toolbar: Press Alt+v, press T, and then press the DOWN ARROW key until you have selected drawing, and then press Enter.

2. Press F10 to activate the menu bar.

3. Press Ctrl+tab or Ctrl+shift+tab to select the Drawing toolbar.

4. Press the RIGHT ARROW key to select the Select Object button on the Drawing toolbar.

5. Press Ctrl+enter to select the first object.

6. Press Tab to cycle forward to select the object (or press Shift+tab to cycle back to select the object) until the round sizing handles (sizing handles: small dots or small points that appear on the corners and sides of the selected object. Drag these handles to change the size of the object. Out of the embedded chart you want to select now.

7. Press Ctrl+enter to activate the chart to select its elements.

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.