When we are dealing with Excel tables, sometimes there are a lot of data in Excel tables, and the data also contains some blank cells. What should we do if we want to fill all these blank cells with content? One way to share with you is to use Excel positioning function to quickly fill blank cells. The specific operation is explained in detail below. Let's take a look ~Excel uses the positioning function to fill blank cells: 1. Open the file "Locating materials". Xlsx "and select all the cell ranges to be replaced in the Positioning worksheet. 2. Press Ctrl+F to open the Find and Replace dialog box, and enter "99" in the Replace with dialog box without entering anything in the Find What text box under the Replace tab. Click the Replace All button. 3. You can see that all blank cells in the selected area are filled with "99". After mastering the logic of data classification, you can use logic to divide a large number of data. Therefore, it is very important to understand the logic behind things. A person who can learn is usually a person who is particularly good at grasping the logic and laws behind things or information. So, how to use the positioning function to enter "99" in all blank cells? 1. Undo the previous operation and select A 1:E 10 cell area in the positioning worksheet. 2. Press F5 to open the location dialog box, and then click the location criteria button. Tips: If you press F5 without displaying the positioning dialog box, you can press and hold the Fn key on the keyboard first, and then press F5. You can also click Start → Edit Group → Find and Replace → Locate Criteria Options. 3. Open the dialog box of positioning conditions, select the option of null value list, and click OK. 4. You can see all empty cells in the selected data range. 5. Enter "99" and press Ctrl+Enter. Tips: Ctrl+Enter is a quick copy key combination. Using it, you can quickly copy not only the entered value, but also the formula. After selecting a range of cells and entering values or formulas, just press CTRL+ENTER. So, about "How does Excel use positioning function to fill blank cells?" I will simply share it here. Hurry up and follow the above steps! I believe that everyone will soon learn to use the positioning function of Excel ~