Forum Discussion
DylanP
Jan 15, 2019Copper Contributor
"I wish you'd shown me this years ago!" A short discussion on some Excel Shortcuts
"I wish you'd shown me this years ago!" This is the phrase I've probably heard more than any other when I teach Excel. I've run a few classes at my workplace, and when I explain some of the keybo...
Nauthstar
Jan 17, 2019Iron Contributor
Hi,
Using Excel, the thing you want to do may be done in several different ways. I've found that those things which might feel like a shortcut to one person may not be to another. For example, your tip
"or the Alt-key sequences (like Alt, A, T to enable the quick filter)"
Which involves pressing the keys separately, might be replaced with (Shift+Ctrl+L) which can be in completed simultaneously.
Also, your tip "I frequently need to create pivot tables in my documents too, and so Alt, N, S, Z, Enter is another favourite." could be shortened to (Alt + D, P). But it's always good to share tip and one of my favourites is selecting a date in a cell, moving the mouse pointer over the Fill Handle (the black square in the bottom right hand corner of that cell) and using the Right Hand mouse button to drag down. A menu box pops up showing a lot more options like, fill without weekends etc.
I've always told my students to try doing what they already know like, moving the tab but try holding the Alt, Ctrl, Shift + Alt, Shift + Ctrl, or Shift + Ctrl + Alt. It's amazing the things that are buried deep in Excel. ;-)
Using Excel, the thing you want to do may be done in several different ways. I've found that those things which might feel like a shortcut to one person may not be to another. For example, your tip
"or the Alt-key sequences (like Alt, A, T to enable the quick filter)"
Which involves pressing the keys separately, might be replaced with (Shift+Ctrl+L) which can be in completed simultaneously.
Also, your tip "I frequently need to create pivot tables in my documents too, and so Alt, N, S, Z, Enter is another favourite." could be shortened to (Alt + D, P). But it's always good to share tip and one of my favourites is selecting a date in a cell, moving the mouse pointer over the Fill Handle (the black square in the bottom right hand corner of that cell) and using the Right Hand mouse button to drag down. A menu box pops up showing a lot more options like, fill without weekends etc.
I've always told my students to try doing what they already know like, moving the tab but try holding the Alt, Ctrl, Shift + Alt, Shift + Ctrl, or Shift + Ctrl + Alt. It's amazing the things that are buried deep in Excel. ;-)