ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste Values (https://www.excelbanter.com/excel-discussion-misc-queries/87821-paste-values.html)

ceemo

Paste Values
 

Is there a way i cn add paste values to the menu when i right click a
cell ?
I use Paste Values alot and its long winded to keep right clickPaste
SpecialPaste Vales


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=540626


Dave Peterson

Paste Values
 
How about just adding another icon to your favorite toolbar.

Tools|Customize|commands tab|edit category
scroll down the right hand side and drag "paste values" to that favorite
toolbar.

ceemo wrote:

Is there a way i cn add paste values to the menu when i right click a
cell ?
I use Paste Values alot and its long winded to keep right clickPaste
SpecialPaste Vales

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=540626


--

Dave Peterson

Kevin B

Paste Values
 
You can add the paste special command as a toolbar button on the formatting
toolbar:

In Excel, click VIEW on the menu, select TOOLBARS and from the cascade menu
click CUSTOMIZE.

In the dialog box, click the COMMANDS tab and then select EDIT from the
CATEGORIES list box. In the COMMANDS list box, scroll down until you find
the PASTE SPECIAL command and then click and drag the PASTE SPECIAL command
to the toolbar location of your choice.


--
Kevin Backmann


"ceemo" wrote:


Is there a way i cn add paste values to the menu when i right click a
cell ?
I use Paste Values alot and its long winded to keep right clickPaste
SpecialPaste Vales


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=540626




All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com