ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Quickest alternative for shortcut of PasteSpecial then Values (https://www.excelbanter.com/excel-worksheet-functions/89257-quickest-alternative-shortcut-pastespecial-then-values.html)

rony4icab

Quickest alternative for shortcut of PasteSpecial then Values
 

Hi!
All Excel Genious,

Pls help me to any quickest alternative from this boring shortcut
*Alt,E,S,V then Enter*.

Thanks all in advance.

Nazmul Haque,
E-mail:
Bangladesh.


--
rony4icab
Posted from -
http://www.officehelp.in


Héctor Miguel

Quickest alternative for shortcut of PasteSpecial then Values
 
hi, Nazmul Haque !

... any quickest alternative from this boring shortcut *Alt,E,S,V then Enter*.


try customizing a commandbar, adding a commandbutton for 'paste values'
- tools / customize / [commands tab]
- under categories / edit
- find/copy/drag/... - paste vaues [button]
below paste formats [button]

BTW, if you shift-click each of these buttons, performs the actions of each-other ;)

hth,
hector.



rony4icab

Quickest alternative for shortcut of PasteSpecial then Values
 

Hi!!
Hector Miguel ,
Thanks a lot to dear Hector Miguel for your reply of my problem.
Nazmul Haque,
E-mail:
Bangladesh.


--
rony4icab
Posted from -
http://www.officehelp.in



All times are GMT +1. The time now is 02:31 PM.

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