One Cool Tip .com

Tuesday, January 24, 2023

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.

Here's how to do it:

Press and hold the Ctrl and Spacebar to select an entire column in a worksheet.

Press and hold the Shift and Spacebar to select an entire row in a worksheet.

Press and hold the Ctrl and Shift and Spacebar to select the entire worksheet.

If the worksheet contains data, press and hold Ctrl and Shift and Spacebar to select the current region.

Press Ctrl and Shift and Spacebar a second time to select the current region and its summary rows.
Press Ctrl and Shift and Spacebar a third time to select the entire worksheet.
When you select an object, pressing Ctrl and Shift and Spacebar selects all objects on a worksheet.
Press Alt and Spacebar to display the Control menu for the Excel window.

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 #Excel #spacebar

Monday, January 23, 2023

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?

Are you getting your personal documents confused with your work documents when you have them both open?

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

--> Open one or more new virtual desktops.

The multiple desktops feature in Windows is a cool way to have multiple desktop screens to keep you organized. Even if you only have one screen.

Each desktop can be specific to different types of PC activities, for example, work and personal.

Or you can create multiple desktops - one each for each specific project.

You can even quickly switch desktops before a meeting to reduce the clutter and avoid oversharing your desktop information.

Here's how to create multiple virtual desktops in Windows 10 and 11:

Windows 11

Select the Task View icon on the Taskbar
Select New desktop.

Microsoft Windows Task View with Highlights

Open the apps you want to use on that desktop.
You can also use the Windows key + Tab shortcut on your keyboard.

To switch to another desktop, select Task view again.

Windows 10

On the taskbar, select Task view > New desktop +.
Open the apps you want to use on that desktop.
To switch to another desktop, select Task view again.
You can also use the Windows key + Tab shortcut on your keyboard.
To switch to another desktop, select Task view again.

To Move or Share a window from one desktop to another:

Select the Task View button
Hover over the virtual desktop with the app you want to move
Right-mouse click on the thumbnail of the app you want to move.
Select Move to, and then select the virtual desktop where you want to move the app.

Enjoy!

If you like OneCoolTip, please Like and Share!

READ MORE

#Windows #desktop

Sunday, January 22, 2023

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

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

Check out these cool tips this week:

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?

#Microsoft #Excel #NewWindow

How to Use Alexa on a Windows PC

Do you need Alexa when you are away from your Alexa device?

#Microsoft #Alexa #Windows

Discover the Secret to Finding Where Any Movie or Show is Streaming Online

With so many streaming sites now available, how can you find where your favorite movie or TV shows are available? But how can you find which site has the movie or show you are looking to watch?

#streaming

How to Transform Your TV into a Digital Art Gallery

Are you missing great art from your house?

Here's a Cool Tip for bringing beautiful digital artwork into your living room.

#art #digitalart

How to Build Digital Sand Art

Remember making those multi-colored sand in the bottle crafts when you were young?

Relive the fun of your youth with this Friday Funday Cool Tip.

#sand

Use This Secret Windows Shortcut to Add Emojis to Your Documents and Messages

Do you emoji?

If you use Windows 10 or 11, you'll like this Cool Tip to add emojis to your emails, word documents and other Windows applications.

#emoji #windows

Shocking Cool Tip: How to Turn Off Someone's Phone Alarm!

Annoyed by your partner's ringing and/or vibrating phone alarm?

Are they already up and getting ready but their phone alarm continues to ring?

And the phone is waaaay over on the other side of the bed?

There's a shockingly simple way to turn it off without having to touch the phone.

#phone #alarm

If you like OneCoolTip, please Like and Share!

OneCoolTip.com

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

Shocking Cool Tip: How to Turn Off Someone's Phone Alarm!

Annoyed by your partner's ringing and/or vibrating phone alarm?

Are they already up and getting ready but their phone alarm continues to ring?

And the phone is waaaay over on the other side of the bed?

There's a shockingly simple way to turn it off without having to touch the phone.

--> Call the phone number!

The alarm will stop.

Of course, you'll want to make sure the person is awake. Maybe.

Enjoy your morning peace and quiet!

If you like OneCoolTip, please Like and Share!

READ MORE

#phone #alarm

Saturday, January 21, 2023

Use This Secret Windows Shortcut to Add Emojis to Your Documents and Messages

Do you emoji?

If you use Windows 10 or 11, you'll like this Cool Tip to add emojis to your emails, word documents and other Windows applications.

Here's how to do it:

Windows key + . (period)

This brings up the Windows Emoji Keyboard.

You can select an emoji or even search for one from the extensive list.

Enjoy!

If you like OneCoolTip, please Like and Share!

READ MORE

#emoji #windows

Friday, January 20, 2023

How to Build Digital Sand Art

Remember making those multi-colored sand in the bottle crafts when you were young?

Relive the fun of your youth with this Friday Funday Cool Tip: https://thisissand.com/

ThisIsSand allows you to drop multi-colored sand piles to create amazing works of art.

ThisIsSand can be played in a laptop/desktop web browser (thisissand.com) OR with the Thisissand app on iOS (iPhone) or Android devices.

Get the mobile app from the Apple App Store or the Google Play Store.

Enjoy!

If you like OneCoolTip, please Like and Share!

READ MORE

#ThisIsSand

Thursday, January 19, 2023

How to Transform Your TV into a Digital Art Gallery

Are you missing great art from your house?

Don't have a few extra thousands or millions dollars just taking up space?

Here's a Cool Tip for bringing beautiful digital artwork into your living room.

Here's how to do it:

On your Smart TV, or TV connected to a FireTV, Google Chromecast or Roku box, open the YouTube app (you may need to go to the App store to download first)
Search for TV Art. Free TV Art, Digital Art or Free Digital Art (really any combination of these words will find the free digital art videos)
Select the video you desire
You should also subscribe to the channel so you can find it again easily the next time you want to view it.
Select Play from the YouTube app.
Most of these art videos play for 3-4 hours.
Here's a favorite of mine that displays many Van Gogh paintings.