Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to use the Alt key in excel. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

1.Alt+Enter forced line feeds

Sometimes you need to enter and display multiple rows of data in a cell. You can place the mouse cursor in the middle of the data you want to wrap and press the Alt+Enter key.

2. Quick summation = quick summation

Some simple data summation, do not need to manually enter the summation function, directly select the empty cell area next to the data, press Alt+= to quickly sum.

3. Alt + ↓ quickly generate drop-down menu

Sometimes you need to enter duplicate data in the cells above, then the best way is the drop-down menu, you can select the data directly, and press Alt+ ↓ in the next empty cell of the data to quickly generate a temporary drop-down menu.

4.Alt picture alignment cell

When inserting a picture in the excel table, you need to align the picture to the cell. the fastest way is to hold down the alt key and drag the picture to the cell to resize it so that it can automatically absorb and align the cell.

5.Alt moves data across tables

Sometimes you need to move the data from this worksheet to another worksheet, you can select the data area and hold down the alt key, drag the data to another worksheet with the mouse, and hold down the Ctrl+Alt key if you want to copy data across the table.

This is the end of this article on "what are the skills for using Alt keys in excel?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.