Shulou(Shulou.com)06/02 Report--

What are the common skills of Excel? I believe many inexperienced people don't know what to do about it. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

EXCEL table is mainly for data, for data classification is inevitable, classification is some of the basic operations in EXCEL, the following, to introduce to you, teach you a quick classification method.

Create a new table:

A quick way to sort them: select the data, and then ctrl + T quickly create it, as shown in the following figure

Click OK

In the second column, we only look at the mage:

Isn't it convenient.

Shortcut keys for working with worksheets:

Ctrl+A   selects the entire worksheet.

Ctrl+B   applies or cancels bold formatting

Ctrl+C   copies the selected cell.

Ctrl+D   uses the fill Down command to copy the contents and formatting of the topmost cell in the selected range to the following cell.

Ctrl+F   displays the find dialog box.

Ctrl+G   displays the location dialog box.

Ctrl+H   displays the find and replace dialog box.

Ctrl+I    applies or cancels skew formatting.

Ctrl+K   displays the insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks

Ctrl+L displays the create list dialog box

Ctrl+N create a new blank file

Ctrl+O displays the Open dialog box to open or find a file

Ctrl+P printing

Ctrl+R padding to the right

Ctrl+S save

Ctrl+U apply or ununderline

Ctrl+V paste

Ctrl+W closes the selected window

Ctrl+X shear

Ctrl+Y repeats the operation of the previous command

Ctrl+Z undo

After reading the above, have you mastered the common skills of Excel? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.