The range you select doesn’t have to be continuous. If you want to select cells and/or ranges that aren’t connected, hold down the Control key (PC) or Command key (Mac) as you highlight each range.
There is no way to select multiple non-touching ranges at once. If you need to copy the value into another non-adjacent range, repeat this step and the next step for the next range after pasting into this one.
If the filled cells show up as a pattern, such as a series of increasing numbers, click the icon with a plus sign at the bottom of the selected cells, then select Copy cells.
