Wednesday, September 20, 2023

How to Set Tab Colors in Microsoft Excel

Microsoft Excel
Do you find yourself lost in a sea of identical Excel tabs? 

Have you ever wished for a way to visually distinguish your data sets? 

Here's a Cool Tip: Color-Code Your Excel Tabs,

Setting tab colors makes it easier to see your different tabs.


Here's how to do it.
  • Launch Microsoft Excel
  • Open the spreadsheet where you want to color the tabs.
  • Click on the tab you want to color. This will make it the active tab.
  • Right-click on the tab
  • Select Tab Color from the context menu. 
    • This will open a dialog box with color options.
  • Select your desired color from the palette. 
    • The tab will instantly change to reflect your choice.
  • Repeat steps for any other tabs you wish to color.

Set Tab Color in Microsoft Excel
fig. 1 - Set Tab Color in Microsoft Excel



That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!



READ MORE


OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Microsoft @Microsot #Excel #Tabs #Color #MicrosoftExcel #DataOrganization #TechTips #ProductivityHacks #OneCoolTip @OneCoolTip
at No comments:
Cool Tip Topics:

Tuesday, September 19, 2023

Secret Trick to Text Photos Faster in iOS 17

iOS17
Do you want to text photos faster in iOS using iMessage?

Here's a Cool Tip:  Press and Hold.

That's right.

Press and Hold the Plus sign to insert photos into your iMessage.


Plus Sign in iOS17 iMessage
fig. 1 - Plus Sign in iOS17 iMessage

Normally, when you press the Plus sign, you have several options to choose from.

For example, Camera, Photos, Stickers, etc.

Insert Options iOS 17 iMessage
fig. 2 - Insert Options iOS 17 iMessage

But, when you Press and Hold the Plus sign, you'll go directly to your photo album allowing you to select the photos you want to attach to your iMessage.

Press and Hold to Insert Photos in iOS 17
fig. 3 - Press and Hold + to Insert Photos in iOS 17


That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!


READ MORE


OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Apple @apple #iOS17 #iMessage #photography #iphonetips #iphonephotography #techtips #OneCoolTip @OneCoolTip 
at No comments:
Cool Tip Topics: , , ,

Monday, September 18, 2023

How to Master Split Screen in Microsoft Edge

Master the art of multitasking with our quick guide on splitting screens in Microsoft Edge, and transform your browsing experience into a more productive and efficient one.

By Rodger Mansfield, Editor
September 18, 2023

[Note: This Cool Updated 3/12/24 to reflect current steps to split screens in Microsoft Edge]

Microsoft Edge
Ever found yourself juggling between multiple tabs and wishing for a simpler way to view them all at once? 

Ever wondered if there’s a magic trick that could instantly organize your chaotic browser window? 

Here's a Cool Tip: Split the screens in Microsoft Edge.

Here's how to do it.
  1. Open Microsoft Edge and navigate to the page you want to split.
  2. Look for the Split Screen icon in the toolbar, which is usually located near the top-right corner of the browser window.
  3. Click on the Split Screen icon to divide your current tab into two separate screens.
  4. You can now navigate independently on each side of the split screen.
  5. To adjust the size of the screens, simply drag the slider in the middle to your preferred position.
  6. If you want to exit the split screen view, select the Close split screen (X) at the top right corner of the active screen.
Split Screen in Microsoft Edge
fig. 1 - Split Screen in Microsoft Edge


Enjoy!


Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

Do you have a Cool Tip or question? Email us at
onecooltip.com@gmail.com


READ MORE


Rodger Mansfield, a seasoned tech expert, is the mastermind behind OneCoolTip.com, where he serves as both writer and editor. With a keen eye for simplifying complex tech, Rodger delivers practical advice that empowers readers to navigate the digital world with confidence. Dive into OneCoolTip.com for a treasure trove of savvy tips and tricks that keep you one step ahead in tech.



OneCoolTip.com
Cool Tech Tips for a Cooler Life



#Microsoft @Microsoft #Edge #MicrosoftEdge #BrowserShortcuts #TechTips #ProductivityHacks #OneCoolTip @OneCoolTip 
at No comments:
Cool Tip Topics:

Sunday, September 17, 2023

How to Track Cruise Ships

Do you love cruising? 

Do you want to know where your favorite ship is right now?

Here's a Cool Tip: CruiseMapper.com

CruiseMapper is the the world's leading cruise ship tracking and itinerary website. 

CruiseMapper is a valuable tool for anyone who loves cruising. 

It's easy to use and provides a wealth of information about cruise ships. 
  • Track your favorite cruise ships: CruiseMapper is the world's most comprehensive cruise ship tracking website. You can see the real-time position of any cruise ship in the world, as well as its past and future itineraries.
  • Plan your next cruise vacation: CruiseMapper makes it easy to plan your next cruise vacation. You can search for cruises by destination, date, cruise line, and more. 
  • To learn more about cruise ships: CruiseMapper provides detailed information about all of the world's cruise ships. You can learn about their technical specifications, deck plans, amenities, and more.
Looking to get away?  

