How to Copy a Formula Down an Entire Column in Google Sheets

You are working inside a Google Spreadsheet where a formula needs to copied down to the last row of the sheet. There are several ways to solve this problem.

The easiest approach to copy down formulas is to use the fill handle in Google Sheets. Write your formula in the first row of your spreadsheet, and then point your mouse to the lower right corner of the formula cell.

fill-down-sheet-formula.gif

The pointer changes into a fill handle (black plus symbol) that you can drag to the last row of the sheet. The fill handle will not just copy down the formulas to all the adjacent cells but also copies the visual formatting.

If you need to copy the formulas across cells but sans any formatting, select the cell that contains the formatting and press Ctrl+C to copy it to the clipboard. Next select the range where that formula needs to applied, right-click, choose Paste Special and Paste Formula only.

copy-formula-without-formatting.png

Apply Formula to the Entire Column in Google Sheets

If you have hundreds of rows in a Google Spreadsheet and you want to apply the same formula to all rows of a particular column, there’s a more efficient solution than copy-paste – Array Formulas.

Highlight the first cell in the column and type the formula as earlier. However, instead of specifying a single cell as a parameter, we’ll specify the entire column using the B2:B notation (start from cell B2 and go all the way down to the last row of column B).

Then press Ctrl+Shift+Enter, or Cmd+Shift+Enter on Mac, and Google Sheets will automatically surround your formula with ARRAYFORMULA function.

arrayformula-entire-column.gif
TAX: ArrayFormula(ROUND(B2:B*18, 2))
AMOUNT: ArrayFormula(B2:B+C2:C)

Thus, we are able to apply the formula to the entire column of the spreadsheet with only a single cell. Array Formulas are more efficient as they process a batch of rows in one go. They are also easier to maintain as you only need to modify a single cell for edit the formula.

One issue that you may have noticed with the above formulae is that it applies to every row in the column where you have only want to add formulas to rows that contain data and skip the blank rows.

This can be done by adding an IF contain to our ARRAYFORMULA so that it doesn’t apply the formula the any of the blank rows.

Google Spreadsheet offers two functions to help test whether a cell is empty or now.

  • ISBLANK(A1) – Returns TRUE if the referenced cell is empty.
  • LEN(A1) <> 0 – Returns TRUE if the referenced cell not empty, FALSE otherwise

Our modified Array Formulas would therefore read:

Using ISBLANK(Cell Reference):

arrayformula.png

Using LEN(Cell Reference)

sheet-arrayformula.png

Use Array Formulas inside Column Headers

In our previous examples, the text of the column titles (like Tax, Total Amount) was pre-populated and the formulas were only added to the first row of the dataset.

We can further improve our formula so that they can be applied to the column header itself. If the index of the current row is 1, calculated using the ROW() function, the formula outputs the column title else it performs the calculation using the formula.

=ArrayFormula(IF(ROW(B:B)=1,"Tax",IF(ISBLANK(B:B),"",ROUND(B:B*18, 2))))
arrayformula-first-row.png

Auto Fill Formulas into Google Form Submissions

ARRAYFORMULA functions are particularly useful for Google Forms when the form responses are getting saved inside a Google Sheet. You cannot do live calculations inside Google Forms but they can be performed inside the spreadsheet that is collecting the responses.

You can create new columns inside the Google Spreadsheet and apply the ARRAYFORMULA to the first row of the added columns.

As soon as a new form submission is received, a new row would be added to the Google Sheet and the formulas would be cloned and automatically applied to the new rows without you have to copy-paste stuff.

How to Use VLOOKUP inside ARRAYFORMULA

You can combine ARRAYFORMULA with VLOOKUP to quickly perform a lookup across an entire column.

Say you have a “Fruits” sheet that lists the fruit names in column A and the corresponding prices in column B. The second sheet “Orders” has fruit names in column A, the quantity in column B and you are supposed to calculate the order amount in column C.

arrayformula-vlookup.png
=ArrayFormula( IF(ROW(A:A)=1, "Total", IF(NOT(ISBLANK(A:A)), VLOOKUP(A:A, Fruits!A2:B6, 2, FALSE) * B:B, "")))

