General tips for registering people entering the store during the epidemic
1: Format brush
The use of Format Painter is very simple. Just click the Format Painter, then select the format to be copied, and finally select the cells to be modified, which can be modified in batches.
2: Quickly insert blank lines
out out out out out from the Shift key and when the mouse changes to a double arrow, drag down the number of rows you want to insert.
3: Insert content in batches with spaces
Ctrl+H selects empty values, and enters Ctrl+enter to batch input content in the selected cells.
4: Make a drop-down menu
Select all the cells that need to make drop-down boxes, and then click [Data]-[Data Tools]-[Data Validation]-[Settings]-[Verification Conditions]-[Sequence]-[Source]-[Enter Drop-down Box Data]- [OK] That’s it.
5: Quickly split cells
First, copy the content in the cell, then right-click the mouse and select [Text Format] from the paste options.
Recommended by Huajun editor
Registration form for people entering the store during the epidemicIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Epidemic Protection Registration Form,Enterprise application formDownload to get the source file, which you can edit, modify and replace. To download the electronic version of the attendance sheet, go to Huajun Software Park.
it works
it works
it works