Use Excel 20,076 tips to help you save time.

Source: Internet
Author: User

1. Change the default sheet count

By default, when you open Excel, you create a new blank workbook that contains 3 blank worksheets. But do you always use these 3 worksheets? or what if you could use more worksheets? In fact, this value can be changed to any number from 1 to 255. Of course, few people use 255 worksheets. In the Excel Options dialog box, on the General tab, you can change the number of sheets included when you create a new workbook to the value you want, as shown in Figure 1.

2. Change the number of recently used document lists

When you have opened several workbooks by using Excel 2007, you can see the list of most recently used documents in the right-hand pane by clicking Office Buttons. By default, the number of this list is 17, and we can change it to any number from 1 to 50. Click the Advanced tab in the Excel Options dialog box, and then in the show area, set the value you want on the right side of show this number of recently used documents, as shown in Figure 2.

3. Change the user name

Some things are very simple, but few people use them. Adding a user name allows you to embed names in future documents as author names. When you open the Workbook Properties dialog box, you can see the author's signature. If you want to change the user name, you can make changes in the General tab of the Excel Options dialog box, as shown in Figure 3.

4. Change the standard font

When you save a workbook, do you often change the font and size to a different size? If so, you can change the standard font and font size of Excel to the type you want. On the General tab of the Excel Options dialog box, you can change the standard font, as shown in Figure 4.

5. Change the default file storage location

When you save a workbook, do you often find your favorite destination folder in the Save As dialog box? This can be avoided by changing the location where the file is stored. This saves a lot of time each time a file is stored. You can change the default file storage location in the Save tab of the Excel Options dialog box, as shown in Figure 5.

6. Custom status bar

When you select some cells in a worksheet, the status bar displays some information related to the selected item. For example, the number of cells currently selected, the maximum value in the selected data, and the average. This is a very useful feature that allows you to get some of the information you need without using a formula.

Right-click the status bar to open the custom status bar menu, from which you can select items to display or hide in the status bar, as shown in Figure 6.

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: and provide relevant evidence. A staff member will contact you within 5 working days.