There are too many possibilities. For example, when you add a border, you add it after selecting All. For example, if you want to draw a border in A 1:G 1, a border will be added after clicking the line 1. Or, if you want to add a border in A 1:A20, you can add it to the selected column A. Then there are some formulas, such as C 1, input = IF (A 1 = ",A 1 * B 1). This thing is not easy to guess, mainly by experience.