|re: how can I paste data from different rows (for example, A4, D4 and M4) |
A4, D4 and M4 are all on the same row - Row 4.
They are, however, in different columns.
As far as I know, the Copy/Paste feature is no different on a Mac than on a Windows based machine.
Unfortunately, you can't paste non-contiguous cells in Excel, keeping the same distance between them.
In order to use Excel's built in Copy/Paste feature, you would have to select the entire range A4:M4 if you want to keep those cells the same distance apart.
If you want to get into some VBA code, it could be done, and it might also be able to accomplish your goal with formulas, but you'd need to be very specific about what you are trying to do.