Excel daily operation experience Skill

　　A. Skillfully change capital Chinese numerals

　　1. First we move the cursor to the cell in which you want to enter an uppercase number, and use the keypad to enter the corresponding number in the cell, such as: 12345.

2. Right-click the cell, select Format Cell ...

3. In the Pop-up Cell Format dialog box, select the Special option, and then in the type, select Chinese capital number.

4. After clicking "OK", Excel automatically converts the corresponding number into Chinese capital number, which saves a lot of time.

　　Two. Multiple worksheets are edited at the same time

　　1. We sometimes have to work on multiple worksheets in the same place to do the same data editing, such as all worksheets in the specified location to join the header and footer, first of all, we right-click the worksheet name, select "Select All Sheets."

Excel daily operation experience Skill

2. So all the worksheets are selected, at which point we only need to work on the first worksheet at the specified location, and the rest of the worksheet will be at the same location.

Three. Excel cell text wraps at any time

1. In Excel, we sometimes need a cell divided into several lines to display text, and so on, usually by right-clicking--formatting cells--to check for word wrapping.

2. The above method is we usually use, but is not very convenient, next, the Pig teaches everybody a shortcut key, when you need to redo one line input content, as long as presses the ALT + ENTER to realize the quick change line.

　　Four. Cancel 0 values in Excel

　　1. When we come across Excel to calculate the result is 0 o'clock, the default will display is 0, many times we do not want the Excel table to display 0, but the quantity is more, simultaneously cannot replace, the method is as follows: First, we select the area to edit.

2. Then we select the tool-----option, and in the Pop-up Options dialog box, uncheck the 0 value in the view.

3. After the confirmation, all the 0 values in the editing area show blank, if need to display, and then check the 0 value can be selected.

　　Five. Batch Conversion date format

　　1. For "YYMMDD" in this form of the date, if you want to convert to a formal format "YY-MM-DD", if the data involved more and miscellaneous, manual conversion is not very desirable, the quickest way is as follows: first select the area to convert.

2. Click "Data"--"Breakdown", Pop-up "Text Column Wizard" dialog box.

3. Check "fixed width", then click "Next" button two times.

4. Then in step 3, in the column data format, select "Date", the format is: YMD, and then click Finish.

5. After the completion of the click, Date data will be converted into regular date format.

　　Attention matters

　　Excel features very powerful, there are many features and shortcut features we have not found that the pig will continue to find in the day-to-day life, share to everyone!