How to Set Tab Colors in 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.

fig. 1 - Set Tab Color in Microsoft Excel

That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• Windows Super Secret Keyboard Shortcuts to Open Applications
• How to Insert a Picture in a Cell in Microsoft Excel
• Summing It Up: The Many Ways to Total in Microsoft Excel

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Microsoft @Microsot #Excel #Tabs #Color #MicrosoftExcel #DataOrganization #TechTips #ProductivityHacks #OneCoolTip @OneCoolTip

Secret Trick to Text Photos Faster in iOS 17

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.

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.

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.

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

That's it!

Enjoy!

Check out these iOS 17 Cool Tips:

• How to Use the New iOS17 iPhone Auto Delete Verification Codes Feature
• How to Set Search Engines for iOS17
• How to Ping Your Apple Watch From Your iPhone
• How to Use Standby Mode in iOS17
• How to Set Multiple Timers 
• in iOS 17
• Secret Trick to Text Photos Faster in iOS 17
• How to Crop and Zoom in iOS 17 With Just a Tap
• How to Use Siri or Hey Siri in iOS17

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• How to Crop and Zoom in iOS 17 With Just a Tap
• How to Use Siri or Hey Siri in iOS17
• The Secret Truth of Turning Bluetooth Off on an iPhone

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Apple @apple #iOS17 #iMessage #photography #iphonetips #iphonephotography #techtips #OneCoolTip @OneCoolTip 

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]

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.

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

• Ride the Digital Wave: How to Play the Surf Game in Microsoft Edge
• How to Capture Full Page in Microsoft Edge
• How to Use Microsoft Edge Web Select Feature to Copy Formatted Content

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

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Microsoft @Microsoft #Edge #MicrosoftEdge #BrowserShortcuts #TechTips #ProductivityHacks #OneCoolTip @OneCoolTip 

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!

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

• How to Travel Like a Tech Pro
• Dude, Where's My Luggage?
• Travel the World from Your Couch

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Cruise #Ship #CruiseMapper #CruiseTracking #CruisePlanning #CruiseShips #CruiseVacation #TravelForYou #TechTips @OneCoolTip 

Windows Super Secret Keyboard Shortcuts to Open Microsoft Applications

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

• How to Enable Dark Mode in Microsoft Paint
• How to Use Windows Clipboard History
• Stop Apps from Scrolling in Windows Task Manager With This Cool Tip

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Microsoft #keyboardshortcut #LinkedIn #Word #Excel #PowerPoint #Outlook #MicrosoftTeams #OneDrive #OneNote #techtips #OneCoolTip #Microsoft 

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.

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

• Waddle on Over to the Saint Louis Zoo Penguin Cam
• Watch Adorable Puppies Play and Grow
• Get Your Daily Dose of Cuteness: Visit the Kitty Cam Today!

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#EmojiKitchen #Google #Emojis #Stickers #TechTips #OneCoolTip @OneCoolTip @Google

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

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.

fig. 1 - iOS17 Crop

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

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!

Check out these iOS 17 Cool Tips:

• How to Use the New iOS17 iPhone Auto Delete Verification Codes Feature
• How to Set Search Engines for iOS17
• How to Ping Your Apple Watch From Your iPhone
• How to Use Standby Mode in iOS17
• How to Set Multiple Timers 
• in iOS 17
• Secret Trick to Text Photos Faster in iOS 17
• How to Crop and Zoom in iOS 17 With Just a Tap
• How to Use Siri or Hey Siri in iOS17

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• How to Use Siri or Hey Siri in iOS17
• The Secret Truth of Turning Bluetooth Off on an iPhone
• Unlock the Power of Your iPhone with this Cool Tip: Press and Hold

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

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