I have been playing around with it and discovered that if you copy a cell and then paste (i.e. CTRL+V), then a smart tag will appear next to the cell you just pasted in. If you press CTRL, the smart tag menu appears, and thenyou can select the option you want by pressing the letter on the keyboard associated with that option.
So then, my shortcut ended up being CTRL+V, CTRL, E
What you are doing requires the use of mouse. If you want to strictly use the keyboard then use the Alt option. On Excel-2013, I use the below.
Values : Alt+H+V+A
Formatting Alt+H+V+K
If you use a different version of Excel then press Alt and look at the character that appears on the Ribbon for each of the action. Eg: Alt+H would enable the Home Ribbon and then show the character to be used for different buttons on that ribbon.
What you are doing requires the use of mouse. If you want to strictly usethe keyboard then use the Alt option. On Excel-2013, I use the below.
Values : Alt+H+V+A
Formatting Alt+H+V+K
If you use a different version of Excel then press Alt and look at the character that appears on the Ribbon for each of the action. Eg: Alt+H would enable the Home Ribbon and then show the character to be used for differentbuttons on that ribbon.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.