Monday, August 31, 2015

Use This Keyboard Shortcut to Access The Ribbon Menu Bar in Word, Excel, Power Point and Outlook

Microsoft Office logo
When using Microsoft Office products such as Excel, Word, Power Point and Outlook, you can save time with a very cool keyboard shortcut.

Press the ALT key to access any Ribbon command.

Block letters will appear next to each command on the Ribbon bar.

ALT keyboard shortcut Microsoft Office Word - One Cool Tip www.onecooltip.com

Pressing a subsequent letter such as H will display will display the Home submenu.

ALT keyboard shortcut Microsoft Office Word H - One Cool Tip www.onecooltip.com

Select the command you want by pressing the desired letter key.

To go back one level, press the ESC key.  And press ALT key to turn off this function.

Enjoy!


READ MORE

One Cool Tip.com
Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #Word #PowerPoint #ALT #keyboard #shortcut

Coolest Tips in August 2015

August has been a very busy month with thousands of visitors and page views.

Some of the Cool Tips have really taken off and have been shared and viewed by thousands.

So it's worth taking note to look at the Coolest Tips for August 2015:
(based upon page views in August 2015)


Invoke GodMode in Windows 10
Don't drive yourself crazy searching through the Control Panel looking for the screen where you can make a settings change in Windows 10.  By invoking GodMode, you can get a super Control Panel window that has all of the options in one neat place.

Reopen Closed Tabs in Chrome Browser
Another cool tech tip that went viral this week is a simple one.  When you accidentally close a tab in Chrome, you can easily reopen it just where you left off.  Learn how this to do this.

Siri, What Flights are Overhead?
Let Apple's personal assistant, Siri, identify the planes that are flying overhead.  It's a very cool trick.

Use Your iPhone Headphones to Take Photos
Learn how you can improve your photos by using your iPhone headphones as a remote shutter release.

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



One Cool Tip.com
Cool Tech Tips for a Cooler Life!

#GodMode #Windows #Chrome #Siri #iPhone #headphones #photos #Google

Sunday, August 30, 2015

ICYMI: Google File Type Search, Excel SUM Tip, Facebook Privacy, YouTube Shortcuts, Minimize Windows, Twitter Direct Messages, NASA Ringtones

ICYMI In Case You Missed It One Cool Tip www.onecooltip.com
Another great week of tech tips at One Cool Tip.  

Each week more people discover the cool tech tips here and also listen to the One Cool Tip Show on their favorite streaming radio or podcast app.


Cool Tech Tip topics this week include using using Google to search for specific file types, learning how to total an Excel column fast with a keyboard shortcut, how to protect your privacy on Facebook, learning the secret YouTube keyboard shortcuts, shaking things up to minimize Windows, learning more about Twitter's decision to remove the 140-character limit from Direct Messages and a throwback tip regarding  NASA ringtones and sounds.


One Cool Tip Show on PlayerFM
The One Cool Tip Show - www.onecooltip.com

And in great news for One Cool Tip, the One Cool Tip Show is now playing on PlayerFM. PlayerFM is a website and Android app that lets users discover and listen to podcasts. You'll find highly rated podcasts from Fox News, NPR, Voice of America and others. And now you can listen to the One Cool Tip Show on Player.fm One Cool Tip Show S1E6 - August 30, 2015 Listen to the latest episode of the One Cool Tip Show online. The show is available from a number of services including iTunes, Podomatic, Tunein Radio, Stitcher Radio and now PlayerFM,

Here are the very Cool Tips from the week:

