12 December 2016 0 5K Report

Suppose I wish to copy a block of four cells (1010) to the right of a long row without keep pasting it. I attach a pic to illustrate my thought. In this picture I need to copy the 4 cells (1010) highlighted in dark green to the right so as to fill the rest of the row highlighted in light green. I wish the result to be similar to the next row highlighted in dark green. I need to do this in a fast way no matter how long will be the row. So, I am wondering if there is a short formula to achieve that?

Similar questions and discussions