| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change my default paste settings?
I have quite a bit of data that I need to paste special (Values and
Transpose). I thought I'd be able to change the default paste options to these options but cannot figure out how. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change my default paste settings?
You can add the toolbaricon "Paste-Special" to your Toolbar. It looks like
the Clipboard with the Number "12" in it. You get to it at the menu, View, Toolbars, Cusomize, Commans tab, Edit -- then scrool down Click on and drag up to your toolbar and DROP!!. then exit out... "Sly" wrote: I have quite a bit of data that I need to paste special (Values and Transpose). I thought I'd be able to change the default paste options to these options but cannot figure out how. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change my default paste settings?
Jim May,
That works great for the paste values, can I make it also transpose? "Jim May" wrote: You can add the toolbaricon "Paste-Special" to your Toolbar. It looks like the Clipboard with the Number "12" in it. You get to it at the menu, View, Toolbars, Cusomize, Commans tab, Edit -- then scrool down Click on and drag up to your toolbar and DROP!!. then exit out... "Sly" wrote: I have quite a bit of data that I need to paste special (Values and Transpose). I thought I'd be able to change the default paste options to these options but cannot figure out how. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change my default paste settings?
As a matter of fact, I also have the "Paste Special..." toolbar Icon on my
toolbar; It is added in the same way. "Sly" wrote: Jim May, That works great for the paste values, can I make it also transpose? "Jim May" wrote: You can add the toolbaricon "Paste-Special" to your Toolbar. It looks like the Clipboard with the Number "12" in it. You get to it at the menu, View, Toolbars, Cusomize, Commans tab, Edit -- then scrool down Click on and drag up to your toolbar and DROP!!. then exit out... "Sly" wrote: I have quite a bit of data that I need to paste special (Values and Transpose). I thought I'd be able to change the default paste options to these options but cannot figure out how. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change my default paste settings?
Sly,
I'm working on creating a command button that will perform these functions in one keystroke. I'll keep in touch. You too? "Sly" wrote: I have quite a bit of data that I need to paste special (Values and Transpose). I thought I'd be able to change the default paste options to these options but cannot figure out how. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should allow me to change default number formats | Excel Discussion (Misc queries) | |||
| How do I change the default paste behavior | Excel Discussion (Misc queries) | |||
| how can i change the default settings in excel 2003? | Excel Discussion (Misc queries) | |||
| How do I change default settings to page break preview | Setting up and Configuration of Excel | |||
| How do I change the default settings in charts? | Charts and Charting in Excel | |||
Linear Mode