In simple English, if the row of the current cell is 1, ouput the column title in plain text. If the row is greater than 1 and the column A of the current row is not empty, perform a VLOOKUP to fetch the price of the item from the Fruits sheet. Then multiply that price with the quantity in cell B and output the value in cell C.

If your VLOOKUP range is in another Google Spreadsheet, use the IMPORTRANGE() function with the ID of the other Google Sheeet.

Please note that you may have to use semicolons in the spreadsheet formulas instead of commas for some locales.

How to Search Videos within a YouTube Channel on your Mobile Phone

YouTube, the second largest search engine after Google, offers extremely powerful search commands but there’s one important search functionality that YouTube is yet to include in its mobile app for both Android & iPhone.

You cannot search for videos within a specific YouTube channel while using YouTube on a mobile phone or tablet. For instance, if you would like to search for Tesla videos that were uploaded on the MKBHD channel, you simply can’t do that from your mobile phone.

youtube-video-search.jpg

This search-within-channel feature has been available for long on YouTube’s desktop website – see screenshot – but none of the YouTube apps have it yet. This is surprising considering the fact that more than half of video views on YouTube now come from mobile devices.

That’s where our mini YouTube search engine can help. Sign-in with your YouTube account, enter a search query, select any YouTube channel that you are subscribed to and it will show a list of all matching videos within the selected channel.

seach-youtube-channel.jpg

The app builds a list of all channels that you are currently subscribed to and prepares a nice drop-down with the channels sorted by name. The drop-down also features the channel icons so it is easier for you to find the channel you are looking for.

Also, if you have multiple YouTube accounts, you can click the “Logout” link to sign-out from the current account and log in to any other account. The app requests read-only access to your YouTube account and does not store any of your data anywhere.

If you are a desktop uses, you’ll probably never need this site but for mobile users, our mini YouTube search engine could be worth bookmarking until YouTube incorporates this missing feature to their native apps.

Related: How to Copy YouTube Playlists

How to Search Google Drive Like a Pro!

You have lots of files in your Google Drive and it can take some effort to find that elusive file you’ve been looking for. For instance, how do you quickly find the sales presentation that James shared with you last week? Or how do you locate a specific resume among the hundreds of other PDF files in your Google Drive folders?

Like Gmail and Twitter, Google Drive supports a plethora of advanced search operators that will help you quickly find the exact file you’ve been looking for. You can use search operators on the Google Drive website and the Drive mobile apps. Chrome users can type drive.google.com in the search bar, press tab and enter the search query.

How Search Works in Google Drive

Google Drive, by default, will return files where the search query matches the file’s title, the content or the file’s description. It can also identify objects inside photos so a search for “birthday” may retrieve images of cakes in your Drive.

google-drive-search-results.png

Drive will also perform a OCR and search for text inside images and scanned PDFs. I have stored a scanned copy of my Aadhaar card in Google Drive. I only remember the first few digits of my Aadhaar number but that is sufficient to locate the scanned image of the card in Drive.

How to Find Files in your Google Drive

You can use search operators to filter your search results in Google Drive.  Multiple search operators can be combined with boolean operators like AND or OR (in capitals) to further narrow down your results and find the exact file or document you’ve been looking for.

google-drive-search.png

Google Drive Search Tips & Tricks

Find Google spreadsheets shared by your colleague James
type:spreadsheet from:James

Find Photos or Images containing photos of cakes
type:image owner:me cakes

Find files in trash that were modified today
is:trashed after:2017-07-28

Find PDF files that are shared with me
type:pdf -owner:me

Find files that are shared with me and added to my Google Drive
in:myFiles -owner:me

Find all folders in my Google Drive that are created by me
type:folder -owner:me

Find presentations that I’ve shared with my secretary
type:presentation to:secretary@domain.com

Tip: You can also use the Google Drive Auditor add-on to generate a detailed list of users who can access your Google Drive files.

Find all files that I’ve recently viewed or added in Google Drive
Click “Recent” in the sidebar or use this link

Bonus Tip: Find the biggest files in Google Drive

Gmail offers the larger_than and smaller_than search operator to find all the space-hogging emails in your account. Google Drive offers no search by size operator buy you can use this special link – drive.google.com/#quota – to sort files by size and the ones taking the most space would be listed at the top.

