Whether you are still in college or have already entered the workplace, when we use computers, if we need to process data, we will use Excel software. Many times, computer novices set the date and time format in the toolbar. In fact, they all have shortcut keys.
1 Two decimal point format
Companies you may be interested in
Ctrl + shift + 1
This shortcut key will convert your data into two decimal points, and add a comma if it is in thousands.
2 Time format
TIME (hour, minute, second)
Or you can use Ctrl + shift + 2 on RAW Value to get the time.
3 Date Format
Ctrl + shift + 3
As you can see from the picture, the date is calculated based on days, starting from 1/1/1900 as the first day. So wouldn’t it be troublesome if I want today’s date? You can press the shortcut key Ctrl + ; to get today’s date.
4 Add RM symbol
Ctrl + shift + 4
5 Percentage Display
Ctrl + shift + 5
6 Set Percentage
Ctrl + shift + 6
7 Apply the “General” number format
Ctrl + shift + ` ( this is the key to the right of 1) Press this to get the integer.
#8 Check the box in Excel
First, we select Wingdings 2 in the font, and then type the uppercase RQPO according to the picture, and we will get the corresponding check mark.
#9 Current time
Ctrl + shift + ;
*Remember the time I mentioned entering the current date? Ctrl + ; (just missing the shift key)
#10 Select two lines and find the Georgia Phone Number List differences with one click
Ctrl + \
This is super useful when
Checking two data, so you don’t have to read them line by line.
Don’t always complain about working overtime, that’s because you haven’t collected anything yet, why don’t you take notes now! –
Submit your resume on Tiefan.com today!
The system will recommend your ASB Directory resume to suitable employers for job matching, thus increasing the chances of employers contacting you by 3 times.
