Quick list in place

Many a times you have a situation where in you have to type in again the same thing you have typed some time before. What you do? go select that cell again and copy paste….

Here is a way out to quick select list, just use (Alt + down arrow) and the entire list will appear just like auto filter in place. Then you can select whatever option you want.

More short cuts

Quick sheet add (Shift + F11)
Quick chart add (Select source data and press F11)
Quick copy and edit value of the cell in cell below (Ctrl + Shift + ‘)
Quick copy and edit formula of the cell in cell below (Ctrl + ‘)
Edit or create a comment in the current cell (Shift + F2)