How to Search Google Drive Like a Pro!

You have lots of files in your Google Drive and it can take some effort to find that elusive file you’ve been looking for. For instance, how do you quickly find the sales presentation that James shared with you last week? Or how do you locate a specific resume among the hundreds of other PDF files in your Google Drive folders?

Like Gmail and Twitter, Google Drive supports a plethora of advanced search operators that will help you quickly find the exact file you’ve been looking for. You can use search operators on the Google Drive website and the Drive mobile apps. Chrome users can type drive.google.com in the search bar, press tab and enter the search query.

How Search Works in Google Drive

Google Drive, by default, will return files where the search query matches the file’s title, the content or the file’s description. It can also identify objects inside photos so a search for “birthday” may retrieve images of cakes in your Drive.

google-drive-search-results.png

Drive will also perform a OCR and search for text inside images and scanned PDFs. I have stored a scanned copy of my Aadhaar card in Google Drive. I only remember the first few digits of my Aadhaar number but that is sufficient to locate the scanned image of the card in Drive.

How to Find Files in your Google Drive

You can use search operators to filter your search results in Google Drive.  Multiple search operators can be combined with boolean operators like AND or OR (in capitals) to further narrow down your results and find the exact file or document you’ve been looking for.

google-drive-search.png

Google Drive Search Tips & Tricks

Find Google spreadsheets shared by your colleague James
type:spreadsheet from:James

Find Photos or Images containing photos of cakes
type:image owner:me cakes

Find files in trash that were modified today
is:trashed after:2017-07-28

Find PDF files that are shared with me
type:pdf -owner:me

Find files that are shared with me and added to my Google Drive
in:myFiles -owner:me

Find all folders in my Google Drive that are created by me
type:folder -owner:me

Find presentations that I’ve shared with my secretary
type:presentation to:secretary@domain.com

Tip: You can also use the Google Drive Auditor add-on to generate a detailed list of users who can access your Google Drive files.

Find all files that I’ve recently viewed or added in Google Drive
Click “Recent” in the sidebar or use this link

Bonus Tip: Find the biggest files in Google Drive

Gmail offers the larger_than and smaller_than search operator to find all the space-hogging emails in your account. Google Drive offers no search by size operator buy you can use this special link – drive.google.com/#quota – to sort files by size and the ones taking the most space would be listed at the top.

How to Search Google Drive Like a Pro!

You have lots of files in your Google Drive and it can take some effort to find that elusive file you’ve been looking for. For instance, how do you quickly find the sales presentation that James shared with you last week? Or how do you locate a specific resume among the hundreds of other PDF files in your Google Drive folders?

Like Gmail and Twitter, Google Drive supports a plethora of advanced search operators that will help you quickly find the exact file you’ve been looking for. You can use search operators on the Google Drive website and the Drive mobile apps. Chrome users can type drive.google.com in the search bar, press tab and enter the search query.

How Search Works in Google Drive

Google Drive, by default, will return files where the search query matches the file’s title, the content or the file’s description. It can also identify objects inside photos so a search for “birthday” may retrieve images of cakes in your Drive.

google-drive-search-results.png

Drive will also perform a OCR and search for text inside images and scanned PDFs. I have stored a scanned copy of my Aadhaar card in Google Drive. I only remember the first few digits of my Aadhaar number but that is sufficient to locate the scanned image of the card in Drive.

How to Find Files in your Google Drive

You can use search operators to filter your search results in Google Drive.  Multiple search operators can be combined with boolean operators like AND or OR (in capitals) to further narrow down your results and find the exact file or document you’ve been looking for.

google-drive-search.png

Google Drive Search Tips & Tricks

Find Google spreadsheets shared by your colleague James
type:spreadsheet from:James

Find Photos or Images containing photos of cakes
type:image owner:me cakes

Find files in trash that were modified today
is:trashed after:2017-07-28

Find PDF files that are shared with me
type:pdf -owner:me

Find files that are shared with me and added to my Google Drive
in:myFiles -owner:me

Find all folders in my Google Drive that are created by me
type:folder -owner:me

Find presentations that I’ve shared with my secretary
type:presentation to:secretary@domain.com

Tip: You can also use the Google Drive Auditor add-on to generate a detailed list of users who can access your Google Drive files.

