Cool Tech Tips for a Cooler Life - www.One Cool Tip .com

Monday, January 16, 2023

How to Open a New Window View in Microsoft Excel

Are your Microsoft Excel documents so large that you can't see what happens when you change data?

Opening a new window view in Microsoft Excel can be a great way to organize and compare different parts of your spreadsheet.

This can be useful when your Excel document is large and you want to see how changes in one part of the document affects another part.

Here's how to do it:

Open Microsoft Excel
Open the spreadsheet you want to work with.
Click the View tab on the ribbon at the top of the screen.
In the Window group, click the New Window button. This will open a new window with the same spreadsheet.

You can now move and resize the windows as needed.
To switch between the windows, click the View tab again and select the window you want to work with from the Switch Window.
Now you can make changes in one window and compare it with the other window side by side.

Tips:
-This works best when using more than one monitor.

-You can also use the Arrange All button in the Window group to automatically arrange all open windows on your screen.
-If you have multiple windows open, you can use the Switch Windows button to quickly switch between them.

By using this feature you can easily work with multiple parts of your spreadsheet at the same time, which can save you time and make your work more efficient.

If you like OneCoolTip, please Like and Share!

READ MORE

OneCoolTip.com

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

#Microsoft #Excel #NewWindow

Sunday, January 15, 2023

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

What a great week of Cool Tips here at OneCoolTip.com

Check out these cool tips this week:

1. Draw a Perfect Straight Line, Square or Circle with This Cool Tip

When using Microsoft Word, Excel, Outlook or PowerPoint, you can add shapes, such as boxes, circles, and arrows, to your documents, email messages, slide shows, and spreadsheets. Make them perfect every time!

2. Beware! AI May Take Your Job. Check This Cool Tip on How It Can Happen

AI, Artificial Intelligence, has long been the subject of Science Fiction. Is it going to take your job?

3. How to Turn On Stereo Sound for Your iPhone

Are you hearing stereo sound on your iPhone? You might not be. Learn how.

4. 4 Ways to Lock Your Windows Screen

Do you lock your PC Window when you are not at your desk? Maybe you should. Learn how.

5. How to Bounce Cats

What could be more fun than bouncing cats? It's Friday Funday!

6. How to Learn About Consumer Product Recalls

Do you know if a product has been recalled due to a major safety concern? Not everything is as safe as we think it is. Learn how to stay informed.

7. How to Use Google as a Dictionary

When you need to know the definition of a word you encounter, use Google as your online dictionary!

If you like OneCoolTip, please Like and Share!

OneCoolTip.com

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

How to Use Google as a Dictionary

Paradigm.

What does that word mean?

When you need to know the definition of a word you encounter, use Google as your online dictionary!

Google can provide the meaning for the word including providing an audio pronunciation and other information.

Here's how to do it:

to learn more about the word Paradigm, enter define paradigm into the Google search box.

Google will return the definition for the word, a link to an audio file to hear how to pronounce the word (click the speaker icon), similar words and origins of the word.

This cool Google dictionary tip is a quick and easy way to keep on learning!

If you like OneCoolTip, please Like and Share!

READ MORE

OneCoolTip.com

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

#Google #dictionary #search

Saturday, January 14, 2023

Stay Safe! How to Learn About Consumer Product Recalls

Do you know if a product has been recalled due to a major safety concern?

Not everything is as safe as we think it is.

Products are routinely recalled due to safety concerns.

Examples includes electrical lamps, child car seats, vacuums, baby rockers and bicycles.

Sometimes the risk to consumers is low but in other cases the risk of death or major injury is very high.

The US Product Safety Commission recalls products due to safety concerns and posts this information on their website.

Often the company can send a repair part to make the product safe or refund purchases if there is a major death or injury risk.

Check out recalls at the US Consumer Product Safety Commission's website: https://www.cpsc.gov/Recalls

Recalls are posted and you can search for product recalls based on dates, categories and categories.

In addition, you can sign up for recall emails: https://www.cpsc.gov/Newsroom/Subscribe

If you like OneCoolTip, please Like and Share!

4 Ways to Lock Your Windows Screen

Dictate Your Masterpiece in Microsoft Word

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!
#cpsc #recall

Friday, January 13, 2023

How to Bounce Cats

Sometimes you need to take a few minutes to get your mind off of work.

And what could be more fun than bouncing cats?

Check out Cat Bounce for your Friday Funday Website Cool Tip!

https://cat-bounce.com/

