One Cool Tip .com

Tuesday, January 31, 2023

Unlock the Power of Your Data: Master the Microsoft Excel Data Filter in Just a Few Easy Steps!

For many long-time Microsoft Excel users, new features have been added that they might not know about.

Do you know how to use the Data Filter option so that you can filter your spreadsheet to only show the data that you want to view?

In the example below, we want to only view the Sales Agents from the NE Region.

Here's how to do it:

Select the data you want to filter.

Go to the "Data" tab in the ribbon. The "Sort & Filter" section will be visible.

Select "Filter".

Click on the drop-down arrow in the header cell of the column you want to filter. In this case, it's Column A named "Region". We'll only select "NE" by selecting that option and de-selecting all others.

Choose the filter criteria and select "OK" Now only rows where the Region has "NE" in the column cell will be visible in the list.

To remove the filter, go to "Sort & Filter" and select "Clear".

The list will return all data again.

That's it!

You can also filter more than one column at a time to obtain the dataset you want to view.

And if you If you like OneCoolTip, please Like and Share!

READ MORE

#Microsoft #Excel #data #filter

Monday, January 30, 2023

How Do You Undo an Undo in Windows?

How do you undo an 'Undo' when there's no 'Redo' available?

For example, you select text and type a paragraph.

Then you Undo with Control + Z.

But then you want that paragraph back?

How do you Undo your Undo?

If you've done this, don't panic!

Here's the Cool Tip:

All you have to do is press Control + Y!

That's It. Enjoy!

And if you If you like OneCoolTip, please Like and Share!

READ MORE

#Undo #Windows

OneCoolTip.com

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

Sunday, January 29, 2023

ICYMI: In Case You Missed It - Cool Tech Tips for the Week 1/29/23

We had a great week of Coop Tips here at www.OneCoolTip.com.

These tips included Cool Tips for using Microsoft Windows, Microsoft Excel, Microsoft Word, Apple iPhone and Google Assistant.

Check them all out!

And if you If you like OneCoolTip, please Like and Share!

OneCoolTip.com

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

Use This Cool Tip to Organize Your Windows, Documents and Applications While Working

Do you have too many confusing windows, documents and applications open on your Windows PC?

Here's a cool tip to help you better manage and organize your Windows screens.

#Windows #desktop

Be the Microsoft Excel Hero with These Spacebar Secrets

Do you know the power of the mighty spacebar when using Microsoft Excel?

The spacebar is a useful tool that can speed up selecting data in your spreadsheets.

#Microsoft #Excel #spacebar

And Now, A Change of Case in Microsoft Word

What happens if you accidently type several paragraphs in all UPPERCASE in Microsoft Word?

Don't worry, there's a Cool Tip for that.

#Microsoft #Word #text

How to Find Out if an Online Service is Down

Is the cloud service down?

Learn how to find out!

#DownDetector @systemdown

When You Need to Cleanse Your Eyes from the World Wide Web

Have you just seen too much crazy and weird stuff this week on the World Wide Web?

Check out this Cool Tip to cleanse your weary eyes!

#eyebleach #FridayFunday

How to Unlock Screen Rotation on an iPhone

Find out how to fix an iPhone screen that won't rotate.

#portrait #orientation #iPhone

How to Turn Off Slow WiFi Using Siri or Google Assistant

Learn how to turn off WiFi hands free!

#WiFi #Siri #GoogleAssistant

How to Turn Off Slow WiFi Using Siri or Google Assistant

Did you just automatically connect to a slow WiFi?

This can happen when you're away from your home WiFi and your phone has automatically joined a WiFi that is slow.

You can manually disable WiFi to jump back to your Carrier's data connection by clicking the menus.

But you can also just tell Siri or Google Assistant to turn off your WiFi connection.

“Hey Siri, turn off my WiFi”

When you know you have a solid WiFi connection again, just tell Siri or Google Assistant to turn it back on.

"Hey Siri, turn on my Wifi"

That's it! Enjoy.

If you like OneCoolTip, please Like and Share!

READ MORE

OneCoolTip.com

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

#WiFi #Siri #GoogleAssistant

Saturday, January 28, 2023

How to Unlock Screen Rotation on an iPhone

Sometimes when using an iPhone you'll need to rotate your phone to see a wider view of the content.

This is very useful when you are laying on your side and want to read on your phone or watch a video.

But what happens if the screen doesn't rotate?

It could be because the Portrait Orientation is locked.

To fix this, you'll need to turn it off.

Here's how to do it.

Swipe down from the top-right corner of your screen to open Control Center.
Tap the Portrait Orientation Lock button to make sure that it's off.

Rotate your iPhone sideways.

If the screen doesn't rotate, try using a different application such as Google Chrome or the Safari browser.

Conversely, there may be times when you DON'T want the screen to rotate. Make sure the Portrait Orientation is LOCKED.

Enjoy!

If you like OneCoolTip, please Like and Share!

READ MORE

#portrait #orientation #iPhone

Friday, January 27, 2023

When You Need to Cleanse Your Eyes from the World Wide Web

Have you just seen too much crazy and weird stuff this week on the World Wide Web?

And you just want to wash your eyes out with bleach? (don't do that!)

Then it's time to hurry on over to Eyebleach.me for Friday Fun Day!

Eyebleach.me offers a rotating selection of the cutest animals that will wash away even the most nastiest of mental images.

Select from Only Kittens, Only Cats, Only Dogs and Only Nature to cleanse your eyes and heal your soul!

Each cute photo will stay on the screen for a few moments before rotating to another photo.

So the next time you need to cleanse your eyes, be sure to check out Eyebleach.me!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#eyebleach #FridayFunday #TechTips #OneCoolTip @OneCoolTip

Thursday, January 26, 2023

How to Find Out if an Online Service is Down

Is the cloud service down?

Is it them or is it you?

That is the real question in today's modern world.

With so much of our lives dependent on the online services we use every day, we often have to troubleshoot when we can't access services.

How do we survive when Google, Facebook, Instagram, Apple, or Microsoft can't be used?

Is it their service that is down? Or is it your PC or phone? Or the WiFi? Or the broadband service?

Before you start rebooting or restarting an application, there are several places you can check first.

Here's how to do it.

First check out the amazing Downdetector service. Downdetector is powered by user reports and online indicators for thousands of services in dozens of countries. Make it your first stop.

If your outage is specific to one service and you still have net access, check out these company sites that provide online health statuses for their users:

A Google News Search for <service name> outage can also let you know if there is a widespread service disruption.