#1   Report Post  
Posted to microsoft.public.excel.misc
ceemo
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copied formulas paste as values Trev Excel Discussion (Misc queries) 2 February 11th 06 05:09 AM
Paste Values Dave Excel Discussion (Misc queries) 1 June 11th 05 10:43 PM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 1 June 11th 05 12:44 AM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 0 June 10th 05 03:38 PM
Paste values GDC Excel Worksheet Functions 0 June 9th 05 05:18 PM


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"