Find all files that I’ve recently viewed or added in Google Drive
Click “Recent” in the sidebar or use this link

Bonus Tip: Find the biggest files in Google Drive

Gmail offers the larger_than and smaller_than search operator to find all the space-hogging emails in your account. Google Drive offers no search by size operator buy you can use this special link – drive.google.com/#quota – to sort files by size and the ones taking the most space would be listed at the top.

How to Search Google Drive Like a Pro!

You have lots of files in your Google Drive and it can take some effort to find that elusive file you’ve been looking for. For instance, how do you quickly find the sales presentation that James shared with you last week? Or how do you locate a specific resume among the hundreds of other PDF files in your Google Drive folders?

Like Gmail and Twitter, Google Drive supports a plethora of advanced search operators that will help you quickly find the exact file you’ve been looking for. You can use search operators on the Google Drive website and the Drive mobile apps. Chrome users can type drive.google.com in the search bar, press tab and enter the search query.

How Search Works in Google Drive

Google Drive, by default, will return files where the search query matches the file’s title, the content or the file’s description. It can also identify objects inside photos so a search for “birthday” may retrieve images of cakes in your Drive.

google-drive-search-results.png

Drive will also perform a OCR and search for text inside images and scanned PDFs. I have stored a scanned copy of my Aadhaar card in Google Drive. I only remember the first few digits of my Aadhaar number but that is sufficient to locate the scanned image of the card in Drive.

How to Find Files in your Google Drive

You can use search operators to filter your search results in Google Drive.  Multiple search operators can be combined with boolean operators like AND or OR (in capitals) to further narrow down your results and find the exact file or document you’ve been looking for.

google-drive-search.png

Google Drive Search Tips & Tricks

Find Google spreadsheets shared by your colleague James
type:spreadsheet from:James

Find Photos or Images containing photos of cakes
type:image owner:me cakes

Find files in trash that were modified today
is:trashed after:2017-07-28

Find PDF files that are shared with me
type:pdf -owner:me

Find files that are shared with me and added to my Google Drive
in:myFiles -owner:me

Find all folders in my Google Drive that are created by me
type:folder -owner:me

Find presentations that I’ve shared with my secretary
type:presentation to:secretary@domain.com

Tip: You can also use the Google Drive Auditor add-on to generate a detailed list of users who can access your Google Drive files.

Find all files that I’ve recently viewed or added in Google Drive
Click “Recent” in the sidebar or use this link

Bonus Tip: Find the biggest files in Google Drive

Gmail offers the larger_than and smaller_than search operator to find all the space-hogging emails in your account. Google Drive offers no search by size operator buy you can use this special link – drive.google.com/#quota – to sort files by size and the ones taking the most space would be listed at the top.

The Easiest Way to Extract Email Addresses from your Gmail Account

Introducing Gmail Address Extractor, a web app that parses email messages in your Gmail mailbox, finds all the email addresses in them and stores the list in a Google Sheet. You can export the sheet as a CSV file and import into Google Contacts, Outlook address book, MailChimp, or any other mailing list software.

The online extractor app can find email addresses that are contained in the message body, the email signature, the subject line and the FROM, TO, CC, BCC & Reply-To fields of the email message. The app cannot, however, extract emails from file attachments.

gmail address extractor

Getting started is easy and requires no software installation. Just go to emailextract.pro and sign-in with your Gmail or Google Inbox account. You can also sign with your G Suite (Google Apps) account.

The app can pull email addresses from any label in your Gmail account or you can specify advanced search criteria and email addresses would only be extracted from the matching email threads. For instance, you could set the advanced search rule as from:paypal newer_than:7d and only PayPal emails received in the last week will be processed.

You can extract email addresses from messages that come via form submissions, email addresses of customers that are found inside the PayPal and Stripe receipts, email addresses of your newsletter subscribers and so on.

If you would like to extract email addresses from all Gmail folders in one go, choose “Anywhere” in the label drop-down.

After you’ve specified the search criteria, you need to select the email fields for extraction and the destination Google Sheet where the email addresses would be saved. The sheet will automatically remove any duplicate email addresses that it may encounter during the extraction.

extract-email-fields.png

Once the email addresses are in the Google Sheet, you can use filters inside sheets to exclude addresses from certain domains.

