Skip to main content

40 Incredibly Useful Computer Tips & Keyboard Shortcuts #Yogendra5575

Google Chrome

1. To open ChromeтАЩs built-in task manager: Press Shift + Esc. Extremely useful when Chrome freezes.
Chrome Task Manager
2. To remove specific suggestion: Select the suggestion, then press Shift + Delete. Go and delete your how to shave my embarrassing searches now.
3. To drag multiple tabs to a new window: Press Ctrl + Click on tabs you want to move. Do the same to move multiple tabs to an existing window.
Ctrl and Click to select tabs to open in new window
4. To scroll horizontally: Press Shift + Scroll.

Any Browsers

5. To access your address bar directly: Press F6 or Ctrl + L.
6. To access blocked web page: Go to Google Translate, paste the URL, select source language as other language, select destination language as the web pageтАЩs language, click Translate. Free web proxy.
Google Translate as Proxy
7. To close a tab: Middle click on it.
8. To view articles with slideshows or multiple pages: Press Print or Ctrl + P.
9. To open all web pages of a bookmark folder: Middle click on the folder.
10. To reset to the default Window size of your web page after zooming: Press Ctrl + 0.
11. To highlight text in a web page:  Click on the starting point, then press Shift + Click on the ending point. No more mouse dragging especially long text highlights.
12. To fit more bookmarks: Remove all text. Only the favicon is visible now.
Remove bookmark text to save space
13. You can undo send your mail in Gmail. Turn it on now just in case!
Undo send mail
14. When researching products, type [product name] vs to compare with their rival products.

Windows

15. To open Task Manager directly with one hand: Press Ctrl + Shift + Esc. YouтАЩre welcome.
16. To minimize every open windows except yours: Shake your active window. Do the same to maximize all windows. You sneaky Microsoft.
Shake Windows To Close Others
17. To freeze Task Manager: Hold Ctrl key. Useful for inspecting specific processes.
18. To capture the exact steps you take and document it nicely: Search psr to open Problem Steps Recorder. Try it now and youтАЩll be amazed.
Steps Recorder
19. To take a screenshot of the active window only: Press Alt + Print Screen. Bye Snipping Tool.
20. To delete one word at a time: Press Ctrl + Backspace.
 Delete An Entire Word With Ctrl and Backspace
21. To open applications on the taskbar: Press Windows key + Sequence number of the application. Do the same to minimize/maximize it.
22. To paste text without formatting: Press Ctrl + Shift + V.
23. To rename a file: Press F2. Works for multiple file too, which will append тАЬ(1), (2), etc.тАЭ at the end.
24. Open your Calculator and select View. Calculate your mortgage payment, fuel economy, vehicle lease payment, and more.
Calculator mortgage payment

Wi-Fi

25. To boost your Wi-Fi signal: Download Virtual Router to turn your computer(s) into a Wi-Fi hotspot. It will extend the reach of your network.
Virtual Router
26. To share your Wi-Fi access: Generate a QR code with the access details. Print the QR code and stick it on the wall.
WiFi QR Code Generator

Wikipedia

27. Wikipedia Nearby: Pulls up articles based on your location. Extremely handy when travelling.
Wikipedia Nearby
28. Wikipedia Random: Read random articles. Now, change your start-up page from Facebook to this.

YouTube

29. To pause a video: Press K.
30. To skip 10 seconds back and forward: Press J and L respectively.
31. To search videos from a specific user only: Type @ before you search.
32. To save your time watching videos: Press > and < to speed up and slow down the video respectively.
33. To view all keyboard shortcuts: Press ?.
YouTube Keyboard Shortcuts

Microsoft Office

34. To use mouse as laser pointer in PowerPoint: hold Ctrl + Left click. Mouse cursors are too mainstream. Stay cool with laser.
35. To open your PowerPoint file in presentation mode directly: Right click on the file, then select Show.
PowerPoint Right Click Show

Comments

Interactive Blogposts

OFFSET combined with SUM or AVERAGE_#Yogendra

           OFFSET combined with SUM or AVERAGE Formula: =SUM(B4:OFFSET(B4,0,E2-1)) The OFFSET function on its own is not particularly advanced, but when we combine it with other functions like SUM or AVERAGE we can create a pretty sophisticated formula.  Suppose you want to create a dynamic function that can sum a variable number of cells.  With the regular SUM formula, you are limited to a static calculation, but by adding OFFSET you can have the cell reference move around. How it works:  To make this formula work, we substitute ending reference cell of the SUM function with the OFFSET function.  This makes the formula dynamic and the cell referenced as E2 is where you can tell Excel how many consecutive cells you want to add up. Now weтАЩve got some advanced Excel formulas! Below is a screenshot of this slightly more sophisticated formula in action. Add caption As you see, the SUM formula starts...

рдиреЗрд▓реНрд╕рди рдордВрдбреЗрд▓рд╛

