Cells N2 through N6 contain some data.
If I select those cells and issue the copy command, then go to cell N7 and hold down the SHIFT KEY and PGDOWN to select a certain area, and then press 'Enter; then the initial cells (N2:N6) get copied in all the cells. BUT.... if I do SHIFT PGDOWN twice, and press 'Enter', I only get one single copy of the original cells.
Also, if I do the SHIFT PGDOWN twice and then select just one more cell down with the arrow key, it will paste all of the original data in all of the cells.
Similarly, if I use SHIFT-END and the down arrow to select a certain area, the same thing happens.
What gives? Why should it matter how the cells are selected that determines what will be pasted?
If I select those cells and issue the copy command, then go to cell N7 and hold down the SHIFT KEY and PGDOWN to select a certain area, and then press 'Enter; then the initial cells (N2:N6) get copied in all the cells. BUT.... if I do SHIFT PGDOWN twice, and press 'Enter', I only get one single copy of the original cells.
Also, if I do the SHIFT PGDOWN twice and then select just one more cell down with the arrow key, it will paste all of the original data in all of the cells.
Similarly, if I use SHIFT-END and the down arrow to select a certain area, the same thing happens.
What gives? Why should it matter how the cells are selected that determines what will be pasted?