Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
push button paste special
I have thousands of formulas on one page, and I need to copy the results to
another page. I've been doing this one at a time, highlight the results, ctrl+c, go to the other page, right click, paste special, paste values and number formats. I heard someone mention something about creating a push button, kind of like a shortcut. Is there a way to do this to make this process any easier? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
push button paste special
switch on macro record, set to relative references, do it once. Create a circle or oval, highlight it, hover over bottom right hand corner, right click, assign macro. That is your button. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=549450 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
push button paste special
Go to menu:
ToolsCustomize Select Commands tab Select [Edit] from left Category listbox Drag [Paste Value] from rgith commands listbox and drop it on your toolbar. -- Best regards, --- Yongjun CHEN ================================== - - - - www.XLDataSoft.com - - - - Free Excel/VBA Tool & Training Material ================================== "pugsly8422" wrote in message ... I have thousands of formulas on one page, and I need to copy the results to another page. I've been doing this one at a time, highlight the results, ctrl+c, go to the other page, right click, paste special, paste values and number formats. I heard someone mention something about creating a push button, kind of like a shortcut. Is there a way to do this to make this process any easier? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste special treats cells as a picture | Excel Discussion (Misc queries) | |||
Paste Special problem □ | Excel Discussion (Misc queries) | |||
excel paste special should allow text | Excel Worksheet Functions | |||
Paste Special | Excel Discussion (Misc queries) | |||
Paste Special Question | Excel Discussion (Misc queries) |