рдордИ 2008 рдореЗрдВ рдордВрдбреЗрд▓рд╛ рджрдХреНрд╖рд┐рдг рдЕрдлреНрд░реАрдХрд╛ рдХреЗ рд░рд╛рд╖реНрдЯреНрд░рдкрддрд┐ рдкрдж рдмрд╣рд╛рд▓ 10 рдордИ 1994 тАУ 14 рдЬреВрди 1999 рд╕рд╣рд╛рдпрдХ рдерд╛рдмреЛ рдореНрд╡реВрдпреЗрд▓рд╡рд╛ рдореНрдмреЗрдХреА рдПрдл рдбрдмреНрд▓реНрдпреВ рдбреА рдХреНрд▓реЗрд░реНрдХ рдкреВрд░реНрд╡рд╛ рдзрд┐рдХрд╛рд░реА рдПрдл рдбрдмреНрд▓реНрдпреВ рдбреА рдХреНрд▓реЗрд░реНрдХ рдЙрддреНрддрд░рд╛ рдзрд┐рдХрд╛рд░реА рдерд╛рдмреЛ рдореНрд╡реВрдпреЗрд▓рд╡рд╛ рдореНрдмреЗрдХреА рдЬрдиреНрдо 18 рдЬреБрд▓рд╛рдИ 1918   рдореНрд╡реЗрдЬрд╝реЛ , рдХреЗрдк рдкреНрд░рд╛рдВрдд,  рджрдХреНрд╖рд┐рдг рдЕрдлрд╝реНрд░реАрдХрд╛ рдореГрддреНрдпреБ 5 рджрд┐рд╕рдореНрдмрд░ 2013 (рдЙрдореНрд░ 95) рд╣реНрдпреВрдЯрди,  рдЬреЛрд╣рд╛рдиреНрд╕рдмрд░реНрдЧ , рджрдХреНрд╖рд┐рдг рдЕрдлрд╝реНрд░реАрдХрд╛ рдЬрдиреНрдо рдХрд╛ рдирд╛рдо рд░реЛрд▓реАрд╣реНрд▓рд▓рд╛ рдордВрдбреЗрд▓рд╛ рд░рд╛рд╖реНрдЯреНрд░реАрдпрддрд╛ рджрдХреНрд╖рд┐рдг рдЕрдлрд╝реНрд░реАрдХреА рд░рд╛рдЬрдиреАрддрд┐рдХ рджрд▓ рдЕрдлреНрд░реАрдХрди рдиреЗрд╢рдирд▓ рдХрд╛рдВрдЧреНрд░реЗрд╕ рдЬреАрд╡рди рд╕рдВрдЧреА рдПрд╡рд▓рд┐рди рдирдЯреЛрдХреЛ рдореЗрд╕ (рд╡рд┐ 1944тАУ1957; рддрд▓рд╛рдХ) рд╡рд┐рдиреА рдорджрд┐рдХрд┐рдЬрд╝реЗрд▓рд╛ (рд╡рд┐ 1958тАУ1996; рддрд▓рд╛рдХрд╝) рдЧреНрд░рд╛рд╢рд╛ рдореИрдЪрд▓ (рд╡рд┐ 1998тАУ2013; рдореГрддреНрдпреБрдкрд░реНрдпрдВрдд) рдмрдЪреНрдЪреЗ рдореЗрдбрд┐рдХрд╛ рдереЗрдордмреЗрдХрд▓ рдордВрдбреЗрд▓рд╛ рдореИрдХрдЬрд╝рд┐рд╡ рдордВрдбреЗрд▓рд╛ рдореИрдХрдЧрд╛рдереЛ рд▓реЗрд╡рд╛рдирд┐рдХрд╛ рдордВрдбреЗрд▓рд╛ рдореИрдХрдЬрд╝рд┐рд╡ рдордВрдбреЗрд▓рд╛ рдЬрд╝реЗрдирд╛рдиреА рдордВрдбреЗрд▓рд╛ рдЬрд╝рд┐рдирдЬрд╝рд┐рд╕реНрд╡рд╛ рдордВрдбреЗрд▓рд╛ рдирд┐рд╡рд╛рд╕ рд╣реНрдпреВрдЯрди рдПрд╕реНрдЯреЗрдЯ, рдЬреЛрд╣рд╛рдирд╕рдмрд░реНрдЧ, рдЧреМрдЯреЗрдВрдЧ, рджрдХреНрд╖рд┐рдг рдЕрдлрд╝реНрд░реАрдХрд╛ рд╢реИрдХреНрд╖рд┐рдХ рд╕рдореНрдмрджреНрдзрддрд╛ рдпреВрдирд┐рд╡рд░реНрд╕рд┐рдЯреА рдСрдлрд╝ рдлреЛрд░реНрдЯ рд╣реЗрд░ рдпреВрдирд┐рд╡рд░реНрд╕рд┐рдЯреА рдСрдлрд╝ рд▓рдВрджрди рдПрдХреНрд╕рдЯрд░реНрдирд▓ рд╕рд┐рд╕реНрдЯрдо рдпреВрдирд┐рд╡рд░реНрд╕рд┐рдЯреА рдСрдлрд╝ рд╕рд╛рдЙрде рдЕрдлреНрд░реАрдХрд╛ рдпреВрдирд┐рд╡рд░реНрд╕рд┐рдЯреА рдСрдлрд╝ рдж рд╡рд┐рдЯрд╡рд╛рдЯрд░рд╕реНрд░рд╛рдВрдб рдзрд░реНрдо рдИрд╕рд╛рдИ ( рдореЗрдереЛрдбрд┐рдЬрд╝реНрдо ) рд╣рд╕реНрддрд╛рдХреНрд╖рд░ рдЬрд╛рд▓рд╕реНрдерд▓ www...

Top 100 Useful Excel Macro [VBA] Codes Examples

Yogendra98.blogpost.com You can automate small as well as heavy tasks with VBA codes. And do you know with the help of macros, you can break all the limitations of Excel which you think Excel has? So today, I have listed some of the useful codes e xamples to help you become more productive in your day to day work. You can use these codes even if you haven't used VBA before that. All you have to do just paste these codes in your VBA editor. These codes will exactly do the same thing which headings are telling you. For your convenience, please follow these steps to add these codes to your workbook. Before you use these codes, make sure you have your developer tab on your Excel ribbon to access VB editor. If you don't have please use these simple steps to  activate developer tab . Once you activate developer tab, you can use below steps to paste a VBA code into VB editor. Don't Forget:   Make sure to  download thi...