I'd like to just copy or move cells or cell ranges and have lines and shapes come along for the ride, and disembark with the same orientation. E.g. if cell E29 has an arrow through his head, I'd like AA66 to after copying there.
I haven't got the knack of when I've selected enough to grab the shape. Sometimes I think I've got it but when I paste I discover that the slippery critter stayed at home. But sometimes I just cut one cell and the shapes move too.
Any advice? BTW, I stay on the keyboard, and off the mouse, as much as possible - I'd like to avoid slowing down to make mouse selections.
I would like to ask I had draw a few shapes in a page within a sheet....But there is no enough space for a page to fit in all the shapes, so how can i write VB code to extend some of the shapes to the next page?
I would like to ask how to align all the shapes in a consistent way using VBA?
Hello,
I can't figure out a way to make a duplicate copy of a spreadsheet containing inserted shapes (squares, arrows, etc.) without loosing all of the shapes. When I make a copy of a spreadsheet like this, all of the normal data in the spreadsheet copies, but I have to spend lots of time reproducing the shapes on the newly created spreadsheet by inserting them from the Excel menu. Is there an easier way?
Thanks in advance,
Snoopy007
Please suggest how i can get more shapes (simple as well as 3D ) in Auto
Shapes of drawing toolbar in excel & word?
Example: for bold .... ctrl+B
like that for what is keyboard shortcut for "Align Left " and "Align Right "
in excel? pls tell me
I know a shape can move from a text, but how a shape can move from another shape? Because the problem I have is the following : I have 3 shapes (embedded ole excel) and 3 checkbox to determine which ones will be visible or not. So, the shapes are one over the others. I want shapes floating. How can I do that ? Thank you in advance.
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