Email Extractor runs locally in your browser and not a byte of your email data is shared or uploaded anywhere. It does require a one-time authorization to various Google services since the app needs to read Gmail messages and save the list in a Google sheet in your Google Drive. You can read the app’s privacy policy to learn more.

The extractor app is completely free for lite users if you need to process less than 300 email messages. For large mailboxes, the pricing is $29 USD and you can process an unlimited number of email threads with the paid edition.

The app is also available as a Gmail addon in the Google Store. It works with Gmail only but if you can import your Yahoo or Outlook email message into Gmail, the addon can process them as well.

Also see: Save Gmail Messages in Google Drive

How to Add the Facebook Messenger Chat Widget in your Website


Facebook Messenger, with more than a billion monthly users. enables brands to have real-time one-on-one conversations with their customers. Businesses can also embed Facebook messenger buttons on their website and visitors, whether they have a pre-sales question or need to resolve an issue, can initiate a conversation with the simple click of a button.

The only downside with embedded buttons is that visitors will have to exit your website to send a message through Facebook Messenger. Wouldn’t it be nice if people could stay on your website and yet be able to message you through Facebook?

Well, that’s possible with the help of the Facebook chat widget (demo).  The widget sits in the corner of your page and when someone clicks the Facebook Messenger icon, a non-intrusive chat window pops up where visitors can type and send you a private message.

Here’s a live demo of the Facebook chat widget.

Embed Facebook Chat Widget

It takes one easy step to integrate the Facebook Chat widget in your website. 

All you to do is copy-paste the simple piece of code below anywhere in your website template and it will add the widget to all your pages. Remember to replace digitalinspiration with the vanity URL (name) of your own Facebook page.

