First, set the display format of mobile phone numbers in batches.

Select the data area to be set, and then press the shortcut key command+ 1 to bring up the format window. Then click random customization and enter 000-0000-0000 as the type.

Second, set up mobile phone number protection.

Set the mobile phone number protection, which is also used to fill in quickly outside. Just enter a template next to it and press the shortcut key command+e.

Third, change the date to week in batches.

Set the area to be set, and then press the shortcut key command+ 1 to bring up the format window, and select Custom, with the setting type of aaaa.

Fourth, delete blank lines in batches.

First, select the data to be sorted, then press the shortcut key F5 to bring up positioning, select positioning conditions, then select null value and click OK, all blank cells will be selected, and then directly click the right mouse button to select Delete and then select the whole line.

Fifth, cancel merging cells and fill in data in batches.

Cancel merging cells first, then press F5 to bring up positioning, select positioning conditions, click null, enter an equal sign, click the first department name, and press command+ Enter to fill in batches.

Six Fast Summations (command+option =)

Select the data that requires sum first, and then press the shortcut key command+option+= to sum quickly.

Seven, don't print any color.

Press the shortcut key command+p to enter the print preview, and then click Page Setup in the lower left corner. In the pop-up interface, we can click on the worksheet, and then check Monochrome Print, so that no color will be printed.

Eight, print the title line

Click the page layout function group, find the print title, then find the top title line, select the title and click OK. Press the shortcut key command+p to enter the print preview, and you will see that each page has a title.

Click on the external page layout to find the printed title, then select a row of data where the title is located in the top title row, and click OK to preview the title in each selected row.

9. Bulk delete the value of 0

First, press ctrl+H to bring up the replacement, then enter 0 in the search value to replace nothing, then click Options, check the cell matching, and click Replace All.

X. delete all pictures in batches.

Press the shortcut key ctrl+G to bring up the positioning, then click the positioning condition, select the object and click OK, so that all the pictures will be selected, and then just press the delete key to delete the pictures.

XI。 Make a single diagonal title

Enter the score in the cell first, then press option+ Enter to wrap the line in the cell, then enter the name in the second line, enter a few spaces in front of the name, then click on this cell and press command+ 1 to bring up the format window, then select the border, and we can select the diagonal border.

Twelve. Making contrast data bar

First, select the data on the right, find the conditional format, select the data column, and set a data column for it. Then we choose the left, add a data column for him and select other rules, and set the direction to click OK from right to left.

Thirteen, add a value to the data in batches.

Here, we will add 10 to the data in batches. First, we enter 10 in the cell and copy 10. Then, we select the area where we need to add data in batches, click the right mouse button, find selective paste, and select Add in the operation.