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

Original title: "I always thought I was good at Excel until I met these miraculous skills!"

After using Excel for many years, I dare not say that I have completely mastered it, because there are so many functions in it. Today, let's share with you some unpopular high-score skills that few people know about in Excel. I'm sure you haven't used it!

1, automatically add the border line every time you finish the table, you have to add the border line manually, if you want to add data later, but also add the border line again, is it very troublesome? Let's see how to automatically border a table.

① select the need to automatically add borders in the region, enter the "start"-"style"-"conditional formatting"-"New Rule"-"use the formula to determine the format of the cell", in "format the value in accordance with this formula", select the input "= $A2", and finally click "format"-"frame" Select "outer border" to determine it.

After the ② is set up, let's see that the cells of the existing data have been added border lines. Enter the content in the blank area, and you can automatically add the border lines.

2. Highlight too much data in the table, it is very tiring to view, and it is easy to misread it. If you highlight the ranks, it looks more intuitive.

① select the data area, enter "start"-"style"-"conditional format"-"New Rule"-"use the formula to determine the cells to be formatted", then enter the formula, click "format"-"fill", select a background color.

= ORANDROW () = sRow,ROW () = eRow,ANDCOLUMN () = sColumn,COLUMN () = eColumn)

② right-click "Sheet1"-"View Code" and paste the following code into it.

Private Sub Worksheet_SelectionChange (ByVal Target As Range) On Error Resume Next ActiveWorkbook.Names.Add Name:= "sRow", RefersToR1C1:=Target.Row ActiveWorkbook.Names.Add Name:= "eRow", RefersToR1C1:=Selection.Cells (Selection.Cells.Count). Row ActiveWorkbook.Names.Add Name:= "sColumn", RefersToR1C1:=Target.Column ActiveWorkbook.Names.Add Name:= "eColumn", RefersToR1C1:=Selection.Cells (Selection.Cells.Count)

When ③ is saved, we will select "Excel enabled Macros Workbook".

3. Record sheet if you have a lot of data to enter into the Excel form, it is recommended that you use the record sheet function, which can help us to enter data more conveniently and quickly. Let's have a look!

Open the record sheet function to enter "File"-"options"-"Custom Ribbon", and create a new tab in the "main tab". Then select "commands that are not in the ribbon" in the "Select commands from the following locations" on the left, and find the "record sheet" to add in the following functions.

Use the record sheet to position the cursor in any cell with content in the head, and then turn on the record sheet function. We can see that our title has appeared in the dialog box, we just need to enter the corresponding content in the box, press the "Tab" key to switch to the next item, press "enter" to directly create a new one, and then continue to enter the next entry.

Using the "record sheet" to enter data is not only convenient and fast, but also the error rate will be lower.

Check the data in the record sheet, we can click "previous" and "next" to check the entered data information, which is easier to view the data than it is to view it directly in the table. Because if there is too much data in the table, it will be very difficult to view.

Find data according to conditions in the record sheet, we can use any condition to quickly find the data we want. Open the record sheet, click "conditions", then enter the information you are looking for into the box, and click "next" to start the search.

Modify data if you want to modify a piece of data, we can first enter the conditions, find the data, then modify it in the box, and finally click the "New" button to complete the modification.

It is impossible to input data at once, so when we open the table for the second time and want to continue to enter data, the data information of the first item will be displayed on the record sheet, so how can we continue to enter it?

All we have to do is click the "New" button, and at this point, the record sheet will not add the information to the table, but will empty all the options on the record sheet, and then you can start entering new data. enter or click "New" to add.

Delete record to delete one of the records, we can first find the record, and then click "Delete".

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

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.