Useful Tips For Excel Keyboard Shortcuts

Useful Tips For Excel Keyboard Shortcuts

1. To format any selected object, press ctrl+1
2. To insert current date, press ctrl+;
3. To insert current time, press ctrl+shift+;
4. To repeat last action, press F4
5. To edit a cell comment, press shift + F2
6. To autosum selected cells, press alt + =
7. To see the suggest drop-down in a cell, press alt + down arrow
8. To enter multiple lines in a cell, press alt+enter
9. To insert a new sheet, press shift + F11
10. To edit active cell, press F2 (places cursor in the end)
11. To hide current row, press ctrl+9
12. To hide current column, press ctrl+0
13. To unhide rows in selected range, press ctrl+shift+9
14. To unhide columns in selected range, press ctrl+shift+0
15. To recalculate formulas, press F9
16. To select data in current region, press ctrl+shift+8
17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)
18. While editing formulas to change the reference type from absolute to relative vice versa, press F4
19. To format a number as currency, press ctrl+shift+4 (ctrl+$)
20. To apply outline border around selected cells, press ctrl+shift+7
21. To open the macros dialog box, press alt+F8
22. To copy value from above cell, press ctrl+’
23. To format current cell with comma formats, press ctrl+shift+1
24. To go to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press ctrl+shift+pg up


The Best Google Tips

Google is the best search engine available on the Internet. Period. That’s why it is important to know how to master it with this Google tricks section! When Internet started becoming famous the only search engine available was Yahoo! Since then many things have changed, and competition has got tougher and tougher. Nowadays Google is in a prominent position and everybody uses it to search whatever available on the web. Millions of people use its powerful engine everyday, and millions of keywords are used to search. From web pages to blogs, from people sensitive information to website backdoors that only too often are used to hack, steal and damage companies, people and websites. These are just a few examples of the power Google owns and the way it can be used. But if you think to know everything about it well, think twice. As a matter of fact, Google is not just useful to make searches. In fact it can be used and “manipulated” with cool tips in ways that you can not even image, and that could solve many of your everyday problems. This is the goal of this guide: let you look at Google with different eyes and use its power in new ways. I bet that when you will have finished reading, you will consider Google as your best Internet friend, able to help you more than you would have thought.

Did you know that you can use Google for…
Continue reading…