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

Today, I will share with you a few Exce tips commonly used in daily office, which can make your work easier. Come and have a look!

01, uninterrupted sequence using uninterrupted sequence, even if we delete one of the rows, other sequences will not be affected by any, formula:

=ROW()-1

02, insert multiple rows and columns If you want to insert multiple rows in Excel, you can select the number of rows you want to insert, and then "right-click"-"Insert" to quickly insert multiple rows. The same way to insert multiple columns!

How to enter circled numbers in Excel? Use the formula in cell A2:

=UNICHAR(9311+ROW()-1) If cell A1, remove the "-1" from the formula.

04. Check and cross in box How to enter check and cross in box in Excel cell?

Enter R for hook;S for cross, select the cell and change the font to "Wingdings 2".

05, segment display number phone number or bank card number is too long, not careful will see the eye, all, we will generally display these values in Excel segment. Select the data cell, then right-click-Format Cell-Number-Custom, and enter "000-0000-0000" in the Type field.

06. Classification Summary How to quickly classify and summarize department performance? First, position the cursor to the "Department" cell, then "Data"-"Sort" sort; then select the entire data area "Data"-"Hierarchical Display"-"Classified Summary" OK.

07, according to the date to get the week after entering the date, if you want to enter the week, we can copy a date, and then "right click"-"set cell format"-"number"-"date", here we can choose a week format.

08. Merge multi-cell content How to quickly merge multi-cell content in a column?

09, split a column into two columns of data are in a column, how to split into two columns?

10, two tables add sum two similar tables, but the data is different, how do we quickly add the sum of the two tables?

This article comes from Weixin Official Accounts: Word 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.