-
<><1.The data is summed in one second.
To calculate the total sales volume in the table below, enter the sum function and select the summing region.
2.Date for quick entry.
Enter the current date:
Select a cell and press [Ctrl] and [; ] two shortcut keys.
Select the cell and press [Ctrl] [Shift] [; Three shortcut keys.
3.ID card information extraction.
Based on the ID number, manually enter the birthday of the first person. Then press the shortcut key [Ctrl+E] to quickly fill in the source rotten and automatically extract other people's birthdays.
4.Super table creation.
The shortcut key [Ctrl+T] converts ** into a super table to quickly beautify the data.
5.Enter the same data in batches.
For filling the same data, in addition to dragging and dropping, you can also use the shortcut key Ctrl+Enter] !
6.Add units to the data and be able to calculate.
Select the area where you want to enter data, bring up the RG general format in the [Custom] window of the cell formatting window, type the element directly, and click [OK]. When entering data, the number will be automatically brought with you after typing the number, and it will not affect the calculation!
7.De-duplicate.
Ctrl+A] Select all data, click [Data] Banquet Potato Item Card - [Column] - [Delete Duplicate Value], and the duplicate data will be deleted at one time!
8.Lightspeed screening.
To filter out all the member information of [Douyin Department], you only need to find a [Douyin Department], right-click the mouse - [Filter] - [Filter by cell value], and all the data of [Douyin Department] will be filtered out.
9.The serial number is updated automatically.
To do **column number, enter 1 and then enter 2 to pull down, in case you delete a line of serial number, it will be all messed up! We can enter [=row ()1] in the second line of the [Serial number] column, press [Enter], and just fill it in!
10.Mobile phone numbers are displayed in segments.
No need to manually type short dashes! First, select the area to be entered data [Ctrl+1] to quickly call it out, set the format of the single splitter grid, window, and change the RG general format to 000-0000-0000 in [Custom].
-
Press "OK" <> finish setting up when the setup is complete.
At this time, click the cell "FC Game", and you can automatically go to the A1 cell of the "FC Game" worksheet.
-
Du Niang has, all the tips ask Du Niang directly.
-
There are a lot of them, so bother searching for them!
Landlord ・ You don't have a clear expression · · What kind of person is it, a nutritious recipe that needs · To give you a**, there are nutritious recipes and therapeutic recipes, I hope you can benefit from it
As for the problem of barcode scanning, it's not a big deal. It's just that your need is not universal, so you can't find the corresponding tool. However, we can provide customization. >>>More
The book of heaven has to match the skills.
Can the landlord send it, do you have extra points for your skills? >>>More
Hello, at present, the cancer insurance on the market is divided into consumer cancer insurance and return cancer insurance, the consumer cancer insurance is more suitable for people with low premium budget and pay attention to the protection function, while the return cancer insurance has the function of saving, the general premium is relatively high, and the insurance period is relatively long. If you are over 35 years old or even older, have good economic conditions and pay more attention to the savings function, you can choose the return type. You can compare and choose insurance companies according to your actual situation, or you can also refer to this link. >>>More
See if it's the content you want.
Search: Beijing Futongville Technology ******, the first article of the company's dynamics, there are many versions in it**,**Later, please spend 5 to 10 minutes carefully reading the operation help, which will be helpful to you. Including [Warehouse Enterprise Edition] [Invoicing Enterprise Edition] [Standard Free Edition]. >>>More