Best regards. . How to process? In a blank worksheet, it selects the entire worksheet. Instead of Ctrl+D, just enter Ctrl+enter. You can use the Fill command to fill a formula into an adjacent range of cells. The steps below will lead you to the answer to this question, so follow along. I have the same problem as Harris above. Stack Overflow for Teams is moving to its own domain! I have a totally off topic question How did you get the cool 16-bit looking color depth in the office graphic? How to Apply the Formula to the Entire Column in Excel? . Alternate Data for Alternate Row in a column, Extract a single instance of each entry in a large matrix.