You Don't Have to Tell the World on Facebook

Did you just break up?  Or finalize a divorce?

You don't have to tell all of your friends on Facebook that it has happened.  You can make the change on Facebook but do so in a way that Facebook doesn't automatically send out a status update that your relationship has changed.

Here's how.

Go to your profile and then click on About and then Family and Relationships (on the left side).

Under Relationship, you'll see the current setting, Friends or even Public.  Change this setting to Only Me.

Now you can make your relationship status change.  That's because only you will see the change.

At some time in the future, come back to the Relationship and change your setting back to Friends.

No one will be the wiser.


READ MORE

• Prioritize Your Facebook News Feed
• How to Delete Your Facebook Search History
• One Chat App to Rule Them All
• The Many Searches of Google
• The Sparkly End of Facebook

One Cool Tip.com

http://www.onecooltip.com

Cool Tips for a Cooler Life!

#facebook #status #relationship #privacy

Total an Excel Column Faster with This Keyboard Shortcut

When you are working with Excel, who has time to use the mouse to select a column and create a formula to total?

You don't have to.

A quick and easy shortcut will let you do it mouse-free.

To quickly sum a column, go to the first empty column at the bottom and then press and hold the ALT and then = keys.

The formula =SUM will be entered with the column range.  Press the Enter key to confirm.

That's it.  A quick and easy way to total a column in Excel.


READ MORE

• Tell Outlook Where to Search
• Select an Excel Data Set Faster with this Shortcut
• This Power Point Tip Will Make You the Focus
• Show or Hide Microsoft Word Format Marks
• Microsoft Words Magical Lorem Ipsum Generator

Listen to the One Cool Tech Tip Show

Podomatic | Tunein | Stitcher | iTunes

One Cool Tip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #SUM #formula #ALT #= #keyboard #shortcut

Use Google to Search for Specific File Types

Google is full of amazing features.

One of the best is the ability to search for specific documents based upon file types.

Perhaps you are looking for a Power Point (ppt or pptx) or an Adobe Acrobat file (pdf).

With Google, you can search for these files types, plus a whole lot more.

To do so, just type filetype:xxx search terms where xxx is the document type you are searching.  

For example, to search for PDFs concerning Hillary Clinton, enter 
filetype:pdf Hillary Clinton into Google:

Search result will return the desired documents.

Google indexes a number of common file types including:

• Adobe Portable Document Format (.pdf)
• Microsoft Excel (.xls, .xlsx)
• Microsoft PowerPoint (.ppt, .pptx)
• Microsoft Word (.doc, .docx)
• Rich Text Format (.rtf, .wri)

In addition, a number of technical and lesser-known file types are also indexed and searchable:

• Adobe Flash (.swf)
• Adobe PostScript (.ps)
• Autodesk Design Web Format (.dwf)
• Google Earth (.kml, .kmz)
• GPS eXchange Format (.gpx)
• Hancom Hanword (.hwp)
• HTML (.htm, .html, other file extensions)
• OpenOffice presentation (.odp)
• OpenOffice spreadsheet (.ods)
• OpenOffice text (.odt)
• Scalable Vector Graphics (.svg)
• TeX/LaTeX (.tex)
• Text (.txt, .text, other file extensions), including source code in common programming languages:Basic source code (.bas)
• C/C++ source code (.c, .cc, .cpp, .cxx, .h, .hpp)
• C# source code (.cs)
• Java source code (.java)
• Perl source code (.pl)
• Python source code (.py)
• Wireless Markup Language (.wml, .wap)
• XML (.xml)

You can also use the Google Advanced Search page to limit your search to several options including filetypes.  

However, not all searchable file types are available in the dropdown filetype list.

https://www.google.com/advanced_search

Enjoy!

READ MORE

• Google Now Shows Twitter in Desktop Search Results
• Google Hangouts Gets a New Website
• Reopen Closed Tabs in Chrome Browser
• The Many Searches of Google
• Is Google Down?  Learn How to Find Out
• Clear Your YouTube Search History
• Upload Your Photos to Google from your Desktop

Listen to the One Cool Tech Tip Show

Podomatic | Tunein | Stitcher | iTunes

One Cool Tip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Google #search #results #pdf #doc #filetype #advancedsearch

ICYMI: Twitter on Google, Siri, Hangouts' New Home, Outlook Search, Stitcher Radio, Snipping Tool

Another great week of Cool Tips on OneCoolTip.com.

This week we had cool tips for using the new Snipping Tool in Windows 10, searching in Microsoft Outlook, Google Hangouts' new website, forcing Siri to search Google, learning how to UNDO on an iPhone, Twitter Results in Google Searches.  In addition, we covered the latest episode of the Cool Tip Show and its addition to Stitcher Radio.

Here are the Cool Tips for this week:

