Select and move non adjacent cells in numbers
How can I select and then move multiple non adjacent cells in unison. Is it possible to link non adjacent cells together so they always move together?
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How can I select and then move multiple non adjacent cells in unison. Is it possible to link non adjacent cells together so they always move together?
Ian writes: I can select multiple non adjacent cells this way, but they will not drag.
Likewise.
Here's an example of what can be done:
In an empty 5 by 20 cell table, I entered a series of letters from A to Z plus AA in rows 2 to 10 of columns B to D,
then selected cell B2 (containing "A") by clicking once on that cell.
I then pressed and held the command key and clicked every second cell in columns B, C and D. (The selected cells above can be identified by the blue borders. (Selected cells in column C are in rows where the cells in columns B and D are not selected.),then pressed command-C to Copy the content of the selected cells.
With the cell contents, and the position of each cell in relation to the others, I clicked on cell B11 to select it, then pressed command-V to paste the copied data into that cell and the others located in the same position relative to B11 as the positions of the cells containing the original data relative to cell B2.
To "Move" the originally selected cells (and their contents) to the same locations as seen above could be accomplished by cutting the values (command-X in place of command-C)from the originally selected cells, then repeating the same select B11 and Paste actions as above.
Regards,
Barry
Ian writes: I can select multiple non adjacent cells this way, but they will not drag.
Likewise.
Here's an example of what can be done:
In an empty 5 by 20 cell table, I entered a series of letters from A to Z plus AA in rows 2 to 10 of columns B to D,
then selected cell B2 (containing "A") by clicking once on that cell.
I then pressed and held the command key and clicked every second cell in columns B, C and D. (The selected cells above can be identified by the blue borders. (Selected cells in column C are in rows where the cells in columns B and D are not selected.),then pressed command-C to Copy the content of the selected cells.
With the cell contents, and the position of each cell in relation to the others, I clicked on cell B11 to select it, then pressed command-V to paste the copied data into that cell and the others located in the same position relative to B11 as the positions of the cells containing the original data relative to cell B2.
To "Move" the originally selected cells (and their contents) to the same locations as seen above could be accomplished by cutting the values (command-X in place of command-C)from the originally selected cells, then repeating the same select B11 and Paste actions as above.
Regards,
Barry
Hold Command key, then click multiple non adjacent cells to highlight them. Then select and hold group of cells, then drag to new place, release
I can select multiple non adjacent cells this way, but they will not drag.
Select and move non adjacent cells in numbers