Using Google to Search for Specific File Types
Did you know you can search for specific file types using Google? Perhaps you are looking for a Power Point (that's a .ppt or a .pptx format) or an Adobe Acrobat file (usually known as a pdf). With Google, you can search for these files types, plus a whole lot more. Google will return search results for that file type. Check out the full Cool Tip to see examples of how this is done including a longer list of file types that are searchable.

Total an Excel Column Fast 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. This quick and easy shortcut will let you do it mouse-free. Check out the full tip to see an example of how this is done.

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 to all of your Facebook friends.

Top Secret YouTube Keyboard Shortcuts
Do you know the secret keyboard commands that make watching YouTube videos easier? You can pause, jump forward or backward or mute the sound, Read the Cool Tip to learn more.

Minimize Desktop Windows with Shake
Do you have a clutter of windows open on your desktop in Windows 10 Windows 8 or Windows 7? It's a pain to minimize all of the windows except the one you want. But with this Cool Tip, you can quickly minimize all windows by using the Windows "Shake". Check out the tip to learn more.

Twitter Removes 140-character Limit from Direct Messages
Can't write it all in just 140 characters? Don't worry. Twitter has removed the 140-character limit on Direct Messages. The limit remains for public tweets tho. You can start a private message to anyone who follows you. Learn more about this important change to Twitter.

And a Cool Throwback Tip of the Week.

NASA Ring Tones Launched
What could be more geekier than NASA ringtones? Check out the new collection of NASA sounds from historic spaceflights and current missions. You can hear the roar of a space shuttle launch or Neil Armstrong's "One small step for (a) man, one giant leap for mankind" every time you get a phone call. Or, you can hear the memorable words "Houston, we've had a problem," every time you make an error on your computer.



One Cool Tip.com
http://www.onecooltip.com
Cool Tech Tips for a Cooler Life!


 #onecooltip #podcast #playerFM #NASA #ringtones #twitter #Windows #Facebook #Excel #Google

Saturday, August 29, 2015

One Cool Tip Show S1E6 - August 30, 2015

The One Cool Tip Show - www.onecooltip.com
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, S1E6 - August 30, 2015

You can also list to the current and past epsiodes via Podomatic, Tunein, PlayerFM, Stitcher Radio and iTunes:


Use the Podcast app on the iPhone and iPad---search for One Cool Tip.  

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.com
Cool Tech Tips for a Cooler Life!

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

Twitter Removes 140-character Limit from Direct Messages

twitter
Can't write it all in just 140 characters?

Rejoice.

Your cries have been heard.

Twitter has removed the 140-character limit on Direct Messages.

But the limit remains for public tweets tho.

Twitter Direct Message 140 character limit - One Cool Tip www.onecooltip.com
Maybe you don't know that Twitter has a user-to-user message feature called Direct Messages.

Available from the twitter.com site as well as the Android and iOS apps, you can start a private message to anyone who follows you.

For more detailed instructions on direct messaging, check out Twitter's help page:

Twitter's About Direct Messages help Page

We've covered several cool Twitter tips.  Check them out!  Google Now Shows Twitter in Desktop Search ResultsMute Your Twitter UsersUp the Periscope - Broadcast Live From Your Phone and Secret Twitter Photo Search

Oh, and be sure to follow @OneCoolTip on Twitter.

Enjoy!


READ MORE
One Cool Tip.com
Cool Tech Tips for a Cooler Life!

#Twitter #tweets #DM #Direct #Message

Friday, August 28, 2015

Minimize Windows on the Desktop Using Shake

Windows 10 logo
Do you have a clutter of windows open on your desktop in Windows 10?

It's a pain to minimize all of the windows except the one you want.

But with this Cool Tip, you can quickly minimize all windows by using the Windows 10 "Shake".

Here's how you do it.

Grab and hold the top of the window you want to keep open and then shake back and forth by quickly moving the window back and forth several times.


One Cool Tip desktop - www.onecooltip.com

All of the other windows will minimize.

One Cool Tip desktop - www.onecooltip.com


That's it.  You've decluttered your desktop with the Windows 10 "shake"!


This fun trick also works in Windows 7 and Windows 8.

READ MORE

One Cool Tip.com
Cool Tech Tips for a Cooler Life!

#Windows10 #Microsoft #shake #windows #close #desktop #Windows7 #Windows8

Thursday, August 27, 2015

One Cool Tip Show Now on PlayerFM

The One Cool Tip Show - www.onecooltip.com
The One Cool Tip Show Podcast is now playing on PlayerFM.

The One Cool Tip Show is a weekly show that covers tech news and cool tech tips.

PlayerFM is a website and Android app that lets users discover and play podcasts.

You can find it here: One Cool Tip Show on PlayerFM.

You can listen to the show on the PlayerFM site from most PCs, smart phones and tablets.

You can now also listen on the new PlayerFM Google Android app.





One Cool Tip.com
Cool Tech Tips for a Cooler Life!

#podcast #onecooltip #PlayerFM #stitcher #podomatic #itunes #GooglePlay

Top Secret YouTube Keyboard Shortcuts

YouTube One Cool Tip
YouTube is a phenomenal site to watch a variety of videos.

Millions upon millions of videos are available.

There are hidden keyboard commands that make watching easier,

These shortcuts can be used when not in full-screen mode.  M (mute) and the Space Bar (Play/Pause) can be used anytime.

Top Secret You Tube Keyboard Shortcuts

- Space Bar   Play / Pause

- J    Jump back 10 seconds.
- K   Play / Pause
- L   Jump forward 10 seconds
- M  Mute audio
- <--    --> (left/right arrow keys)  rewind and fast forward
- Home   Go to beginning
- End   Go to end

0  Jump to beginning of the video
1  Jump to 10% of the video
2  Jump to 20% of the video
3  Jump to 30% of the video
4  Jump to 40% of the video
5  Jump to 50% of the video
6  Jump to 60% of the video
7  Jump to 70% of the video
8  Jump to 80% of the video
9  Jump to 90% of the video

Try these out the next time you are watching YouTube.  Hint:  You'll need to mouse click into the video at least once to ensure the shortcuts can affect the video playback.

And don't forget to try these cool shortcuts when you are watching Netflix.

Enjoy!

READ MORE


One Cool Tip.com
Cool Tips for a Cooler Life!

#youtube #video #keyboard #shortcut

Wednesday, August 26, 2015

You Don't Have to Tell the World on Facebook

Facebook logo
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.

Facebook relationship about

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

One Cool Tip.com
Cool Tips for a Cooler Life!

#facebook #status #relationship #privacy

Tuesday, August 25, 2015

Total an Excel Column Faster with This Keyboard Shortcut

Microsoft Excel
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.


ALT = Excel Toal Column tip www.onncooltip.com

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




One Cool Tip.com
Cool Tech Tips for a Cooler Life!

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

Monday, August 24, 2015

Use Google to Search for Specific File Types

Google logo
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.

Enjoy!

Sunday, August 23, 2015

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



ICYMI One Cool Tip www.onecooltip.com
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.


One Cool Tip - www.onecooltip.com


One Cool Tip.com
Cool Tech Tips for a Cooler Life!

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