If you find yourself typing the same information a number of times in the same column, Excel has a really useful īpick from listī feature which can save you loads of time.
If you right click the cell where you want to enter data, there is an option called Pick From List. This will bring up a list of all entries above the cell (in the same column) and you can select the relevant one.
The same thing can be achieved by holding down the Alt key and pressing the down arrow. Please note - neither of the above will function correctly if there are blank rows in your data.
Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.