Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to copy entire text box and paste in new cell
I'm used to using ClarisWorks or Appleworks, but our district doesn't support
is iny longer. I'm trying to figure out how to use Excel to create my schedule and lesson plan forms that I use regularly. I can't find easy ways to copy and paste text boxes to other cells or move text boxes around accurately. I know I can drag a text box, but that isn't very accurate. On Appleworks I could use the little arrow keys and be very precise about where the boxes sat on the chart. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to copy entire text box and paste in new cell
Hi delbrick. If you hold down the control key whille the text box is
selected, you can use the arrow keys to move it. HTH -- Sincerely, Michael Colvin "delbridk" wrote: I'm used to using ClarisWorks or Appleworks, but our district doesn't support is iny longer. I'm trying to figure out how to use Excel to create my schedule and lesson plan forms that I use regularly. I can't find easy ways to copy and paste text boxes to other cells or move text boxes around accurately. I know I can drag a text box, but that isn't very accurate. On Appleworks I could use the little arrow keys and be very precise about where the boxes sat on the chart. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to copy entire text box and paste in new cell
You can use ctrl-shift and click and drag to copy in the same plane--vertical or
horizontal. You can use the ctrl-alt and click and drag to copy and snap to a cell's border. (Drop the ctrl portion if you want to move the object--not copy.) One the Drawing toolbar, you can click on the Draw icon and see Snap, Nudge, Align or Distribute, too. And if you want, you could try John Walkenback's PUP utilities: http://j-walk.com/ss/products.htm In particular: http://j-walk.com/ss/pup/pup6/features.htm look for "Object Align, Size & Space" delbridk wrote: I'm used to using ClarisWorks or Appleworks, but our district doesn't support is iny longer. I'm trying to figure out how to use Excel to create my schedule and lesson plan forms that I use regularly. I can't find easy ways to copy and paste text boxes to other cells or move text boxes around accurately. I know I can drag a text box, but that isn't very accurate. On Appleworks I could use the little arrow keys and be very precise about where the boxes sat on the chart. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to copy entire text box and paste in new cell
Great, that worked. Now, how about copying a text box and pasting in another
cell? "delbridk" wrote: I'm used to using ClarisWorks or Appleworks, but our district doesn't support is iny longer. I'm trying to figure out how to use Excel to create my schedule and lesson plan forms that I use regularly. I can't find easy ways to copy and paste text boxes to other cells or move text boxes around accurately. I know I can drag a text box, but that isn't very accurate. On Appleworks I could use the little arrow keys and be very precise about where the boxes sat on the chart. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to copy entire text box and paste in new cell
Right click on its edge.
Edit|Copy then edit|paste somewhere else delbridk wrote: Great, that worked. Now, how about copying a text box and pasting in another cell? "delbridk" wrote: I'm used to using ClarisWorks or Appleworks, but our district doesn't support is iny longer. I'm trying to figure out how to use Excel to create my schedule and lesson plan forms that I use regularly. I can't find easy ways to copy and paste text boxes to other cells or move text boxes around accurately. I know I can drag a text box, but that isn't very accurate. On Appleworks I could use the little arrow keys and be very precise about where the boxes sat on the chart. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|