Excel is a commonly used office software by teachers. Many of the teachers' work is inseparable from it. Teachers who are proficient in some shortcut keys can often do more with less. Are you familiar with these shortcut keys?
Complete cell entry and select the next cell: Enter
Wrap a line in a cell: Alt+Enter
Fill the selected range of cells with the current entry: Ctrl+Enter
Select the previous cell up: Shift+Enter
select the bottom right One cell: Tab
to the left Select the previous cell: Shift+Tab
Cancel input: Esc
Move one position up, down, left or right: Arrow keys
move directly to the beginning of the line: Home
Repeat the last operation: F4 or Ctrl+Y
Fill Down: Ctrl+D
Fill Right: Ctrl+R
Define Name: Ctrl+F3
Insert Hyperlink: Ctrl+K
Activate Hyperlink: Enter
Input Date: Ctrl+;
Input Time: Ctrl+Shift+:
Display in the current column of the list The value drop-down list: Alt+Down Arrow
Display the value drop-down list in the current column of the list: Alt+Down Arrow
Undo the last action: Ctrl+Z
In addition, teachers can also upload to Easy Check Score to generate a powerful query system after completing the Excl forms such as student scores and health collection forms, so that students can query their own scores with the query conditions. , but it should be noted that the Excel sheet uploaded using the Easy Check Score System must not contain complex functions. You need to paste all of them as values before uploading, otherwise the uploaded results will be wrong.
Easy Checkpoint is an online query system and form filling system generation tool. Teachers only need to upload the Excel form of the student's score sheet, and an exclusive online score query system will be generated. Easy Check Score is suitable for all kinds of schools, training institutions, teachers, and class teachers. It can be used for weekly exams, monthly exams, mid-term and final exams, admission inquiries, class placement inquiries, homework inquiries, parent notices, filling in materials, checking information, and registration. , can also be used for salary inquiry, water and electricity property inquiry and so on. This is especially recommended for teachers, everyone can try it by themselves!
The above Excel operation skills are recommended for teachers to save and save in case of emergency!
🙋♂️Scan the QR code below👇
Unlock more EasyCheck details!
👆 Scan the code to unlock more exclusive information on Easy Check Score !
X
This content is organized and pushed by Excel Teachers' Office Skills Daquan
Follow us every day to get exclusive Excel practical teaching tips
Excel teacher's office skills Daquan, teacher teaching is watching!