<style>.fb-livechat,.fb-widget{display:none}.ctrlq.fb-button,.ctrlq.fb-close{position:fixed;right:24px;cursor:pointer}.ctrlq.fb-button{z-index:1;background:url(data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiA/PjwhRE9DVFlQRSBzdmcgIFBVQkxJQyAnLS8vVzNDLy9EVEQgU1ZHIDEuMS8vRU4nICAnaHR0cDovL3d3dy53My5vcmcvR3JhcGhpY3MvU1ZHLzEuMS9EVEQvc3ZnMTEuZHRkJz48c3ZnIGVuYWJsZS1iYWNrZ3JvdW5kPSJuZXcgMCAwIDEyOCAxMjgiIGhlaWdodD0iMTI4cHgiIGlkPSJMYXllcl8xIiB2ZXJzaW9uPSIxLjEiIHZpZXdCb3g9IjAgMCAxMjggMTI4IiB3aWR0aD0iMTI4cHgiIHhtbDpzcGFjZT0icHJlc2VydmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiPjxnPjxyZWN0IGZpbGw9IiMwMDg0RkYiIGhlaWdodD0iMTI4IiB3aWR0aD0iMTI4Ii8+PC9nPjxwYXRoIGQ9Ik02NCwxNy41MzFjLTI1LjQwNSwwLTQ2LDE5LjI1OS00Niw0My4wMTVjMCwxMy41MTUsNi42NjUsMjUuNTc0LDE3LjA4OSwzMy40NnYxNi40NjIgIGwxNS42OTgtOC43MDdjNC4xODYsMS4xNzEsOC42MjEsMS44LDEzLjIxMywxLjhjMjUuNDA1LDAsNDYtMTkuMjU4LDQ2LTQzLjAxNUMxMTAsMzYuNzksODkuNDA1LDE3LjUzMSw2NCwxNy41MzF6IE02OC44NDUsNzUuMjE0ICBMNTYuOTQ3LDYyLjg1NUwzNC4wMzUsNzUuNTI0bDI1LjEyLTI2LjY1N2wxMS44OTgsMTIuMzU5bDIyLjkxLTEyLjY3TDY4Ljg0NSw3NS4yMTR6IiBmaWxsPSIjRkZGRkZGIiBpZD0iQnViYmxlX1NoYXBlIi8+PC9zdmc+) center no-repeat #0084ff;width:60px;height:60px;text-align:center;bottom:24px;border:0;outline:0;border-radius:60px;-webkit-border-radius:60px;-moz-border-radius:60px;-ms-border-radius:60px;-o-border-radius:60px;box-shadow:0 1px 6px rgba(0,0,0,.06),0 2px 32px rgba(0,0,0,.16);-webkit-transition:box-shadow .2s ease;background-size:80%;transition:all .2s ease-in-out}.ctrlq.fb-button:focus,.ctrlq.fb-button:hover{transform:scale(1.1);box-shadow:0 2px 8px rgba(0,0,0,.09),0 4px 40px rgba(0,0,0,.24)}.fb-widget{background:#fff;z-index:2;position:fixed;width:360px;height:435px;overflow:hidden;opacity:0;bottom:0;right:24px;border-radius:6px;-o-border-radius:6px;-webkit-border-radius:6px;box-shadow:0 5px 40px rgba(0,0,0,.16);-webkit-box-shadow:0 5px 40px rgba(0,0,0,.16);-moz-box-shadow:0 5px 40px rgba(0,0,0,.16);-o-box-shadow:0 5px 40px rgba(0,0,0,.16)}.fb-credit{text-align:center;margin-top:8px}.fb-credit a{transition:none;color:#bec2c9;font-family:Helvetica,Arial,sans-serif;font-size:12px;text-decoration:none;border:0;font-weight:400}.ctrlq.fb-overlay{z-index:0;position:fixed;height:100vh;width:100vw;-webkit-transition:opacity .4s,visibility .4s;transition:opacity .4s,visibility .4s;top:0;left:0;background:rgba(0,0,0,.05);display:none}.ctrlq.fb-close{z-index:4;padding:0 6px;background:#365899;font-weight:700;font-size:11px;color:#fff;margin:8px;border-radius:3px}.ctrlq.fb-close::after{content:'x';font-family:sans-serif}</style>

<div class="fb-livechat">
  <div class="ctrlq fb-overlay"></div>
  <div class="fb-widget">
    <div class="ctrlq fb-close"></div>
    <div class="fb-page" data-href="https://www.facebook.com/digital.inspiration/" data-tabs="messages" data-width="360" data-height="400" data-small-header="true" data-hide-cover="true" data-show-facepile="false">
      <blockquote cite="https://www.facebook.com/digital.inspiration/" class="fb-xfbml-parse-ignore"> </blockquote>
    </div>
    <div class="fb-credit"> 
      <a href="https://www.labnol.org/software/facebook-messenger-chat-widget/9583/" target="_blank">Facebook Chat Widget by Digital Inspiration</a>
    </div>
    <div id="fb-root"></div>
  </div>
  <a href="https://m.me/digital.inspiration" title="Send us a message on Facebook" class="ctrlq fb-button"></a> 
</div>
	
<script src="https://connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.9"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script>$(document).ready(function(){var t={delay:125,overlay:$(".fb-overlay"),widget:$(".fb-widget"),button:$(".fb-button")};setTimeout(function(){$("div.fb-livechat").fadeIn()},8*t.delay),$(".ctrlq").on("click",function(e){e.preventDefault(),t.overlay.is(":visible")?(t.overlay.fadeOut(t.delay),t.widget.stop().animate({bottom:0,opacity:0},2*t.delay,function(){$(this).hide("slow"),t.button.show()})):t.button.fadeOut("medium",function(){t.widget.stop().show().animate({bottom:"30px",opacity:1},2*t.delay),t.overlay.fadeIn(t.delay)})})});</script>

The widget would work across all sorts of websites including Blogger & WordPress blogs, WooCommerce stores, and most static HTML websites. It would however not work with the new version of Google Sites as they do not offer an option to embed JavaScript in pages.

When visitors send a message via the Facebook Chat widget, it goes right to the inbox of your Facebook Page. As the business owner, you can install the Facebook Pages Manager app on your mobile phone to view and respond to messages.  The customer will be notified of your response inside their Facebook Messenger app.

The message history is preserved forever, there’s no limit on the number of messages you can receive in a day and your page can simultaneously receive pages from multiple visitors.  The widget also invites the visitor to like your Facebook Page.

One more thing. If the web page is using an ad blocker or if they have disabled social plugins, the widget nicely defaults to the messenger button.

Master YouTube Video Search with Simple Commands

YouTube is the second largest search engine on the Internet after Google. This guide discusses advanced search operators that you can use with your YouTube search queries for more accurate video searches.

YouTube Search

How to Search YouTube like a Pro!

Find a specific YouTube channel
royal wedding, channel

YouTube will have numerous videos related to the royal wedding but if you are only looking for their official YouTube channel, add the word channel to your query separated by a comma.

Watch live videos on YouTube
zoo, live

Add live to your search queries and watch live stream videos such as live news, live gaming channels, live concerts, sports events or even cooking sessions.

Limit your search to recently uploaded videos
oprah winfrey, this week

This will only show recent videos related to Oprah that have been uploaded to YouTube in the past week. You may also use “today” or “this month” to limit your search to videos that were uploaded in the past month.

Find only official videos, no fan material please
never say never, partner

If you are looking for the ‘official’ Justin Bieber track and don’t want to see any parodies or fan material in the search results, add the word ‘partner’ to your search query.

Find movies on YouTube
jackie chan, movie

Yes, you can find full-length movies on YouTube. The search operator for finding movies is, you got it right, movie.

Find 4K or HD only videos on YouTube
the king’s speech trailer, hd

Add the keyword hd to your search query and YouTube will only show High-definition video clips that are either 720p (1280×720) or 1080p (1920×1080 pixels). Or add 4k to limit your search to 4K content.

Find 3D video clips on YouTube
avatar, 3d

Got a pair of 3D glasses? Add the keyword 3D to your search query and discover 3D videos. You may also enjoy some 3D content on YouTube without the glasses – see details.

Find video playlists on YouTube
bryan adams, playlist

Playlists are a great option if you want to find and watch (or listen) multiple related videos in one go – like all the Old Spice commercials or your favorite Savage Garden tracks. You may also copy YouTube playlists to your own account.

Find lengthy videos on YouTube
tom and jerry cartoons, long

Add the keyword long to your search query and YouTube will only return videos that are at least 20 minutes in length. Or append short to limit search to videos that are 4 minutes in length or less.

Perform exact-match searches on YouTube
allintitle:”google goes gaga”

You can borrow the popular allintitle search operator from Google on YouTube to perform exact title matches. Might be useful when the original video is not available in your country due to geographic restrictions.

Mix and Match YouTube Search operators
ted talks, hd, this month, long

The best part about YouTube search is that you combine multiple search operators with commas and apply them all to your query (much like the Boolean AND operator). The above example will help use find all TED talks that have recently been uploaded to YouTube.

Liked it? See similar search guides for Google News, Google Alerts and Windows Search.

Using WhatsApp as a Private Store for your Documents and Notes

WhatsApp is a perfect messaging app for staying in touch with friends and family. It is super-fast, works on nearly all phones (including desktop computers) and Facebook has no plans to charge WhatsApp users.

You have been using WhatsApp primarily for text messaging and calling but there are a couple of other interesting uses for WhatsApp that will help boost the utility value of this app even further. Other than communicating with the external world, you can also use WhatsApp to:

  1. Capture and save ideas, notes, voice memos, scanned documents and everything else in you own private storage space that is accessible from everywhere.
  2. Quickly transfer web links, documents, screenshots, and other files between your computer and phone without having to sign-up for another service.

whatsapp-group.png

The idea is simple. You create a new virtual contact inside WhatsApp and, everything that you wish to capture privately, you can just share it with this virtual contact.

It is not possible to send WhatsApp messages to your own number but there’s a simple hack to get around this problem. Create a new WhatsApp group with just a single participant – you. Here’s how:

  1. Open WhatsApp on your phone and create a new group.
  2. Add any contact from your address book to this group. Give your group a name and save.
  3. Now go to the group in WhatsApp, tap the subject to view the list of participants.
  4. Tap and hold the lone participant in this list and remove them from the group.

That’s it. What you now have a private store in WhatsApp that is visible only to you and accessible from the web (desktop) and your mobile phone.

If you wish to transfer a document from computer to phone, open web.whatsapp.com on the computer, send the file to this group and it will instantly become available on your phone. There’s search built-in so you can easily find messages by keyword later.

Thank you Sidin Vadukut (blog, books, twitter) for this useful tip.