Remember, some cats are bouncier than others, so that means more force = more bounce. Use a gentler touch if you're losing cats.

Enjoy!

If you like OneCoolTip, please Like and Share!

OneCoolTip.com

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

#cat #bounce

Thursday, January 12, 2023

4 Ways to Lock Your Windows Screen

Do you lock your PC Window when you are not at your desk?

Maybe you should.

Your PC probably contains a lot of personal and business information such as financial data, photos, and browsing history.

There are multiple ways to lock your Microsoft Windows screen.

Do you know them all?

Here are four ways to lock your Windows screen:

1. Windows-L
Press and hold the Windows key and the L key on your keyboard.

2. Ctrl-Alt-Del
Press Ctrl-Alt-Delete keys. Select Lock.

3. Start button
Select the Start button in the bottom-left corner. Select your user icon and then select Lock.

4. Auto lock via screen saver
You can set your PC to lock automatically when the screen saver starts.

Go to Control Panel

Appearance & Personalization

Change screen saver

check the box for On resume, display logon screen.

Be sure to set a time for how long your PC should wait before starting the screen saver.

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!

#Microsoft #Windows #lock #screen

Wednesday, January 11, 2023

How to Turn On Stereo Sound for Your iPhone

Are you hearing stereo sound on your iPhone?

You might not be.

By default, Apple turns off stereo sound and leaves audio as mono sound.

This is so that all sounds play in both the left and right ear. That's great for people who have hearing issues.

But what if you want stereo sound?

Here's how to turn it on so that stereo sounds are played through the left and right channels.

Go to Setting
Select Accessibility
Select Audio/Visual
Mono Audio:
- Turn off to use stereo sound
- Turn on to combine the left and right channels to play the same sound content.

That's it. Enjoy your stereo sounds!

If you like OneCoolTip, please Like and Share!

READ MORE

OneCoolTip.com

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

#iPhone #stereo #sound

Tuesday, January 10, 2023

Beware! AI May Take Your Job. Check this Cool Tip on How It Can Happen

AI, Artificial Intelligence, has long been the subject of Science Fiction.

But now it's here for everyone.

Several AI projects have been released recently, including ChatGPT.

This AI project will write and create content. From serious technical code to the humorous poems and songs.

It's a glimpse of what's to come.

Will we start seeing AI generated news articles? Computer code? Malware?

So, let's try it. For a sample, asked ChatGPT to write a poem about Robin Williams.

You can try it out here: https://chat.openai.com/

If you like OneCoolTip, please Like and Share!

READ MORE

OneCoolTip.com

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

#AI #RobinWilliams #poem #ArtificialIntelligence #ChatGPT

Monday, January 9, 2023

Draw a Perfect Straight Line, Square or Circle with This Cool Tip

When using Microsoft Word, Excel, Outlook or PowerPoint, you can add shapes, such as boxes, circles, and arrows, to your documents, email messages, slide shows, and spreadsheets.

But how do you get a perfect circle rather than an oval? Or a square rather than a rectangle? Or a straight line rather than a jagged one?

The secret Cool Tip is to press and hold the SHIFT key when dragging the mouse to create the shape.

Press Shift Key to draw perfect line square circle

Here's how to do it:

On the Insert tab, click Shapes
Click the shape icon you want to draw, click anywhere in the workspace and drag to place the shape.
To create a perfect line, square or circle (or constrain the dimensions of other shapes), press and hold Shift key while you drag to create the shape.

If you like OneCoolTip, please Like and Share!

READ MORE

OneCoolTip.com

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

#Shift #microsoft #word #excel #powerpoint

Sunday, January 8, 2023

Hide Memories from Your Facebook Feed

Facebook is used by millions of people around the world.

Users connect to friends to enjoy viewing and posting photos.

For most people, this is a fun and rewarding experience.

But this can turn around quickly when Facebook shares past posts, called "memories" in your feed that you'd rather no longer see again.

Perhaps it's a photo from an ex-spouse or a dearly departed friend or relative.

You can tell Facebook not to show you these "memories" based on a specific person or on certain days.

Here's the Cool Tip to do it from the web:

Hide Person

Go to facebook.com/memories.

Click Hide People under Settings.

Click Start typing a name... and enter the names of the people you don't want to see memories with.

Click Save.

Hiding memories of someone will hide any tagged photos or posts of that person in Memories.

Hide Certain Days

Go to facebook.com/memories.

Click Hide Dates below Settings.

Click Add New Date Range.

Select a start and end date for the date or dates you don't want to see memories from.