Top ten office skills in EXCEL, efficient, easy and easy to master

php editor Xinyi has carefully compiled the "Top Ten Office Skills in EXCEL, Efficient, Easy and Easy to Master" to help you improve your office efficiency. These tips cover the common functions of EXCEL, making you more comfortable when processing data and making tables. Both beginners and users with certain experience can benefit from it, improve work efficiency, and easily control EXCEL software.

In order to quickly restore garbled numbers, you can right-click the selected area, select Cell Format, then click Customize, change the type to "0", and finally click OK.

3. To beautify the table with one click, press "Ctrl A" to select all tables, "Ctrl T" to create a super table, check "Table contains titles", and click OK

4. Add units in batches and select all tables, set the cell format - Customize - enter "minutes" after the general format to confirm

5. Swap the positions of the two columns. Select the list that needs to be adjusted, place the mouse on the border of the column, hold down Shift when the mouse turns into an up and down arrow, and drag directly to the position that needs to be adjusted.

6. Enter 10000 serial numbers. First enter the serial number 1, then click Start-Fill-Sequence-Select Column-Terminal Value and enter 10000

7. To delete all comments in the table, press "Ctrl G" to bring up the positioning - click on the positioning criteria to select "Comments" - OK, then right-click the mouse - Delete comments

8. Table conversion horizontally select all the content, copy, select a blank cell, right-click - Paste Special - Check Transpose - OK

9.Convert pdf to excel table Open the Pepsi Niu PDF conversion tool, select [PDF to file], add the files to be converted, select the operation type as "PDF to Excel", and click [Start] to automatically convert.

10. Open the encrypted excel table and open the Pepsi Niu Excel password recovery tool. After adding the files that need to be unlocked, select the password retrieval method, and you can automatically use the exclusive algorithm to effectively retrieve the password.

The above is the detailed content of Top ten office skills in EXCEL, efficient, easy and easy to master. For more information, please follow other related articles on the PHP Chinese website!