1. Click the file to enter the background view of excel.

2. Click the options menu.

3. After clicking the options menu, the excel options dialog box will pop up, as shown in the figure below.

4. Click the Advanced tab to get the tab as shown below.

5. Let’s take a look at how to set the paste options to display when pasting content. As shown in the picture below, if this check box is selected, then we have multiple format choices when pasting, which is very convenient.

6. Now that we want to paste, we will find that we have many pasting options for us to choose from, such as paste, value, formula, paste link, etc., which can meet our various needs.