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

What are the Excel techniques that people use every day? Today, Mr. Wang sorted out some of the most commonly used Excel skills in daily work and shared them with you.

1. Form encryption We often set encryption for important forms. How do we do this? Enter "File"-"Save as"-"this computer"-"tools"-"General options" to enter the password, repeat the password, and save it.

2, quickly insert a blank line usually we insert a blank line, we use the right button to insert, in fact, there is another insertion method, select the whole line, press and hold the "Shift" key not loose, move the mouse to the left side of the cell, become a two-way arrow, hold down the left button and drag down, you can quickly insert a blank line.

Quick input Custom date format when many friends enter a date, they enter it like this: 2020-01-01. Actually, it doesn't have to be so much trouble. We can "right"-"set cell format"-"number"-"date" to select a date type, determine and return to the cell, directly enter 1-1, you can quickly complete the input date.

4. Quickly move the selected cell if you want to select the rightmost cell, we can move the cursor to the right side of the current cell and double-click, at this time, you can quickly jump to the rightmost cell, and so on!

5. The data is displayed as an asterisk. Sometimes, when entering some important data in Excel, we want to hide it without affecting the data. We can first select these cells, and then "right"-"format cells"-"Custom", in the "type", enter "*" two asterisks.

6. Fill in the specified date when we want to enter a series of dates in the Excel table, we can use this technique to enter these dates quickly.

7, one key to delete the border line and one key to clear the table border line, you can use the shortcut key "Ctrl + Shift + -".

8. Extract the numerical values in the table. There are Chinese and numerical values in the table. We only want to extract the numerical values. What should we do?

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Yi Xuelong

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.