Advanced Skills in Excel-one

Source: Internet
Author: User
Tags password protection
In the last saving stage of the Excel table, click the tool option to add password protection.

In the advanced options, you can create a sequence for sorting and copying. When processing some of your own books, you can reduce unnecessary troubles.

Sometimes why cannot I display all my ID card numbers? Because the default type is a number, you can change the cell format to text, or add a semicolon in the English state.

To enter multiple rows in a cell, you can click Alt + enter.

When you want to enter a score in a cell, you can enter 0 + space + score first

In the exce cell, you must use the tab key to quickly change the cell.

In an Excel cell, you can press and hold the Alt key to save time by combining the up and down keys.

In exce, you can drag the content in the cell by holding down the Shift key and the left mouse button. You can copy the content in the cell by holding down ALT and the left mouse button.

You can easily view the frozen window in the add view.

In an Excel worksheet, when you want to insert multiple worksheets, you can insert a worksheet first, and then click the F4 key to insert the worksheet again. This applies when you delete the worksheet. you can also set the default number of worksheets in the file-Option-general. to differentiate worksheets, you can also right-click to change the color of the Work label.

When you select the worksheet you want to set in multiple worksheets, to reduce the trouble of searching, you can right-click the left and right buttons and select

You can choose option-advanced-to change the editing status of a cell. One can be input directly in the cell, and the other can be input only in the cell.

There is a ratio in the tool options. You can change the ratio to display the appropriate ratio by default, which is convenient for the application.

To compare numbers in different tables in an Excel table, you can hide unnecessary tables or customize view categories.

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.