OneCoolTip recommends Travel For You. -Travel For You , 314-660-3039, for you travel planning needs.  

Tell Denise (Mrs. OneCoolTip) Hi!


CruiseMapper
fig. 1 - CruiseMapper.com

Here's how to do it.
  • Go to CruiseMapper.com.
  • In the search bar at the top of the page, type the name of the cruise ship you want to track or the destination you're interested in.
  • Click the Search button.
  • On the results page, click the name of the cruise ship or destination you want to learn more about.
  • On the cruise ship or destination page, you can see the ship's current position, its past and future itineraries, and other information.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Cruise #Ship #CruiseMapper #CruiseTracking #CruisePlanning #CruiseShips #CruiseVacation #TravelForYou #TechTips @OneCoolTip 
at No comments:
Cool Tip Topics:

Saturday, September 16, 2023

Windows Super Secret Keyboard Shortcuts to Open Microsoft Applications

Microsoft Windows
Do you think you know Windows?

Do you know the super secret keyboard shortcuts to open Microsoft Applications?

There's even one to open the Microsoft-owned LinkedIn website.

Here's a Cool Tip:  Secret Microsoft Application Keyboard Shortcuts.

 
Here's how to do it.

  • Press and hold the Control + Shift + Alt + Windows + a letter from the list below for each application.
  • For example, L for LinkedIn.

Application

Windows Keyboard Shortcut

LinkedIn

CTRL + SHIFT + ALT + WIN + L

Word

CTRL + SHIFT + ALT + WIN + W

Excel

CTRL + SHIFT + ALT + WIN + X

PowerPoint

CTRL + SHIFT + ALT + WIN + P

Outlook

CTRL + SHIFT + ALT + WIN + O

Microsoft Teams

CTRL + SHIFT + ALT + WIN + T

OneDrive

CTRL + SHIFT + ALT + WIN + D

OneNote

CTRL + SHIFT + ALT + WIN + N


The keyboard shortcut to open LinkedIn on Windows is CTRL + SHIFT + ALT + WIN + L. 

This shortcut opens LinkedIn in your default browser. 

You can also use this shortcut to open other Office apps, including Word, Excel, PowerPoint, Outlook, Microsoft Teams, OneDrive and OneNote.

That's it!

Enjoy!


Please LIKE and SHARE OneCoolTip.com!

READ MORE


OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Microsoft #keyboardshortcut #LinkedIn #Word #Excel #PowerPoint #Outlook #MicrosoftTeams #OneDrive #OneNote #techtips #OneCoolTip #Microsoft 
at No comments:
Cool Tip Topics: , , , , , , , ,

Friday, September 15, 2023

How to Create Custom Emojis

Do you love emojis? 

Want to take your emoji game to the next level? 

Here's a Cool Tip: Check out Google's Emoji Kitchen feature. 

With Emoji Kitchen, you can create custom emoji stickers by combining two emojis.

You could create a dancing pizza emoji, a crying robot emoji, or even a cat emoji riding a unicorn emoji. 

Here's how to do it.
  • Go to www.google.com and search for "Emoji Kitchen." 
  • Select Get Cooking button.
  • Click on the two emojis that you want to combine.
  • Emoji Kitchen generates a custom emoji sticker.
  • Once you've found an emoji that you like, click on it to copy it to your clipboard. 
  • You can then paste the emoji into any messaging app or social media platform.


Google Emoji Kitchen
fig. 1 - Google's Emoji Kitchen


Emoji Kitchen is a fun and creative way to express yourself. 

With so many different combinations to choose from, you're sure to find the perfect emoji to express your thoughts and feelings.

Start cooking up your own custom emoji today!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!


READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life


#EmojiKitchen #Google #Emojis #Stickers #TechTips #OneCoolTip @OneCoolTip @Google
at No comments:
Cool Tip Topics: ,

Thursday, September 14, 2023

How to Crop and Zoom in iOS 17 with Just a Tap

iOS17
Have you ever wanted to crop and zoom in on a photo on your iPhone, but found the process to be a bit too tedious? 

Here's a Cool Tip: Check out the new Crop with Zoom feature in iOS17.

In iOS 17, Apple has made it easier than ever to do both with just a tap.

iOS 17 will be available to users to download starting on September 18, 2023.

Here's how to do it.

  • Open the Photos app
  • Select the photo you want to crop and zoom in on.
  • Pinch and zoom the photo with two fingers until you've reached the desired zoom level.
  • Tap the Crop button in the top-right corner of the screen.
iOS17 Crop Crop
fig. 1 - iOS17 Crop

  • Drag the corners of the cropping frame to select the area of the photo you want to keep.

iOS17 Crop Done
fig. 2 - iOS17 Crop - Done
  • Tap Done to save your changes.

Cropping and zooming in on photos in iOS 17 is now easier than ever with the new one-tap crop feature. 

And be sure to visit the word-famous Missouri Botanical Garden on your next visit to St. Louis!

Enjoy!

READ MORE


OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Apple @apple #iOS17 #cropping #zooming #photography #iphonetips #iphonephotography #techtips #OneCoolTip @OneCoolTip #MoBot @MoBot 

