Advanced Skills in Excel-one

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.