Copy/Paste on Mac's Excel

Apple Mac os x server v10.6 snow leopard...
May 10, 2010 at 12:43:24
Specs: Macintosh, Office Version 12.2.4 2007
In Mac's Excel how can I paste data from different rows
(for example, A4, D4 and M4) into another sheet keeping
the same distance (to A4-D4-M4 on another sheet)?
Thanks for help.

See More: Copy/Paste on Macs Excel

Report •


#1
May 10, 2010 at 15:35:48
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.


Report •

#2
May 11, 2010 at 08:06:50
Thank you (I did mean rows - A4-A10-A22, sorry for mistake), but I guess the answer is same.

Report •

Related Solutions


Ask Question