Learned several new things here! Brilliant! The last one I use in Word (and PowerPoint and Excel and Project and Outlook e-mail editor, others?) all the time, but always within bulleted lists (or numbered): you can change the order (as you’ve shown) or in/decrease the indent (which will group rows/columns in Excel) if you use the left/right keys. ALT+SHIFT+arrow is the most universal shortcut in Office, IMO. And today I learned that it is not restricted to just bulleted lists (etc.) but it actually works in conjunction with the paragraph mark and thus throughout the entire document. Somehow I feel I should have known that because like everyone else I too have indented a normal paragraph by accident in the past. :-)
Hi Gasper. Nice tips! #2 and #3 were new for me. Always wondered how to drag and drop into a different worksheet or insert a range into an existing range. Thanks for the lesson. I've subscribed.. looking forward to the next one :)) Thumbs up!!
Regarding tips #5, mouseless navigation shortcut, I found some useful shortcut on internet but it did not have the the letter on the ribbon like the unfreeze pane. For example: Alt E+I+U - copy upward Alt E+I+L - copy left Do you know where can I learn this kind of shortcut?
Hi El. Basically, you learn these from necessity. When you use a command, and you want to know the mouseless shortcut, you press Alt and navigate all the way to the desired command, and now you know the shortcut.
thank u Gasper, have a nice weekend.
Amazing!
Glad to hear you liked it Alexx.
Learned several new things here! Brilliant!
The last one I use in Word (and PowerPoint and Excel and Project and Outlook e-mail editor, others?) all the time, but always within bulleted lists (or numbered): you can change the order (as you’ve shown) or in/decrease the indent (which will group rows/columns in Excel) if you use the left/right keys. ALT+SHIFT+arrow is the most universal shortcut in Office, IMO.
And today I learned that it is not restricted to just bulleted lists (etc.) but it actually works in conjunction with the paragraph mark and thus throughout the entire document. Somehow I feel I should have known that because like everyone else I too have indented a normal paragraph by accident in the past. :-)
We live and we learn And it's thinking of different uses of things we already know in Excel that leads to biggest breakthroughs.
Awesome! Very useful/helpful.
Thanks John. Glad to hear it.
Hi Gasper. Nice tips! #2 and #3 were new for me. Always wondered how to drag and drop into a different worksheet or insert a range into an existing range. Thanks for the lesson. I've subscribed.. looking forward to the next one :)) Thumbs up!!
Thanks for the kind words Wayne and glad to hear you learned something new.
Regarding tips #5, mouseless navigation shortcut, I found some useful shortcut on internet but it did not have the the letter on the ribbon like the unfreeze pane.
For example:
Alt E+I+U - copy upward
Alt E+I+L - copy left
Do you know where can I learn this kind of shortcut?
Hi El. Basically, you learn these from necessity. When you use a command, and you want to know the mouseless shortcut, you press Alt and navigate all the way to the desired command, and now you know the shortcut.
Alt-Shift-Arrow is exactly the same as in e.g. Notepad++. Don’t know which came first though.
You just tought me something Wim, I did not know that. Great to know. Thanks. And if I had to guess I would bet Word came first 😀
@@ExcelOlympics well to be complete, the shortcut is different. Word had Alt Shift Arrow whereas Notepad++ had Ctrl Shift Arrow.
Good to know. Thanks again Wim.