at No comments:
Cool Tip Topics: , , , ,

Wednesday, September 13, 2023

How to Use Siri or Hey Siri in iOS 17

Do you want to be able to use Siri hands-free on your iPhone? 

Do you want a shorter "wake" word to use on your iPhone?

Here's a Cool Tip: Set Your iPhone to Respond to just Siri.

With the new iOS 17, you can now just say Siri to activate Siri, without having to say Hey Siri. 

This is a great way to control your iPhone without having to touch it, which can be helpful when you're driving, cooking, or doing other things that require your hands.

iOS 17 will be available to users to download starting on September 18, 2023.

Here are the steps on how to set up Siri or Hey Siri in iOS 17:
  • Open the Settings app on your iPhone.
  • Tap on Siri & Search.
  • Under Ask Siri, tap on Listen for.
  • Select Siri or Hey Siri.
iOS 17 Siri Setting
fig. 1 - iOS Siri Setting


That's it! 

Once you've set up Siri or Hey Siri, you can start using it to control your iPhone hands-free. 

Here are some things you can ask Siri to do:
  • Set alarms and timers
  • Make calls and send messages
  • Play music and podcasts
  • Get directions
  • Search the web
  • Control smart home devices
Enjoy!


Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life
  
#apple #ios #ios17 #iphone #ipad #siri #heysiri #handsfree #voiceactivated #smartphone #TechTips #OneCoolTip @OneCoolTip @Apple
at No comments:
Cool Tip Topics: , , ,

Tuesday, September 12, 2023

Hey Chrome, Where's My Download?

Google Chrome
Where did my download go?

Did you know that Google Chrome moved the download list? 

Here's a Cool Tip: Check out the new Chrome Download feature.

The new download tray in Google Chrome is located to the right of the address bar. 

This replaces the legacy download experience that was at the bottom of the screen. 

This new feature makes it easier to manage your downloads and provides more control over how they are handled.

To use the new download feature, click on the download icon in the toolbar. 

New Chrome Download Icon
fig. 1 - New Chrome Download Icon

If the icon does not display, CTRL + J or select Downloads from the three dot icon at the top right-hand corner of the address bar.

The Recent Downloads screen will appear.

Chrome Recent Downloads
fig. 2 - Chrome Recent Downloads


Select Show all downloads.

This will open the download tray, which will list all of your current downloads.


Chrome Download
fig. 3 - Chrome Downloads

From the download tray, you can pause, resume, or cancel a download. 

You can also open the folder where a download is saved - Select Show in folder.

The new download feature in Chrome is a significant improvement over the old download bar. 

It makes it easier to manage your downloads and provides more control over how they are handled. 

Enjoy!


Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Google #chrome #download #newfeatures #browser #tech #TechTips #OneCoolTip @Google @OneCoolTip 
at No comments:
Cool Tip Topics:

Monday, September 11, 2023

How to Master Formulas in Microsoft Word

Have you ever found yourself wishing you could perform calculations right within your Word document? 

Have you ever wondered how to make your tables in Word more dynamic and functional? 

Here's a Cool Tip:  Use the Formula feature in Microsoft Word.

That's right.

Formulas in Microsoft Word.

Microsoft Word offers a powerful feature that allows you to use formulas within tables, much like in Excel. 

Let's walk through  the process of using the formula function in Microsoft Word and explain the concept of positional arguments.


Formulas in Microsoft Word
fig. 1 - Formulas in Microsoft Word

Here's how to do it.
  • Insert a table into your Word document where you want to perform calculations.
  • Fill the cells with the data you want to calculate.
  • Click on the cell where you want the result of your calculation to appear. 
    • If the cell is not empty, delete its contents. 
  • Go to the Layout tab, in the Data group, and click on Formula.
  • Begin your formula with an equal sign, followed by your chosen function.
Word Formula
fig. 2 - Word Formula
  • Enter a function in the Formula field, such as SUM, AVERAGE, COUNT, MAX, MIN, PRODUCT.
    • Click on Paste function to select a function.
  • Use Positional Arguments: In the parentheses that follow the function, add positional arguments like LEFT, RIGHT, ABOVE, BELOW. 
    • These refer to the relative position of the cells that you want to include in your calculation.
Notes:

  • Update Formula Results: 
    • The result of a formula is calculated when it is inserted and when the document containing the formula opens. You can also manually update the result of one or more specific formulas by selecting them and pressing F9.
  • Understanding Positional Arguments
    • Positional arguments are used to refer to cell positions relative to the cell containing the formula. For example, if you want to sum numbers in a column above a specific cell, you would use the argument ABOVE in your SUM function.
With these steps, you can now perform calculations right within your Word document. 

No more switching back and forth between Word and Excel for simple calculations!

Enjoy!


Please LIKE and SHARE OneCoolTip.com!


READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Microsoft #Word #MicrosoftWord #FormulasInWord #WordTips #Productivity #TechTips #OneCoolTip @Microsoft @OneCoolTip

at No comments:
Cool Tip Topics: ,
Subscribe to: Posts (Atom)