Most used excel shortcuts?
Incoming SA. Just bought a Logitech G815 and plan on using the dedicated macro keys for saving excel keyboard shortcuts. Was wondering what you find you use the most. First add was special paste. Thanks!
stackoverflow and put that G815 to good use.
Look up shortcuts on stack overflow? or wdym
Any suggestions aside from assigning commands to the macro keys?
CTRL + ALT + Left Arrow (--)
alt, e, s - paste special menu crtl + [ or ] - trace precedents and dependents
I use alt shortcuts for almost everything....
If there is one thing you could add it would be to write a macro for “Center Across Selection” ... do this instead of merge and center. I have a shortcut set up for it but you could add it to your keyboard macro list.
Any tips on how to do the center across selection shortcut?
If you have the developer ribbon click into and select “record macro” ... save it in your Personal Workbook, should have this option from the drop down.
Make sure you only have one cell selected prior to clicking record... once you click record, navigate to the home ribbon and click into the alignment options, choose “center across selection” and then click ok. Stop recording the macro.
it should be saved as whatever shortcut you selected prior to recording. I used crtl + m for mine, but you could really use anything that isn’t being used.
Agree with ALT + E + S for paste special. Using that, ALT + E + S + L is amazing for linking large groups of cells.
Presuming you work on a monitor and not a miniature laptop screen, it helps to split screen using ALT + W + S once your model gets tall. Can use F6 or Shift + F6 to toggle between the panes.
As a general windows shortcut, I also use windows key + arrow keys if I want to move windows around and have them snap to different screens or sides.
ctlr + space to highlight the column. then alt + A + E + Enter (3 times) ... this gets rid of all green triangles.
Alt + A + S + S
Its easy to remember and quite helpful ;)
Alt D S to save a keystroke ;)
Ctrl + S. save once every 10 minutes
I was considering getting the G815!
Which type of switches did you get and what do you think of the build quality?
I saw some reviews online saying the keys are a bit wobbly, do you find that to be the case with yours?
The keys aren't quite as sturdy as my x1 keys but it isn't an issue for me. It isn't significant to rule out the rest of the great features available. Having 15 total dedicated keys to save commands is a time and lifesaver. It's expensive but build quality is second to none, and given most laptop keyboards are ten keyless having the numpad is great. I got the tactile switches so it is bearable with other people as well. Wouldn't get clicky if you want it in a public setting and having the feedback with tactile switches is a perfect middle ground.
ALT + W + V + G (if you hate excel lines, like me)
Crtl+z
TTS macro shortcuts for me - colors, shading, number formats, alignment, trace formulas, etc.
Totam nesciunt nesciunt expedita maiores recusandae cum ut. Hic magni dolorem molestias. Assumenda natus nulla rerum nesciunt. Sed hic eveniet architecto eius.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...