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

Original title: "Alt" key in Excel 10 great effects, simply too practical!"

Excel Alt key is very powerful, has a lot of useful functions, today, Xiao Wang teacher to give you one by one introduction.

01,"Alt+ DOWN" quickly generate drop-down options When we need to enter duplicate data, just use "Alt + DOWN" to bring up the drop-down menu options, select here, you can avoid repeated manual entry.

02,"Alt+=" key sum We often need to calculate the sum in the table, many people only know to use the formula to sum, in fact, there is a faster way, after selecting the data that needs to be summed, press "Alt + =" directly to be able to sum with one key.

Alt + left mouse button Move data across tables Sometimes we move tables to other worksheets. Select the data and press Alt + left mouse button and drag the data to another worksheet.

Similarly, hold down Ctrl + Alt + left mouse button and drag to other worksheets to copy one directly.

04,"Alt + carriage return" forced line feed cell content is too long, we can position the cursor to the place where you need line feed, and then use the "Alt + carriage return" shortcut key can force line feed.

05,"Alt key" letter shortcut key Press the "Alt" key first, many key tips will appear on the tab, press the corresponding key required, you can quickly enter the function.

06. Alt+F1 creates charts Want to quickly turn data into charts? Simply position the cursor to any cell in the data area and use the shortcut "Alt + F1" to quickly chart the data.

07,"Alt + left mouse button" picture alignment cell Many people do not know, how to embed pictures into cells? Just hold down the Alt key on the keyboard, and then use the left mouse button to drag the four sides of the picture, the picture will be able to automatically absorb to the cell border line, with this method we can easily adjust the picture.

08,"Alt+F4" to close the current pane "Alt + F4" I believe that everyone is familiar with, you can directly close the current window.

09. Ctrl+Alt+V Selective Paste When copying content, paste directly? Sometimes it doesn't. What else is there? Of course, there is, use the Ctrl + Alt +V key combination, you can call up the selective paste panel, you want to paste any result line.

10,"Alt+PgUp \ PgDn" scroll page table data is too much, we may scroll back and forth page, very inconvenient. So how do you do quick scrolling? Try the shortcut keys "Alt + PgDn" to page right;"Alt + PgUp" to page left;"PgDn" to page down; and "PgUp" to page up.

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.