Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for paste special?
hi, trying to find shortcut for paste special, prefer to have preset choice
such as past-special-formatting (have many single-cell pasting to do) not good at macro's yet, so if need / have script lines (so I don't fat thumb it) & can paste in with macro have.. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for paste special?
Sounds like you could use some icons on your toolbar.
My suggestion is to create a new toolbar and put all the different paste options in it. Here's how... --------------------------- CREATE A NEW TOOLBAR... Right-click on any of the icons on the toolbars at the top of the worksheet. A menu will appear with 'Customize...' at the bottom. Select 'Customize...'. Select the 'Toolbars' tab. Select the 'New' button. A TextBox will appear saying 'Custom 1'. It is asking you for a new name for the toolbar. Let's call it 'PasteMenu', so type 'PasteMenu' where it says 'Custom 1'. Don't type the quotation marks :O. Now select 'OK'. A toolbar with nothing in it will appear somewhere toward the middle of your screen. --------------------------- PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. What we want to do is put all those 'paste' icons on the 'PasteMenu' toolbar. Highlight and hold down the left-mouse-button over the word 'Paste'. Drag the 'Paste' icon over to the 'PasteMenu' toolbar. Release the mouse so that the icon 'drops' onto the toolbar. Repeat for 'Paste Special...' Scroll down a bit and you will see other 'paste' options. Repeat the above dragging instructions for 'Paste as Hyperlink' Repeat the above dragging instructions for 'Paste formatting' Repeat the above dragging instructions for 'Paste Values' Select the 'Close' button on the 'Customize' window to close it. --------------------------- PUT THE 'PASTEMENU' TOOLBAR UP WITH THE REST OF THE TOOLBARS... Put your cursor over the word 'PasteMenu' on the 'PasteMenu' toolbar. Hold down the left-mouse-button and drag the toolbar up to the top menus to a place that is convenient for you. --------------------------- At this point, I would close out of Excel to give Excel the opportunity to remember where and what your new menu is. Re-open Excel and your menu should be exactly where you put it and ready to go! If, at a later date, you find you don't like the toolbar, open the 'Customize' toolbar as indicated above. Select the 'Toolbars' tab. Highlight 'PasteMenu' and select 'Delete'. This will totally delete the toolbar. If you just want it to not show, unclick the checkbox next to 'PasteMenu'. Now it is still available for a later time but is not visible. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "nastech" wrote: hi, trying to find shortcut for paste special, prefer to have preset choice such as past-special-formatting (have many single-cell pasting to do) not good at macro's yet, so if need / have script lines (so I don't fat thumb it) & can paste in with macro have.. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for paste special?
did not know those buttons were available, thanks, will give it a check.
"Gary L Brown" wrote: Sounds like you could use some icons on your toolbar. My suggestion is to create a new toolbar and put all the different paste options in it. Here's how... --------------------------- CREATE A NEW TOOLBAR... Right-click on any of the icons on the toolbars at the top of the worksheet. A menu will appear with 'Customize...' at the bottom. Select 'Customize...'. Select the 'Toolbars' tab. Select the 'New' button. A TextBox will appear saying 'Custom 1'. It is asking you for a new name for the toolbar. Let's call it 'PasteMenu', so type 'PasteMenu' where it says 'Custom 1'. Don't type the quotation marks :O. Now select 'OK'. A toolbar with nothing in it will appear somewhere toward the middle of your screen. --------------------------- PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. What we want to do is put all those 'paste' icons on the 'PasteMenu' toolbar. Highlight and hold down the left-mouse-button over the word 'Paste'. Drag the 'Paste' icon over to the 'PasteMenu' toolbar. Release the mouse so that the icon 'drops' onto the toolbar. Repeat for 'Paste Special...' Scroll down a bit and you will see other 'paste' options. Repeat the above dragging instructions for 'Paste as Hyperlink' Repeat the above dragging instructions for 'Paste formatting' Repeat the above dragging instructions for 'Paste Values' Select the 'Close' button on the 'Customize' window to close it. --------------------------- PUT THE 'PASTEMENU' TOOLBAR UP WITH THE REST OF THE TOOLBARS... Put your cursor over the word 'PasteMenu' on the 'PasteMenu' toolbar. Hold down the left-mouse-button and drag the toolbar up to the top menus to a place that is convenient for you. --------------------------- At this point, I would close out of Excel to give Excel the opportunity to remember where and what your new menu is. Re-open Excel and your menu should be exactly where you put it and ready to go! If, at a later date, you find you don't like the toolbar, open the 'Customize' toolbar as indicated above. Select the 'Toolbars' tab. Highlight 'PasteMenu' and select 'Delete'. This will totally delete the toolbar. If you just want it to not show, unclick the checkbox next to 'PasteMenu'. Now it is still available for a later time but is not visible. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "nastech" wrote: hi, trying to find shortcut for paste special, prefer to have preset choice such as past-special-formatting (have many single-cell pasting to do) not good at macro's yet, so if need / have script lines (so I don't fat thumb it) & can paste in with macro have.. thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for paste special?
I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section.
Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? "Gary L Brown" wrote: PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. -- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for paste special?
Heidi
CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. Gord Dibben MS Excel MVP On Wed, 17 Jan 2007 07:41:01 -0800, Heidi wrote: I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? "Gary L Brown" wrote: PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. -- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for REPEAT (not Redo)?
Unfortunately, there is a subtle (but important) difference between Repeat
(Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi "Gord Dibben" wrote: CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? "Gary L Brown" wrote: PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. -- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for REPEAT (not Redo)?
Thanks for the correction Heidi.
I had obviously not picked up on the(actually, not so subtle)difference. I don't think there is a Repeat icon. I can not find one in any category. Gord On Thu, 18 Jan 2007 12:11:02 -0800, Heidi wrote: Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi "Gord Dibben" wrote: CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? "Gary L Brown" wrote: PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. -- |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for REPEAT (not Redo)?
Thank you for taking the time to verify that I didn't miss something obvious.
I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi "Gord Dibben" wrote: Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord On Thu, 18 Jan 2007 12:11:02 -0800, Heidi wrote: Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi "Gord Dibben" wrote: CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? "Gary L Brown" wrote: PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. -- |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for REPEAT (not Redo)?
You might try in excel.programming
You might get a quick and easy macro you could stick on a button. Gord On Thu, 18 Jan 2007 17:56:01 -0800, Heidi wrote: Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi "Gord Dibben" wrote: Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord On Thu, 18 Jan 2007 12:11:02 -0800, Heidi wrote: Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi "Gord Dibben" wrote: CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? "Gary L Brown" wrote: PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. -- |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut for REPEAT (not Redo)?
If it's the "button" image (icon) you want, r-click the Toolbar area,
Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select "Repeat Format Cells", click Modify Selection, pick "Copy Button Image" You may now "Paste" it on another button that is on the Toolbar by closing Rearrange commands and Rclicking on the other Button and picking "Paste Button image". Heidi wrote: Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi "Gord Dibben" wrote: Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord On Thu, 18 Jan 2007 12:11:02 -0800, Heidi wrote: Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi "Gord Dibben" wrote: CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? "Gary L Brown" wrote: PUT 'PASTE' ICONS ON THE TOOLBAR... The 'Customize' window is still open. Select the 'Commands' tab. Select the 'Edit' category in the 'Categories:' listbox. On the 'Commands:' side of the Customize window, you'll see a listbox that has Undo / Redo / Cut / Copy / Paste / Paste Special... / etc. -- |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar?
Unfortunately, the icon is not the problem.
What I need is a method to add the REPEAT _command_ (Ctrl+Y) to the toolbar. Any thoughts on how to accomplish this? "Bob I" wrote: If it's the "button" image (icon) you want, r-click the Toolbar area, Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select "Repeat Format Cells", click Modify Selection, pick "Copy Button Image" You may now "Paste" it on another button that is on the Toolbar by closing Rearrange commands and Rclicking on the other Button and picking "Paste Button image". Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar?
Heidi,
Have you tried simply hitting the F4 button on your keyboard? Rob "Heidi" wrote in message ... Unfortunately, the icon is not the problem. What I need is a method to add the REPEAT _command_ (Ctrl+Y) to the toolbar. Any thoughts on how to accomplish this? "Bob I" wrote: If it's the "button" image (icon) you want, r-click the Toolbar area, Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select "Repeat Format Cells", click Modify Selection, pick "Copy Button Image" You may now "Paste" it on another button that is on the Toolbar by closing Rearrange commands and Rclicking on the other Button and picking "Paste Button image". Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar?
Heidi,
By that, I mean that the F4 button acts as a repeat button....at least on my keyboard. Rob "Rob" wrote in message ... Heidi, Have you tried simply hitting the F4 button on your keyboard? Rob "Heidi" wrote in message ... Unfortunately, the icon is not the problem. What I need is a method to add the REPEAT _command_ (Ctrl+Y) to the toolbar. Any thoughts on how to accomplish this? "Bob I" wrote: If it's the "button" image (icon) you want, r-click the Toolbar area, Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select "Repeat Format Cells", click Modify Selection, pick "Copy Button Image" You may now "Paste" it on another button that is on the Toolbar by closing Rearrange commands and Rclicking on the other Button and picking "Paste Button image". Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar?
Heidi,
Back again! This problem intrigued me somewhat and I think I know the solution. Right click the tool bar and select Customise. Then click Edit on your Menu bar and whilst holding down the Ctrl button, click on the "Repeat format cells" or "Can't repeat" command and drag it to the tool bar. And there you have it!! Good luck. Rob "Rob" wrote in message ... Heidi, By that, I mean that the F4 button acts as a repeat button....at least on my keyboard. Rob "Rob" wrote in message ... Heidi, Have you tried simply hitting the F4 button on your keyboard? Rob "Heidi" wrote in message ... Unfortunately, the icon is not the problem. What I need is a method to add the REPEAT _command_ (Ctrl+Y) to the toolbar. Any thoughts on how to accomplish this? "Bob I" wrote: If it's the "button" image (icon) you want, r-click the Toolbar area, Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select "Repeat Format Cells", click Modify Selection, pick "Copy Button Image" You may now "Paste" it on another button that is on the Toolbar by closing Rearrange commands and Rclicking on the other Button and picking "Paste Button image". Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar
Bingo!
Thanks, Rob, for the big boost in my productivity. Why has Microsoft neglected to add this command to the Edit category in the toolbar customize menu??? Heidi P.S. You're suggestion of the F4 key, by the way, wouldn't have helped very much because I normally use a tablet PC (sans keyboard). Heidi, Back again! This problem intrigued me somewhat and I think I know the solution. Right click the tool bar and select Customise. Then click Edit on your Menu bar and whilst holding down the Ctrl button, click on the "Repeat format cells" or "Can't repeat" command and drag it to the tool bar. And there you have it!! Good luck. Rob Heidi, By that, I mean that the F4 button acts as a repeat button....at least on my keyboard. Rob Heidi, Have you tried simply hitting the F4 button on your keyboard? Rob "Heidi" wrote in message ... Unfortunately, the icon is not the problem. What I need is a method to add the REPEAT _command_ (Ctrl+Y) to the toolbar. Any thoughts on how to accomplish this? "Bob I" wrote: If it's the "button" image (icon) you want, r-click the Toolbar area, Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select "Repeat Format Cells", click Modify Selection, pick "Copy Button Image" You may now "Paste" it on another button that is on the Toolbar by closing Rearrange commands and Rclicking on the other Button and picking "Paste Button image". Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar?
Sorry, I thought you wanted a copy of the image, I see Rob has "shown"
you the copy a button routine. So all is well. Heidi wrote: Unfortunately, the icon is not the problem. What I need is a method to add the REPEAT _command_ (Ctrl+Y) to the toolbar. Any thoughts on how to accomplish this? "Bob I" wrote: If it's the "button" image (icon) you want, r-click the Toolbar area, Customize, Commands, Rearrange commands, set Menu Bar to "Edit", Select "Repeat Format Cells", click Modify Selection, pick "Copy Button Image" You may now "Paste" it on another button that is on the Toolbar by closing Rearrange commands and Rclicking on the other Button and picking "Paste Button image". Thank you for taking the time to verify that I didn't miss something obvious. I think I might begin a new thread with this specific challenge rather than piggyback onto the Paste Special question posed in the original posting. Do you think this is the appropriate forum for this question? If not, where do you think I should post it? Thanks again, Heidi Thanks for the correction Heidi. I had obviously not picked up on the (actually, not so subtle) difference. I don't think there is a Repeat icon. I can not find one in any category. Gord Unfortunately, there is a subtle (but important) difference between Repeat (Ctrl+Y) and Redo. Example: Mark a cell and apply a format. Notice that Redo button is remains dormant. Select Edit from the menu. Notice that Repeat (Ctrl+Y) operation is available with the format operation activated (Repeat Format Cells). Do your have any other suggestions? Thanks in advance, Heidi CTRL + Y is "Redo" in the list in the "Edit" category. Drag it up to your Toolbar. I could not locate the Repeat (Ctrl+Y) command in the 'Edit' section. Excel's Help does not explain how this command can be added to Excel's Toolbar. Do you have any suggestions? |
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar
Yes, not only did Rob solve my immediate problem, he taught me a whole new
way to customize the toolbar. I still wonder why Microsoft has omitted this command in the Edit category in the toolbar customize menu... "Bob I" wrote: Sorry, I thought you wanted a copy of the image, I see Rob has "shown" you the copy a button routine. So all is well. Bingo! Thanks, Rob, for the big boost in my productivity. Why has Microsoft neglected to add this command to the Edit category in the toolbar customize menu??? Heidi P.S. You're suggestion of the F4 key, by the way, wouldn't have helped very much because I normally use a tablet PC (sans keyboard). Heidi, Back again! This problem intrigued me somewhat and I think I know the solution. Right click the tool bar and select Customise. Then click Edit on your Menu bar and whilst holding down the Ctrl button, click on the "Repeat format cells" or "Can't repeat" command and drag it to the tool bar. And there you have it!! Good luck. Rob |
#18
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add the REPEAT (not Redo) command to Excel's toolbar
Maybe oversight? No reason not to have it there.
Heidi wrote: Yes, not only did Rob solve my immediate problem, he taught me a whole new way to customize the toolbar. I still wonder why Microsoft has omitted this command in the Edit category in the toolbar customize menu... "Bob I" wrote: Sorry, I thought you wanted a copy of the image, I see Rob has "shown" you the copy a button routine. So all is well. Bingo! Thanks, Rob, for the big boost in my productivity. Why has Microsoft neglected to add this command to the Edit category in the toolbar customize menu??? Heidi P.S. You're suggestion of the F4 key, by the way, wouldn't have helped very much because I normally use a tablet PC (sans keyboard). Heidi, Back again! This problem intrigued me somewhat and I think I know the solution. Right click the tool bar and select Customise. Then click Edit on your Menu bar and whilst holding down the Ctrl button, click on the "Repeat format cells" or "Can't repeat" command and drag it to the tool bar. And there you have it!! Good luck. Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
right click menu shortcut changed from 2002 to 2003 | Excel Discussion (Misc queries) | |||
keyboard shortcut for paste special | Excel Discussion (Misc queries) | |||
how can you customize a shortcut menu in excel? | Excel Discussion (Misc queries) | |||
Keyboard shortcut for "copy paste special values?" | Excel Discussion (Misc queries) | |||
Know of a shortcut for Paste Special Values? | Excel Discussion (Misc queries) |