To fill up/down cells from different columns at the same time, first select the desired cells you want to duplicate from the first column then all the upper/down cells you want to fill in, then hold pressed the CTRL key and select the same selection of rows from the next column then go to menu Task – Fill and click Fill Down or Fill Up button.
Note: If you select cells from different columns that don’t have the same selection of rows, the fill up/down functionality cannot be applied.