The Secret Shortcut You Need to Know About the Excel Formula Bar!

Are you tired of scrolling left and right to view long formulas in Microsoft Excel? 

Do you want to learn a quick and easy way to expand the formula bar? 

Expanding the formula bar in Microsoft Excel is a useful trick that can help you view long formulas without having to scroll left and right. 

There are two ways to expand the formula bar in Excel. 

• The first way is to hover your mouse near the bottom of the formula bar until you see an up-and-down white arrow. 
• Click that arrow and drag down until the bar gets big enough to accommodate the entire formula. 
• The second way is to use a keyboard shortcut: Press Ctrl + Shift + U.

fig. 1 - Expand the Excel Formula Bar

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• Unleashing the Power of Excel: The Ultimate Keyboard Shortcut
• Boost Your Productivity with This Cool Status Bar Tip!
• How AI is Changing the Way We Work: An Example for Bing Chat AI, Excel and Data Analysis
• How to Master Excels Flash Fill Feature

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #MicrosoftExcel @Microsoft #ExcelTips, #ExcelTricks, #ExcelShortcuts, #MicrosoftExcel, and #SpreadsheetHacks #TechTip #OneCoolTip 

Use this Microsoft Edge Cool Tip to Go To a Website

Are you tired of copying and pasting URLs from web pages to your browser’s address bar? 

Do you want to save time and effort while browsing the web? 

If yes, then you’re in the right place! 

In this Cool Tip you'll learn how to use Microsoft Edge browser to highlight text and go to a website. 

Most websites will hyperlink a web address so that readers can just click.

But when you see just plain text, use this Cool Tip.

It will help you save time and make your browsing experience more efficient. 

Let’s get started!

Here's how to do it.

1. Open Microsoft Edge browser.
2. Highlight the text you want to go to a website.
3. Right-click on the highlighted text and select “Go to” option.
4. The highlighted text will be automatically copied into the address bar and you will be taken to that website.

fig. 1 - Example of Highlighting Text to go to a Website

That's it!

Enjoy.

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• Move Files Between Devices with Ease Using This Cool Tip
• Beware!  AI May Take Your Job. Check this Cool Tip on How It Can Happen
• How to Use the Read Aloud Function in Microsoft Word 365!

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

#MicrosoftEdge #Microsoft @Microsoft #Edge #HighlightText #GoToWebsite #TechTip #OneCoolTip

How to Convert Currency in Windows 11

Do you have a big international trip coming up?

Are you tired of manually converting currency? 

Do you want to know how to quickly convert currency? 

Here's a Cool Tip: use the Windows 11 search feature to convert currency.

For example, you can use this Cool Tip to determine how many Great Britain Pounds $100 will buy. 

Here's how to convert currency using Windows 11 search.

• Open the Windows 11 search bar by clicking on the magnifying glass icon in the taskbar or by pressing the Windows key + S.
• Type 100 USD to GBP in the search bar and press Enter.
• The search results will display the converted amount of $100 in British pounds.

fig. 1 - Convert Currency in Windows 11 Search

It’s that simple! 

You can use this method to convert any currency you want. Windows 11 search also supports other units of measurement such as temperature, distance, and weight.

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• Open Apps Fast With This Windows Cool Tip
• How to Access Chat Option in Windows 11Search Taskbar
• Boost Your Productivity With Windows 11 Autocorrect

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

#Windows11 #CurrencyConversion #TechBlog #WindowsTips #Microsoft @Microsoft #TechTip #OneCoolTip

How to Create Graphics and Illustrations Using PowerPoint

Are you tired of spending hours creating artwork and design elements for your projects? 

Here's a Cool Tip: Look no further than Microsoft PowerPoint! 

This versatile tool is not just for presentations - it can also be used to create artwork and designs in just a few simple steps. 

This can save you the cost and complexity of buying more complicated and expensive software.

Here's how to use PowerPoint as a simple solution for creating artwork, text and design elements for normal computer users.

• Open PowerPoint.
• Select a blank slide.
• Click on the Insert tab and select Shapes to add shapes to your slide.
• You can also add text by clicking on the Insert tab and selecting Text Box.
• To add images or pictures, click on the Insert tab and select Pictures.
• Right-mouse click any object to Format.  Change the color of lines and fill.  Change the size and pattern for any line or object.
• As you can see in fig. 1 below,  a snip of an Excel sheet was brought into PowerPoint, red boxes drawn around key areas, and a large red arrow was added.  Then this image was snipped, saved and then brought into a final document.
• You can also use PowerPoint's built-in design templates to create professional-looking designs for your artwork.

fig. 1 - Use PowerPoint to Compose Graphics