The One Cool Tip Show, August 23, 2015, S1E5
Listen to the latest episode of The One Cool Tip Show.  Available on Podomatic, iTunes, Tunein Radio and Stitcher Radio.

Google Now Shows Twitter Results in Desktop Search Results
Learn how real-time live tweets are now included in Google search results.

Shake to UNDO on iPhone
Oops!  Did you just accidentally delete an email on iPhone?  Learn how to undo your mistake.

Force Siri to Search Google
Siri has her own mind.  Tell her to use Google on her next search!

Google Hangouts Gets a New Website
Hangouts gets a new home. Learn how you can use the video service at its new website.

Tell Outlook Where to Search
Outlook for the desktop is a great tool for email, contacts, calendar and notes.  But it can be overwhelming to find something.  Learn how you can choose where to search.

One Cool Tip Show Now on Stitcher Radio
The One Cool Tip Show is now on Stitcher Radio.  Listen online on the website or use the cool Apple iOS iPhone app or the Google Android app to listen on the go.

Snipping Tool in Windows 10 Now Lets You Capture Pop Up Menus with Delay Option
Snip. Snip. Snip.  Learn how the Snipping Tool has been updated in Windows 10 to be even better for capturing information from your computer screen.

Listen to the One Cool Tech Tip Show

Podomatic | Tunein | Stitcher | iTunes

One Cool Tip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Google #Twitter #Siri #iPhone #Hangouts #Outlook #Stitcher #Snipping #Windows10

The One Cool Tip Show, August 23, 2015 - S1E5

This week's podcast show for One Cool Tip is now available online.  You can find the podcast at Podomatic, Tunein Radio, Stitcher and in the iTunes store.

The weekly podcast covers tech news as well as more in depth coverage of the Cool Tips found here on www.OneCoolTip.com

Listen online to this week's show at:   The One Cool Tip Show, S1E5 - August 23, 2015

Listen on Tunein Radio: http://tunein.com/topic/?topicId=100493199

Listen on Stitcher Radio: http://www.stitcher.com/s?fid=71211&refid=stpr

You can find One Cool Tip podcast in the iTunes store: https://itunes.apple.com/us/podcast/one-cool-tip.com-podcast/id1026354128  

As well as searching using iTunes or the Podcast app on the iPhone and iPad.The RSS feed for the podcast is http://onecooltip.podomatic.com/rss2.xml

This week's episode is also available below:
--


--


READ MORE

• One Cool Tip Show, August 16, 2015
• One Cool Tip Show, August 9, 2015
• Blogcast, August 2, 2015
• Blogcast, July 26, 2015

One Cool Tip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#itunes #podcast #tunein #OneCoolTip #stitcher #tunein

Google Now Shows Twitter in Desktop Search Results

Searching on Google now brings even more relevant, real-time, search results.

How?

Google now shows relevant Twitter "tweets" in desktop search results.

This new feature is an expansion of Google already displaying Twitter search results in Google mobile search results.

The new desktop feature works for all queries performed in English.

For example, a search for "Donald Trump" returns a recent tweet from the verified account of Donald Trump, @realDonaldTrump.

This move benefits both Google and Twitter.  For Google, it means that users get real-time search results from the micro-blogging service.  For Twitter, it brings its service to millions of new users.

Enjoy!

READ MORE

• Google Hangouts Gets a New Website
• Reopen Closed Tabs in Chrome Browser
• The Many Searches of Google
• Is Google Down?  Learn How to Find Out
• Clear Your YouTube Search History
• Upload Your Photos to Google from your Desktop
• Take Back Your Inbox with Google Inbox

Listen to the One Cool Tech Tip Show

Podomatic | Tunein | Stitcher | iTunes

One Cool Tip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Google #Twitter #tweets #search #results #desktop

Shake to Undo on iPhone

Oops.  Did you just accidentally delete or archive an email on your iPhone?

You can undo that.

Just shake, shake, shake.

Many apps let you shake to UNDO the last action.

You can also shake your iPhone when you type to UNDO or REDO typing in most apps.

But like most good things, it can have a downside.  Some users report that their iPhones constantly try to undo actions and display the pop-up alert.  This is caused by excess shaking of the iPhone.

There's no on/off switch in iOS 8 or earlier.  But iOS 9 will have an option to toggle this feature on or off.

Enjoy!

READ MORE

• Force Siri to Search Google
• "Siri, What Planes are Overhead?"
• "Siri, What is Zero Divided by Zero?"
• How to Turn Off or On Emergency Alerts on Your Phone
• Blocking Calls on Your Smart Phone
• How to Extend Your Smart Phone Battery Life

Listen to the One Cool Tech Tip Show

Podomatic | Tunein | Stitcher | iTunes

One Cool Tip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#iPhone #shake #undo #apple #ios