ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying autoshapes - XL2K (https://www.excelbanter.com/excel-discussion-misc-queries/13491-copying-autoshapes-xl2k.html)

Ildhund

Copying autoshapes - XL2K
 
If I draw a rectangle (or AFAICS any other two-dimensional autoshape), copy
it, move to another cell and paste, the copy appears at the active cell. If
I do the same with a line, the copy appears as far away from the active cell
as the line I copied was from A1.
(1) Why?
(2) Is there any way I can get the line to appear at the active cell?

At the moment I am getting round the problem by using Ctrl+drag to place
copies. That's not so bad on a regular keyboard but it's a pain on my
laptop.
--
Noel



Dave Peterson

I don't get that effect in xl2003.

You may want to post your version so that others can verify/help.

Ildhund wrote:

If I draw a rectangle (or AFAICS any other two-dimensional autoshape), copy
it, move to another cell and paste, the copy appears at the active cell. If
I do the same with a line, the copy appears as far away from the active cell
as the line I copied was from A1.
(1) Why?
(2) Is there any way I can get the line to appear at the active cell?

At the moment I am getting round the problem by using Ctrl+drag to place
copies. That's not so bad on a regular keyboard but it's a pain on my
laptop.
--
Noel


--

Dave Peterson

Dave Peterson

Oops. I see you put the version in the subject. (I didn't see it there.)

Ildhund wrote:

If I draw a rectangle (or AFAICS any other two-dimensional autoshape), copy
it, move to another cell and paste, the copy appears at the active cell. If
I do the same with a line, the copy appears as far away from the active cell
as the line I copied was from A1.
(1) Why?
(2) Is there any way I can get the line to appear at the active cell?

At the moment I am getting round the problem by using Ctrl+drag to place
copies. That's not so bad on a regular keyboard but it's a pain on my
laptop.
--
Noel


--

Dave Peterson


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com