These shortcuts have really come in handy with the 2007 versions of Word and Excel. I keep my shortcut list in a small window I can Alt-Tab (or Alt-Esc) to when I want to refresh my memory. Now get into the habit of opening your shortcut file each time you start working in Word or Excel. Follow the instructions above to select, copy, and paste the shortcuts into a new file you save with the. To create a similar shortcut-reference list for Excel, go to Microsoft's compilation of Excel shortcut and function keys. Select the shortcuts, press Ctrl-C to copy the text, open Notepad or any text editor, press Ctrl-V to paste the list into a new file, and save the file with the. Start by browsing Microsoft's list of keyboard shortcuts for Word. That's why I created separate text files I refer to when I'm working in one of those two programs. My shortcuts.txt file is getting overloaded, but it doesn't include any of the handy keystroke combos available in Word and Excel. Then a couple of months later I added key combinations for moving and resizing windows.
There are simply too many useful key combinations to remember, which is why I described how to create a keyboard-shortcut cheat sheet last April. But you may not know that pressing Alt-Esc moves between your open windows in the order they were opened. Note: You need to hold Ctrl + ALT key together and then press “V” to open paste special dialogue box.If you're familiar with keyboard shortcuts, you probably know that you can cycle through your open windows by pressing Alt-Tab. Now hold “Ctrl + ALT” and press “V” to open the “Paste Special’ dialogue box. The second shortcut key is to open paste special dialogue box is “Ctrl + ALT + V” this will open up the paste special dialogue box, and from there on, press “V” to select the “Values” option.Ĭopy the range of cells to be pasted, then select the targeted cell where we need to paste as values. #2 – Paste Values Using Shortcut Key “Ctrl + ALT + V” After selecting the “Values” option, click on the “Ok” button to get only values.From this list, we need the option of “Values” so to select this option in this window, we can press the shortcut alphabet “V,” and it will choose the “Values” options in this “Paste Special” window.Now press the shortcut key “ALT + E + S” (all keys one by one, do not hold any key), it will open up a wide variety of paste special options.Now select the cell or range of cells where we need to paste the copied data.Follow the steps to paste values in excel using shortcut key.
0 kommentar(er)
