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

For professionals, we often use Excel to make all kinds of forms, so it is very necessary to improve our Excel level. Today, Mr. Wang will share with you some Excel tips that are very useful. Let's take a look.

01. Restrict the entry of duplicate content if you need to prevent duplicate content from being entered in the table, we can first select the cell, and then go to "data"-"data tool"-"data validation". Select "Custom" in the allowed, and enter it in the formula:

= COUNTIF (Apura A Magi A2) 2

02. Filter tag data to filter out the results and mark them. For example, some models here have a small stock of products. We can find out the results through advanced screening, and then add text marks after them. Finally, the filter results are cleared, which will be more intuitive when analyzing the data.

Quick fill the specified range sequence quickly populates the numerical range, for example, I want to fill 1-100. First enter "1" in the cell, then enter "start"-"Edit"-"fill"-"sequence", select "column", and enter "100" in the "end value" to generate all of them.

Freeze Pane when previewing a table with a header, we can use the freeze pane to fix the header, which makes it easier to preview. Click "View"-"window"-"freeze Pane"-"freeze first row" or "freeze first column". To cancel, we can select unfreeze Pane.

05. The cells in the merged cell Excel are merged and centered. What should I do if I want to cancel and populate again? First cancel the merge and then center, then press the "F5" key, enter the "positioning condition", select "null value", then enter "=" in the edit bar, select the previous cell, and press "Ctrl + enter" to fill it quickly.

06. Limit entry date range how to enter the restricted date range in the cell? Go to "data"-"data tools"-"data validation", set it to "date" in allow, and then set "start date" and "end date".

07, custom fill content not all data can be directly dropped down to fill, this is why? In fact, this is because only some fixed fillings are stored in Excel. If we want to fill them according to our own ideas, we can first store these results in Excel, and the next time we fill them, we can get the effect we want.

As shown in the figure below, I wanted to fill in the circled number, but I didn't get the result I wanted.

Go to "File"-"options"-"Advanced"-"Edit Custom list", enter the fill effect we want in "input sequence", and then click the "add" button to make sure. When we get back to the table interface, let's try again, shall we?

This article comes from the official account of Wechat: Word Technology Alliance (ID:Wordlm123), author: Wang Qi

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.