Skip to content

Instantly share code, notes, and snippets.

@boy3vil

boy3vil/create shortkey paste value in MS EXCEL

Last active December 22, 2015 01:19
Show Gist options
  • Save boy3vil/6395746 to your computer and use it in GitHub Desktop.
Save boy3vil/6395746 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create shortkey paste value in MS EXCEL
1. Tekan Alt+F8 untuk menampilkan Macro dialog box.
2. Buat nama untuk shortkey, dan sesuaikan kode berikut
Sub PasteVal()
Selection.PasteSpecial Paste:=xlValues
End Sub
3. Klik option untuk menuju penyesuaian tombol pemanggilan atau shortkey
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment