Gmail

Take a moment to remember that Gmail is a Google product—and Google is the master of search. If you haven’t relied on Gmail search in the past, you owe it to yourself to give it a try. Try using the following search operators:


 1. By keywords. If you’re looking for the most basic type of search, you don’t have to include any operators. For example, if you know there’s an email with a specific word or phrase somewhere in it, or if there’s a topic you’re interested in searching, simply type that phrase into the search bar and go. For example, you might search for “lunch” or “TPS report.”
 
gsearch1

2. Exact words and phrases. Those of you familiar with basic search operators for Google search will be pleased to know that you can search for specific phrases the same way in Gmail. All you have to do is include quotation marks (“”) around the intended phrase. For example, searching for “lunch at Marco’s” will show you any emails with that phrase, but no emails that contain just the word “lunch” or just the word “Marco’s.” Be aware that you can use these quotation marks in combination with any other search operator, in case you need to search for something specific within another set of parameters.
 
gsearch2

3. By sender. If you want to look for emails that were sent by a specific person, just use “from:”, followed by the person’s email address.
 
gsearch3

4. By recipient. You can use the same formula when you’re looking for a specific recipient, by including “to:”, followed by your contact of choice.
 
gsearch4

5. By subject line. With this Gmail search command, you can search for emails by the contents of their subject lines. Use “subject:” followed by a word or phrase you’d like to find. All emails that contain all or part of your search in the subject line will be presented to you.
 
gsearch5

6. By multiple senders/recipients. If you want to pull a list of emails from multiple different potential senders, the easiest way to do it is using Gmail filter syntax: the “OR” operator or { } brackets. For example, if you wanted to view both emails from sender1@gmail.com and sender2@gmail.com, you could use “{from: sender1 from: sender2}” or “from: sender1 OR from: sender2”.
 
gsearch6

7. Excluding content. If you want to find content that specifically doesn’t have a particular word or phrase, you can use another useful Gmail search syntax; a “-“ symbol. This is useful if you want to filter out common results. For example, if you could search for something like “project X -status” to filter out any emails that are merely status updates about the project.
 
gsearch7

8. Contextual content. You can also use search operators to search for content based on its context and positioning in the message. With the operator “AROUND”, you can search for terms that occur around other terms. For example, you could search for “coffee AROUND today” to search for coffee invitations you sent out with the hopes of a same-day meeting.
 
gsearch8

9. Labeled or unlabeled. With the “has:” search operator, you can filter your search results based on whether or not the messages have labels. “has: userlabels” will show you all emails that have at least one assigned label, while “has: nouserlabels” will show you the unlabeled ones. This is most useful when used in combination with other operators. Do be warned, however, that only individual messages are labeled—not the entire conversation.
 
gseatch9

10. By specific label. If you’re looking for messages that fall specifically under one label, use “label:” followed by the label you’re searching (such as “label: Urgent”).
 
gsearch10

11. By attachment. You can search only for messages that have an attachment with the “has: attachment” search operator. No messages with attachments will be displayed.
 
gsearch11

12. By file name. The “filename:” search operator can be used to search for emails that have an attachment with a certain title, or a certain type of attachment. For example, if you remember an attachment has the word “money” in it, you could search “filename: money”, or if you remember it’s a PDF, you could search for “filename: pdf”.
 
gsearch12

13. By drive attachment. If your business uses G Suite and frequently sends files from Google Drive, you should know there are several search operators for specific Drive attachments. “has: drive” will show you any emails with any Drive-related attachment, while “has: document” is specific to documents, “has: spreadsheet” is for spreadsheets, and “has: presentation” is for slideshow presentations.
 
gsearch13

14. By YouTube inclusion. When you’re trying to track down that hilarious video your coworker sent you, you can use “has: youtube” to show only emails featuring an embedded YouTube link.
 
gsearch14

15. By mailing list. If you remember that the email came from a specific list, you can use the “list:” operator. For example, if you’re getting notifications from info@company.com, you can use “list: info@company.com” to find them.
 
gsearch15

16. By multiple keywords. If you want to group multiple independent keywords together in a single search, the best way to do it is with ( ). For example, if you’re looking for any emails that contain references to either Godzilla or Mothra, you could include (Godzilla Mothra) as part of your search.
 
gsearch16

17. By folder (or anywhere). The “in:” operator is designed to help you find emails in a specific folder, though you can also use the “anywhere” modifier to search throughout your entire Gmail account. For example, you might add “in: Spam” or “in: Trash”, or when you get desperate, “in: anywhere”.
 
gsearch17

18. By importance, star, snoozed, read, or unread. Though technically these all count as separate search operators, they all serve a similar function: helping you find emails in specific sections of your Gmail account. Use the “is:” general function in combination with these conditions to track down emails in specific areas. For example, “is: starred”, “is: unstarred”, “is: snoozed”, “is: read”, and “is: unread” are all valuable to these ends.
 
gsearch18

19. By CC or BCC addresses. Sender and recipient searches won’t apply to the CC or BCC field. To search these areas, you’ll need a separate search operator. There’s one for each: “cc:” and “bcc:”. The only exception here is that your “bcc:” search won’t allow you to find messages that you’ve received when you were the one BCC’d.
 
gsearch19

20. By a specific time period. There’s a set of four Gmail search parameters that all help you find messages that were sent or received during a specific time period. They are: “after:”, “before:”, “older:”, and “newer:”. “Older” and “before” are practically the same, as are “newer” and “after.” Use whichever set you can remember. The date format does matter; follow the YYYY/MM/DD format to ensure you get the best results.
 
gsearch20

21. By a relative time period. You can also run a more casual search with the operators “older_than:” and “newer_than:” to find an email that was sent before or after a given time. Use these in combination with numbers and letters to inform it how old the baseline message should be; use “d” for day, “m” for month, and “y” for year. For example, “newer_than: 2m” would call up messages that have come in during the past two months, and “older_than: 1y” would show messages more than a year old.
 
gsearch21

22. By address of delivery. Though it may seem functionally identical to a recipient search, you may find a need to search for a delivery address, rather than an intended address. If you do, use “deliveredto:” followed by a contact to find emails formally delivered to that specific address.
 
gsearch22

21. By a relative time period. You can also run a more casual search with the operators “older_than:” and “newer_than:” to find an email that was sent before or after a given time. Use these in combination with numbers and letters to inform it how old the baseline message should be; use “d” for day, “m” for month, and “y” for year. For example, “newer_than: 2m” would call up messages that have come in during the past two months, and “older_than: 1y” would show messages more than a year old.
 
gsearch21

22. By address of delivery. Though it may seem functionally identical to a recipient search, you may find a need to search for a delivery address, rather than an intended address. If you do, use “deliveredto:” followed by a contact to find emails formally delivered to that specific address.
 
gsearch22

23. By category. The “category:” search operator will help you find emails belonging to different categories, like Social and Updates. If you’re using this search operator by itself, I recommend you adjust your Gmail settings to arrange these categories in tabs at the top of your inbox, so you can access them with a click. Otherwise, use it in combination with other operators.
 
gsearch23

24. By message size. There are a few different ways to search for a message by file size. If you use “size:”, you’ll pull all messages with attachments or content that make them larger than the size you type in bytes. If you use “larger:” or “smaller:”, you’ll be able to search for larger or smaller file sizes than the size you type in bytes. You can also use abbreviations to search for different values; for example, “larger: 15M” would display any messages with file size greater than 15 MB.
 
gsearch24
msexcel

Method 1

Step 1: Right click on the “Sheet tab”, which appears at the bottom right corner of the excel workbook as given in the picture below.

Step 2: Then move your cursor on the “Tab color”, and then immediately a Color dialogue box appears.

Step 3: Now you can select one of the Theme Colors or Standard Colors you want.

If you want to remove the Color of a Sheet tab, Select “No Color”

tabcolor1

Method 2 
 
Step 1: Go to the Home tab.

Step 2: Then click on the drop-down arrow of the Format in the Cells group.

Step 3: Afterwards, move your cursor on the “Tab color”, and then immediately a Color dialogue box appears.

Step 4: Now you can select one of the Theme Colors or Standard Colors you want.

If you want remove the Color of a Sheet tab, Select “No Color”.
 
tabcolor2

Method 3

Change All Sheet Tab Color at a Time:​

Step 1: To change all the Sheet tab color at a time, Right click on the “Sheet tab”, which appears at the bottom right corner of the excel workbook as given in the picture below.

Step 2: Then click “Select All Sheets”

 
tabcolor3-2

Step 3: Again, right click on the “Sheet tab” 

Step 4: Then move your cursor on the “Tab color”, and then immediately a Color dialogue box appears.

Step 5: Now you can select one of the Theme Colors or Standard Colors you want.
 
tabcolor3-5

Remove All Sheet Tab Color at a Time

If you want remove the color of all the sheet tabs at a time, do the following:

Step 1: Right click on the “Sheet tab”.

 Step 2: After that, click the “Select All Sheets”.
tabcolor3-3-2

Step 3: Again, right click on the “Sheet tab” 

Step 4: Now if you move the cursor on the “Tab color”, immediately a Color dialogue box appears.

Step 5: Finally, Select “No Color”.
 
tabcolor3-5-5

Method 4

Step 1: Press Alt + H → O → T, and Select one of the Theme Colors or Standard Colors you want.
 
tabcolor4
msword

If you're writing a paper involving equations or scientific formulas, chances are you're going to need superscripts and subscripts.

Once you know how to add a superscript and subscript in Microsoft Word, it will make your work flow so much faster. Plus, it looks much more professional than the work-around options (for example, X^2).

Superscript in Word

A superscript is a character, symbol or number set slightly above the normal line of text. It is always smaller than the usual font and is typically found in mathematical or scientific formulas.

If you need a superscript in your Word document, here's how to go about it.

Step 1: Place cursor where you want the superscript to go.

Click where you'd like the superscript to appear. If you already typed what you want in the superscript, highlight that number, character or symbol. 

Step 2: Click the X2 button
You can find the superscript button on the 'Home' tab. It's located near all the font options.


Step 3: Type your superscript
Type whatever you want to be included in your superscript. It should immediately be set above the normal text line and be smaller.

Step 4: Exit out of superscript
If you keep typing, everything will remain in the superscript. To get out of that mode, click on the superscript button again.

Subscript in Word

A subscript is a character, symbol or number set slightly below the normal line of text. It is always smaller than the usual font and is typically found in mathematical or scientific formulas.

If you need a subscript in you Word document, here's how to do it. 

Step 1: Place cursor where you want the subscript to go.

Click where you'd like the subscript to appear. If you already typed what you want in the superscript, highlight that number, character or symbol. 

Step 2: Click the Xbutton
You can find the subscript button on the 'Home' tab. It's located near all the font option.


Step 3: Type your subscript
Type whatever you want to be included in your subscript. It should immediately be set above the normal text line and be smaller.

Step 4: Exit out of subscript
If you keep typing, everything will remain in the subscript. To get out of that mode, click on the subscript button again
Gmail

While it might not be necessary for personal emails or when you’re sharing funny cat videos with family members, a lot of Gmail users like to have an email signature for business reasons. Rather than typing out your phone number or contact information every time, Gmail will do all the legwork for you.

Since this isn’t a default option, you’ll need to head into your Gmail settings to add or change an existing Gmail signature.

Step 1: Launch your favorite browser and log into your Gmail account as you normally would.

Step 2: Next, click the cog icon in the upper-right corner of the screen and click See all settings from the drop-down menu.
 
vacares1

Step 3: Under the General tab, scroll down until you see Signature. Click on the Create new button.
 
gmailsig0

Step 4: In the dialogue box that pops up, enter a name for your new signature. Then you’ll be taken back to the Settings screen and a new text box will appear next to your signature’s name. Type your desired email signature into this text box.
 
gmailsig1
Optional: Below the signature field, you’ll see a checkbox that allows you to add your signature before quoted text in email replies. This will make your signature more visible in email threads. It’s worth toggling on if you’re using your email for professional correspondences, or if you want your signature to remain visible in follow-up messages. This section below the signature field also contains two other drop down-menu options that allow you to choose if your signature shows up in new emails or in replies and forwarded emails. 

Step 5: After you’re satisfied with your signature, scroll to the bottom of the page and click the Save Changes button. That’s it! Your signature will now appear on all new messages and outgoing mail.
Gmail

Setting an automatic “out of office” reply for your emails is very helpful when you’re going away on vacation. This vacation responder lets people who email you know that you won’t be able to reply to them immediately.

Here’s how to set an out of office reply in Gmail on your computer. 

Step 1: Open your Gmail inbox.

Step 2: Then click the cog icon in the top-right corner of the page.

Step 3: Next, select See all settings.
 
vacares1

Step 4: Then scroll down and check the box next to Vacation responder on.

Step 5: Next, set your automatic reply dates. Check the Last day box and input the last day you want to send automatic replies. You can skip this step if you’re going to manually turn off automatic replies when you get back to the office. This might be more convenient if you’re not sure when you’ll be back.

Step 6: Then type your out of office message. This will be the automatic response sent to people from your company who email you while you’re away.

Step 7: Finally, click Save Changes.
 
vacares2

You can also check the box next to Only send a response to people in my Contacts box. If you don’t check this box, your out of office response will be sent to anyone who sends you an email. If you’re using a Gmail account from your company or school, you also have the option to send the automatic reply only to people in your organization. 

Note: Gmail automatically attaches your signature when it sends automatic replies. So, you don’t have to add your signature to your out of office message.

Gmail only sends a vacation response to each recipient once, unless the same person emails you again after four days or longer.
whatsappblock1

There are a couple of indicators that you may be blocked on WhatsApp:

You can no longer see a contact's last seen or online in the chat window.
 
whatsappblock2

You do not see updates to a contact's profile photo.
 
whatsappblock3

Any messages sent to a contact who has blocked you will always show one check mark (message sent), and never show a second check mark (message delivered). 

Any attempt to place will not go through.

If you try adding that person in a WhatsApp group you will notice an error message.

If you see all of the indicators above for a contact, this could mean that the user is blocking you. However, there are other possibilities. WhatsApp has made this intentionally ambiguous in order to protect your privacy when you block someone.
Googledocs

Step 1: To do that, log into your Google Drive and open your collection of documents.

Step 2: Hold down Ctrl key (Cmd on macOS) and highlight the ones you need.

Step 3: Then right-click and select “Download” from the menu.
 
multiplegdoctoword1

Google Docs will move all your documents into a Zip folder to download. Note that the amount of time it takes will vary depending on their size and your connection speed.
 
multiplegdoctoword2

The Zip file of docs will download to your computer in the appropriate Microsoft Office file format.
 
multiplegdoctoword3