• Use the Windows Snipping Tool (shortcut is Shift+Windows+S keyboard shortcut) to select your new artwork.  Save the image for future use as well.
• You can also save the PowerPoint deck for future use if you need to modify the image.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• Use Snipping Tool to Capture Screenshots in Windows
• How to Show or Hide the Ribbon in Office
• Draw a Perfect Straight Line, Square or Circle With This Cool Tip!

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

#PowerPoint #Artwork #DesignElements #DigitalArt #GraphicDesign #OneCoolTip #TechTip #Microsoft @Microsoft 

How to Survive the End of Windows 10

Are you still using Windows 10? 

If so, you might want to pay attention to this Cool Tip. 

Microsoft announced that Windows 10 will reach its end of life on October 14, 2025. 

What does this mean for you? 

fig. 1 - Microsoft Windows 10 End of Life
- October 14, 2025

Circle this date on your calendar!  

Why?

After this date, Microsoft will no longer provide security updates or support for the operating system.

The final version is 22H2, released on October 10, 2022.

And until then, Microsoft will not release any major updates or enhancements to Windows 10.

To check if your current Windows 10 PC can run Windows 11, download the PC Health Check app once it becomes available. 

Download PC Health Check

The app will provide an indication if and when your PC is eligible for the update.

If your PC can't be updated, you'll need to consider buying a new PC with Windows 11 pre-installed.

But wait... change is constant.

Windows 12 is expected to be released near the end of 2024.

So whatever you do, keep your system up-to-date, make back-ups regularly, and update your anti-virus protection!

And don't forget to create your personal Disaster Recovery Plan!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• Google Chrome Stops Support for Windows 7 and Windows 8/8.1
• Open Apps Fast with This Windows Cool Tip
• Try These Top 5 Windows 10 Keyboard Shortcuts

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

Source: Microsoft Learn

#Windows10 #Windows11 #Microsoft #EndOfLife #PCHealthCheck #news @Microsoft #technews #MicrosoftWindows #MicrosoftWindows10 #MicrosoftWindows11 #WindowsPCUpgrade 

How to Use ChatGPT iPhone App: Your Personal AI Assistant in Your Pocket!

Are you tired of searching the internet for answers to your questions? 

Do you wish you had a personal assistant to help you find the information you need? 

Here's a Cool Tip:  Check out the new official ChatGPT iPhone app! 

The official ChatGPT iPhone app is a powerful tool that can help you get answers to your questions quickly and easily. 

Whether you’re looking for information on a particular topic or just want to chat with an AI assistant, the ChatGPT iPhone app is the perfect solution

Here's how to use it.

• Download the official ChatGPT app from the iPhone App Store. 
• The app is compatible with iOS 16.1 or later.
•  Once downloaded, open the app and log in to your OpenAI account
• If you don;t have an account, you can sign up for one.
• After logging in, you can start using the app by typing your query in the send a message box and tapping the send icon.
• ChatGPT will output its answer to your query.
• To access the ChatGPT settings, tap the menu icon (three lines) for the sidebar menu.

fig.1 - ChatGPT iPhone app

Note:  You can also use the voice to text feature to speak your request.  Just click the sound icon, say your request and tap to stop recording.  Your request will be turned into text.  Click the send icon to send your request to ChatGPT.

fig. 2 - Voice to Text ChatGPT iPhone app

Android owners will need to wait a bit longer for an app.  ChatGPT says that an Android app is coming "soon".

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• The Wine Rookie Plays a Wine Guessing Game with ChatGPT
• How AI is Changing the Way We Work: An Example for Bing Chat AI, Excel and Data Analysis
• Beware!  AI May Take Your Job. Check this Cool Tip on How It Can Happen
• More AI Cool Tips

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

#ChatGPT #iPhoneApp #AIAssistant #OpenAI #PersonalAssistant #PocketAI #TechTip #OneCOolTip #Apple @apple #iphone 

How to Travel the World with Radio Garden

Have you ever wondered what people are listening to in different parts of the world? 

Do you want to discover new music, news, culture, or languages from across the globe? 

If so, check out this Cool Friday Funday Tip:  Radio Garden.

Radio Garden is an interactive map of live radio stations that lets you tune in to any place on Earth.

fig. 1 - Radio Garden 0 United States Map

Here's how to use Radio Garden:

• Go to Radio Garden: http://radio.garden/
• Use your mouse to move the interactive map around the world.
• Scroll in to view more local stations.
• Click any dot to hear that station.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

• Do Nothing for Two Minutes
• Dive Into The World of Feeding Koi
• What Was the Top Song on the Day You Were Born
• More Friday Funday

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#FridayFunday #RadioGarden #TechTip #OneCOolTip