You can copy a selection across or down, into the remaining cells of a grid card or the primary of a worksheet. 

You can use Copy across and Copy down on up to 10,000 cells. You'll need write access to the target cells.

To copy a cell across or down, select a cell in a grid card or worksheet, then select Copy across or Copy down .

    • To copy the selection to compatible cells to the right, right-click your selection and select Copy across .
    • To copy the selection to compatible cells below, right-click your selection and select Copy down .
    • If your grid card is maximized, you can also select Copy across or Copy down .

To copy a block of cells down or across, select a block of cells in a maximized grid card or worksheet, then select Copy across or Copy down .

Note: You can select more than one cells as long as the cells you select are next to each other.