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

8 Excel tips that are very commonly used, let's see if you know them all.

1. Form transposition sometimes, we need to change the direction of the completed form, which can be accomplished through the form transposition function. First copy the table, and then in the target cell "right"-"selective paste"-"transpose" on it.

2. Select the table data area many people are used to dragging and selecting tables with the mouse, if the form is small, you can do so, but if you have too much table data, do you still want to drag it with the mouse? You can use the shortcut key "Ctrl + A" to select the table area.

3. The text branch distributes multiple text in a cell to multiple lines, select the cell, then adjust the cell width to enter "start"-"Edit"-"fill"-"content rearrangement" to determine.

4. Text alignment how do I align the text ends of the upper and lower cells? Select the cell "right"-"format the cell"-"align", and set it to "disperse alignment" in horizontal alignment.

5. Is the batch adding unit still adding units to the data manually? Let's see how to add units in batches! Select the cell to which you want to add units, "right"-"format cells"-"Custom" enter "# yuan" to determine.

6. Enter the ID card number directly into the Excel ID card number, will become eBay 17, we can enter before the entry of an English state of the "'" single quotation marks, and then enter it.

We can also set the cell to text format, and then enter the ID card number, which is also possible.

7, jump to the specified cell if there is too much data in the table, it is not easy to find what you want, we can press the "F5" key, enter the target cell, and then quickly jump to the specified cell.

8, interlaced or column insert data how to copy and paste interlaced or interlaced data? According to the original table, vacate the corresponding position, then copy the data, and then "paste selectively"-"skip empty cells".

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.