Get the App
SLTechnology News&Howtos  ›  IT Information  › 

8 Excel simple and practical tips to share: one click to delete borders, table encryption, quickly insert blank lines.

Shulou Source: shulou.com Published: 2023-11-24 18:07:01 11月20日 Update

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, one key to delete the border line and one key to clear the table border line, you can use the shortcut key "Ctrl + Shift + -".

2. 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.

3, 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.

5. 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!

6. 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.

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.

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: Wang Wangqi

Tags: Cell input date table technique blank blank line right numeric data format move border one key encryption important password asterisk type normal Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Xiaomi Shulou Tech Info OPPO Reno MariaDB