Excel Keyboard Shortcuts – My Top 5 List
There is, I assure you, a very high degree of correlation between amount of time you spend on Excel, and the number of Excel keyboard shortcuts you know. Over time, it becomes especially aggravating to move your hands from the keyboard and on to your mouse in order to use some feature or the other in Excel. It might seem like a trifling thing to begin with, but those seemingly inconsequential seconds can add up to become entire eras in their own right.
Which is why keyboard shortcuts are a blessing from above, and which is why you should know as many as possible. I’ll let you in on a little secret though: even power users have their own personal favorites that they just can’t do without! And in this tutorial on MS Excel, I am going to talk about my personal top five keyboard shortcuts. They aren’t rocket science, each of these five, but if you integrate them into your routine while working on Excel, you’ll soon find yourself saving a lot of time.
- Alt+E+S: The Paste Special is a tool that has saved many an Excel user from collapsing in a heap on the psychiatrist’s couch, and with good reason. It allows you to copy cells over with special tips and tricks, such as pasting cells and retaining only the values, or only the formats, – or what-have-you. You can even paste the data after transposing it, that is, you can copy a row of data, and paste it as a column. But invoking the magic in Excel can be done by either clicking on the little black triangle under Paste on the Home ribbon…
or by hitting Alt+E+S. And once you have practiced it a bit, you’ll see that the keyboard shortcut works a lot better and a lot faster. Go ahead, practice it for a while, we’ll wait.
2. CTRL+Pg Up and CTRL+Pg Dn: This one took me a while to get used to actually, and I’ll admit, it was immensely frustrating until I did make it a habit. Windows users have been indoctrinated thoroughly into using Alt + Tab when they want to switch windows – and the natural tendency of Excel users is to hit that same combination of keys if they want to switch sheets in an Excel file. Except, of course, it doesn’t quite work that way. To switch sheets, you need to hit CTRL+ Pg Up or CTRL + Pg Dn. Keep this Excel 2010 keyboard shortcut in mind to save yourself the trouble of going “Arrrgghh!” every few minutes or so. I speak from personal experience!
3. Alt+W+V+G: Spreadsheets sans gridlines look much better than, well spreadsheets non-sans gridlin