Shulou(Shulou.com)11/24 Report--

The original title: "the inconspicuous clipboard unexpectedly has these unknown and efficient tips!" "

Hello, everyone! I am Xiaolan who "loves and kills each other" with Excel.

First, let's play a Mini Game with the students:

Open any Excel table and press [Ctrl+C] twice in a row

What will happen? Nothing happened.

Pulled up the clipboard

In fact. Both can happen, and the key is whether you check this feature:

1. How to find this function? Quite simply, find the Clipboard in the start tab, and click the

-[option], you can see ~

Many students asked: anyone can use such a simple function of clipboard, why is it so mysterious?

Hey! Hey! Don't underestimate it. At least 50% of the students don't know the efficient and practical skills we are going to talk about below.

Why don't you take a look at it together?

2. How to use the Excel clipboard? One-click merge cells: merges the contents of multiple cells into one cell.

One-click split cell: splits the contents of one cell into multiple cells.

Merge multiple worksheets:

PS: before using this tip, remember to empty the clipboard to avoid pasting extra information.

Copy multiple times, paste once:

Excel's clipboard can record multiple copied content, text and pictures are supported! When you need to use one of them, you can click to paste, or you can paste them all at once:

The PS:Excel clipboard can only record up to 24 messages.

How's it going? Do you know all these tips? (little E: I know now ~)

All right, let's get back to business. The Excel clipboard mentioned above has a lot of useful tips, but it can only be used in Excel.

Here Xiaolan recommends two more artifacts to you, so that you can experience the convenience and speed of the clipboard in any application.

3. The artifact recommends that ▋ Windows Cloud Clipboard first share with you the Windows Cloud Clipboard, which can also record multiple pieces of clip information. Click and paste when needed.

Usually, this feature is turned off by default, and the steps to enable it are as follows:

❶, click "Settings"-"system" in the "start" menu

❷ Click [Clipboard] on the left

❸ clicks the slider button under Clipboard History on the right to make it open.

After opening it successfully, press the [Windows+V] key to open the clipboard and use it. Even if you accidentally press [Ctrl+C] when pasting, you are not afraid.

Similarly, it also has a sad disadvantage, that is, it can only store up to 24 pieces of information.

So we sometimes need to use another artifact, ↓↓↓.

If ▋ Ditto needs a lot of storage and replication information, it is recommended that friends use this open source, Windows clipboard enhancement software.

The tool can be used free of charge, and there is no limit on the amount of historical data to be saved, and there is no time limit.

Note: Ditto saves 500 pieces of information without time limit by default. If you feel less or more, you can adjust it manually.

After downloading, installing and starting Ditto, there will be an icon for Ditto in the lower right corner of the desktop

Right-click "options" and find [Save maximum number of copied projects] to modify it.

👉 is used as follows:

Here, Xiaolan prepared a few words:

Copy 4 times in a row, then press [Ctrl+~] to open the clipping interface of Ditto:

❶ selects the content you want to paste, double-click the left mouse button or press [Enter] to complete the operation.

❷ press the [Ctrl] key is not loose, the left mouse button click, you can choose discontinuous content, one-time paste.

❸ press [Ctrl+A] to select all, or you can paste all the contents at once.

If ❹ can't find what you want to paste, you can search directly in the search box below.

Press [Delete] after ❺ is selected to clear all the information on the clipboard.

The Ditto functions mentioned above are only basic and commonly used. In fact, there are more practical skills. If you are interested, you can explore for yourself.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.