ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do you show on toolbar the icon which does "paste as value"? (https://www.excelbanter.com/excel-discussion-misc-queries/141074-how-do-you-show-toolbar-icon-does-paste-value.html)

dragomira

how do you show on toolbar the icon which does "paste as value"?
 
i use the "paste as values" function a lot. i know how to do it but i know
that there is an icon you can place on your toolbar which is a shortcut to
this function. how do i find it and put it on my excel toolbar?

thanks
dragomira

Vergel Adriano

how do you show on toolbar the icon which does "paste as value"?
 
dragomira,

in Excel 2003,

1. Right click on your toolbar
2. Click customize
3. Go to Commands tab
4. on left hand side, select Edit
5. on right hand side, look for "Paste Values" and drag it to your toolbar.


--
Hope that helps.

Vergel Adriano


"dragomira" wrote:

i use the "paste as values" function a lot. i know how to do it but i know
that there is an icon you can place on your toolbar which is a shortcut to
this function. how do i find it and put it on my excel toolbar?

thanks
dragomira



All times are GMT +1. The time now is 12:04 AM.

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