What are the common skills of Excel?
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!
