Use more conveniently set optimization Excel2007 eight big tricks

Source: Internet
Author: User
Tags versions

Excel2007 use is not very handy, feeling or using the previous version of the habit, the author today to teach you to set up, adapt to the previous operating habits.

Move one: "Quick Access Toolbar" please come down.

Set the method as follows: Click the Office Button at the bottom right of the Drop-down menu and click "Excel Options" to appear in the Excel options interface as shown in (Figure I):

Figure I

Click on the left "custom" bar, on the right will appear the "Custom Quick Access Toolbar" settings interface as shown in (Figure II):

Figure II

Here you can add the commands you use frequently in your daily work. After adding, check the "Show Quick Access Toolbar below the Ribbon" option below, and click OK. So we're going to put the Quick Access Toolbar under the Ribbon. Why do you want to get the Quick Access Toolbar down? Have you found the Quick Access Toolbar in the title bar and file title in the same column, the number of commonly used commands are limited, sometimes have to click the Drop-down button to find common commands, the "Quick Access Toolbar" to get down on the good, The common commands above can be shown in many, just like previous versions of Excel's toolbars, which are handy to use.

Moves two: Hides "the Ribbon" to make "the work area" The view to be more open.

In the move one we put "Quick Access Toolbar" Please come down below, do you think the workspace a little bit smaller? Never mind. Now you double click on any tab on the "Ribbon" like "start", what you find, ha, "Ribbon" is hidden. When you use it, just click on the tab on the Ribbon and the "Ribbon" comes out at once, compared to previous versions of Excel. You will find that the Excel2007 "Ribbon" is just like the previous version of the menu bar drop-down menu, "Ribbon" above the "tab" is actually the previous version of the menu bar. Hehe

Moves three: Lets Excel2007 change "the clothes"

Sometimes on the internet to see someone else's Excel2007 interface is black, is not want to change their own Excel2007 color? Follow me! such as (figure I) in the "Excel Options" interface "Common" item, click the Drop-down arrow at the color scheme, there are three color schemes, there are black, select later click "OK", how? Isn't it cool? Oh!

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.