We are almost at the end of 2013. Time to review how much more awesome we became this year. Today let me ask you a very simple question.
What is the coolest Excel trick you have learned this year?
Go ahead and post your answers using comments.
I will go first:
As my life revolves around Excel, not a week goes by when I don’t learn something new. That said, 3 of the most impressive tricks I have learned this year are,
- Calculating sum of top 3 values in a filtered list.
- Transposing a table of formulas quickly using copy-paste.
- Shading above or below lines in Excel charts
For me the coolest trick has to be the transposing one. This, shared by Joey (a commenter on Chandoo.org) shows how to solve a tricky problem with smart thinking.
What about you?
Go ahead and tell me what is the coolest Excel trick you have learned all this year.
We have 18 more days in this year and I am really hoping to learn few more awesome tricks. I am all ears to hear what you have to say.
Go!
5 Responses to “Show more of your workbook on screens [quick tip]”
In 2013 you can also add to the QAT the hidden command "Toggle Full Screen View".
Instead of using the shortcut CTRL+F1, I prefer just to double-click one of the tab names (ie double-click the "Home" text on the Home tab) to enable the Ribbon Outline view. To return to the normal Ribbon state, just double-click your mouse again!
press Ctrl+Shift+F1, you will get a full screen
Instead of Ctrl + F1, I use Ctrl + Shift + F1 (Excel 2016)
Alt W E sequence for full screen
ESC to get back