On the Protection tab, check the Locked check box and click OK. The password for the downloadable Excel file is "easy". In the Go To Special dialog box, check Constants option, see screenshot:4.Then click OK, and only the value cells have been selected in the list.5.In this case, how could we copy and paste only non-blank cells in Excel quickly and conveniently?Here are some quick tricks for you to solve it: Copy and paste only non-blank cells with Go To Special command Copy and paste only non-blank cells with Filter feature Copy and paste only non-blank cells with Array Formula Copy and paste only non-blank cells with VBA code Copy and paste only non-blank cells with Kutools for Excel Go To Special, see screenshot:3.See screenshot: Note: This method only be available for the constants, it is not applied to the formula cells. Then click the drop down button at the right corner of the cell in the selected list, and uncheck the Blanks option under the drop down menu. And then click OK, all the non-blank cells have been filtered out as following screenshot shown:5.
Note: if you also check the Hidden check box, users cannot see the formula in the formula bar when they select cell A2. You can lock cells in Excel if you want to protect cells from being edited. Before you start: by default, all cells are locked. However, locking cells has no effect until you protect the worksheet. Conditional formatting was applied to cell range A2: A20, formula: =A2 There are 10 red cells in cell range A2: A20 and the user defined function returns 10 i cell D2. This udf can only compare and count cell colors and conditional formatting formulas.