Examples to share practical cold skills in Excel

This article brings you relevant knowledge about excel, which mainly introduces a set of cold knowledge about excel, including deleting the euro style in the worksheet, copying the chart format with one click, One-click conversion between Traditional and Simplified Chinese, etc. I hope it will be helpful to everyone.

Related learning recommendations: excel tutorial

Share a set of cold skills in Excel, accumulated bit by bit, can also solve problems at work Let’s take a look at the actual problems~

1. Delete the Euro style in the worksheet

Many friends have encountered this problem, and Excel is good at it After the document is opened, the numbers inside are changed into accounting amounts or euro format.

In fact, this is the sequelae of using custom formats in the worksheet.

Solution:

Press to open the [Format Cells] dialog box, switch to [Custom] under the [Number] tab, and change all functions on the right Delete all deleted format codes, save the file and open it again, and there will be no problem.

#Don’t worry, the deletion here will not go wrong, the built-in format code cannot be deleted.

2. One-click copy of chart format

After hard work setting up a chart effect, how can you quickly apply it to another chart?

Right-click the set chart and copy. Then click on the chart where you want to apply the style, using Paste Special is enough.

3. One-click conversion between Traditional and Simplified Chinese

Partners working in joint ventures should often encounter the problem of converting between Traditional and Simplified Chinese. How to deal with it?

Step 1 Right-click any tab → Customize Ribbon

Step 2 Switch to [Add-ins] in the pop-up [Excel Options] dialog box

Step 3 Select [COM Add-in] → [Go], and then check [Chinese Conversion Add-in] in the dialog box

Step 4 Select the data area, click [Review] → [Simplified to Traditional] , OK.

The above are the steps for first use. When using the Traditional to Simplified conversion function again in the future, only the fourth step is required.

4. Disconnect links with other workbooks

If you use a function to reference data in other workbooks, there will be such a prompt dialog box when the file is opened:

It would not be a good idea if such a document is sent directly to the leader.

In fact, before sending the document to other personnel, you can create a copy first, and then disconnect the document to be sent to other personnel:

5. Quickly extract characters

As shown in the figure below, if you want to delete the phone number in brackets and keep only the name, you can use Ctrl H to complete.

Enter (*) in the Find content edit box of the Replace dialog box.

The asterisk here means a wildcard, just like the king in poker, it can represent any number of characters. In addition, there is a little king, which is a half-width question mark?, its function is to represent any character.

Do not enter anything in the "Replace with" edit box, just click Replace All and it will be OK.

Related learning recommendations: excel tutorial

The above is the detailed content of Examples to share practical cold skills in Excel. For more information, please follow other related articles on the PHP Chinese website!