5th Best Computer Tricks_What you need to Know.

1st:- Get back that tab you accidentally closed.

If you want to get back a tab you closed, just press "Control" (or "Command" on Mac), plus "Shift," plus "T," and it will magically reappear.

2nd:-Only screenshot the part of the screen you want.

If you only need to screenshot part of the screen, there's a simple way to do it for both Windows and Macs.

For Mac: "Command," plus "Shift," plus "4" brings up the tool. Then you just drag the area you want.

For Windows: Just go to "Start" and then "Snipping Tool."

3rd:-Easily repeat your last command in Excel.

If you press the F4 button in Excel, it repeats the last command.

Understand from Below given Example-

you select a cell and highlight it yellow, you can then highlight any other selected cell(s) yellow by pressing F4."

4th:-Make a copy of a file by just dragging it.

All you have to do to make a copy of a file on a Mac is hold the "Alt" key ("Control" if you are using a PC) and then click and drag the file. This will make a copy that you can drop anywhere you want by un-clicking.

5th:-Lock your computer in seconds.

On a Windows machine, hit "Windows," plus "L" to lock your computer. This can be fun for pranks.

On a Mac click "Command," plus "Option," plus "Eject." (Or "Power" if your computer doesn't have an optical drive.)

If you learned anything from it, then share it.

Cheers_ Yogendra Pratap Mishra

Comments

Interactive Blogposts

नेल्सन मंडेला

मई 2008 में मंडेला दक्षिण अफ्रीका के राष्ट्रपति पद बहाल 10 मई 1994 – 14 जून 1999 सहायक थाबो म्वूयेलवा म्बेकी एफ डब्ल्यू डी क्लेर्क पूर्वा धिकारी एफ डब्ल्यू डी क्लेर्क उत्तरा धिकारी थाबो म्वूयेलवा म्बेकी जन्म 18 जुलाई 1918 म्वेज़ो , केप प्रांत, दक्षिण अफ़्रीका मृत्यु 5 दिसम्बर 2013 (उम्र 95) ह्यूटन, जोहान्सबर्ग , दक्षिण अफ़्रीका जन्म का नाम रोलीह्लला मंडेला राष्ट्रीयता दक्षिण अफ़्रीकी राजनीतिक दल अफ्रीकन नेशनल कांग्रेस जीवन संगी एवलिन नटोको मेस (वि 1944–1957; तलाक) विनी मदिकिज़ेला (वि 1958–1996; तलाक़) ग्राशा मैचल (वि 1998–2013; मृत्युपर्यंत) बच्चे मेडिका थेमबेकल मंडेला मैकज़िव मंडेला मैकगाथो लेवानिका मंडेला मैकज़िव मंडेला ज़ेनानी मंडेला ज़िनज़िस्वा मंडेला निवास ह्यूटन एस्टेट, जोहानसबर्ग, गौटेंग, दक्षिण अफ़्रीका शैक्षिक सम्बद्धता यूनिवर्सिटी ऑफ़ फोर्ट हेर यूनिवर्सिटी ऑफ़ लंदन एक्सटर्नल सिस्टम यूनिवर्सिटी ऑफ़ साउथ अफ्रीका यूनिवर्सिटी ऑफ़ द विटवाटरस्रांड धर्म ईसाई ( मेथोडिज़्म ) हस्ताक्षर जालस्थल www .nelsonmandela .org नेल्सन रोलीह्लला मंडेला ( ख़ोसा : N

Unsend Sent Messages

Unsend Sent Messages_ This is one of the most useful Gmail tricks. Go to Settings > General tab and check off “ Enable Undo Send .” You can also set the cancellation period as 5, 10, 20 or 30 seconds. Click on Save Changes at the bottom of the page. Next time when you send a message, you will see an Undo option in yellow below the search bar. You can click on it to unsend the message, and then you can edit it or discard it.

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 in cell B4, but it ends with a variable, which is the OFFSET f