First, look at the shortcut keys that start with the Ctrl key:
View shortcut keys that start with the Shift key:
View shortcut keys that start with Alt key:
Look at shortcut keys combined with Alt ShiftCtrl:
Finally, look at other shortcut keys:
These are the skills of Excel table shortcuts that we learned today. Does it look simple? Have you learned?
At present, many small partners need to use Excel more and more at work or in other places, but everyone knows how difficult Excel is, and it is not a simple matter to do Excel well.
Don't worry, today Bian Xiao will tell you some necessary shortcut keys in Excel to help you get Excel quickly ~
First, public classes
1. Displays the dialog box.
In Excel, we often need to open various dialog boxes, such as search dialog box, replacement dialog box, positioning dialog box and so on. Many friends can't find the function options to open these dialogs in their usual use. At this time, we can actually use shortcut keys directly to help us complete such an operation.
2. Hide rows or columns
When we want to hide the rows or columns in the table in Excel, many friends will choose to click with the mouse, but this is actually less efficient. At this time, we can also use shortcut keys to help us complete these operations quickly.
Second, practical class.
1. Digital format conversion
When we enter numbers in Excel cells, we sometimes need to format these numbers. At this time, we can directly use these Excel shortcuts to easily complete such operations ~
selecting data
When we want to select data in Excel, we usually use the mouse to select data, but we can also use these more convenient shortcut keys in Excel to complete various operations without leaving the keyboard ~
compile data
Editing data in Excel is also something we often need to do, such as copying cell data, filling data, forcing line breaks and so on. These can be done with these shortcut keys, which is also very convenient.
Ok, here are some very useful shortcut keys in Excel. Do you know them? Try it if you need a little friend ~ you can also collect it first, just in case ~