Boost Your Productivity with Microsoft Excel's Paste as Picture

Have you ever wondered how to make your Excel reports more visually appealing? 

Or how to keep your data updated across multiple sheets without the hassle of manual updates?

Here's a Back-to-Work-Monday Cool Tip.  Use Microsoft Excel's Paste as Picture.

Microsoft Excel, a powerful tool in the Microsoft Office suite, offers two unique features: Paste as Picture and Paste as Linked Picture. 

While they may sound similar, they serve different purposes and can be used to achieve different outcomes.

Here's how to do it.

Paste as Picture

This feature allows you to take a snapshot of your selected cells and paste it as an image. 

• Select the cells you want to copy.

fig. 1 - Select Table to Copy

• Go to the Home tab, click on the Copy dropdown, and select Copy as Picture.
• In the dialog box, choose “As shown on screen” and “Picture”, then click OK.

fig. 2 - Microsoft Excel Copy as Picture

• Go to the location where you want to paste the picture and press Ctrl+V.

It’s a great way to preserve the look of your data, especially when sharing it with others.

The pasted picture won’t change even if the original data is modified.

Paste as Linked Picture

This feature creates a live snapshot of a range of cells. 

• Select the cells you want to copy.
• Copy the cells (Ctrl+C).
• Go to the Home tab, click on the Paste dropdown, and select Linked Picture.

fig. 3 - Microsoft Excel - Paste as Linked Picture

The linked picture updates automatically when the original data changes.

It’s useful for creating dynamic dashboards and reports.

Here’s an example to illustrate the difference. 

• Let’s say you have a cell A1 with the value 10. 
• If you use Paste as Picture, you’ll get a picture of the cell displaying 10. 
• If you change the value in A1 to 20, the picture remains the same. 
• But if you use Paste as Linked Picture, the picture will update to display 20.

Be sure to check out this video that explains Paste as Picture and Paste as Linked Picture.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• Unleash the Power of Excel's Text-to-Columns Feature
• How to Transpose Data in Microsoft Excel
• How to Set Tab Colors in Microsoft Excel

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Microsoft @Microsoft #Excel @Excel #ExcelTips, #DataVisualization, #ProductivityHacks, #MicrosoftExcel #TechTips #YouTube @YouTube @OneCoolTip @OneCoolTip 

How to Use Layers in Microsoft Paint

Have you ever wished for a simple tool that could help you create complex designs? 

Have you ever wanted to experiment with layers without having to navigate the intricacies of professional software like Photoshop? 

Here's a Cool Tip.  Check out the new layers feature in  Microsoft Paint for Windows 11.

Microsoft has recently introduced a layers feature in its Paint application for Windows 11.

This feature, typically found in more complex software like Photoshop and Gimp, allows users to stack multiple images, text, and graphics on top of each other, which can then be manipulated individually.

Here's how to do it.

• Open Paint on Windows 11.
• Click the Layers button in the command bar.

fig. 1 - Microsoft Paint Layers

• Click the Plus (+) button (Ctrl + Shift + N) to create a new layer.
• Insert an image or create a shape with the tools available in Paint.
• Drag the layers to change their order and bring a layer forward or backward.
• Right-click the layer and choose the “Delete layer” option to remove it from the file.
• Right-click the layer from the right pane and choose the “Duplicate layer” to create another instance of the same element.
• Right-click the layer and select the “Hide layer” to work on another layer.
• Right-click the layer and choose the “Merge down” option to combine the layer with the layer immediately below it.

fig. 2 - Microsoft Windows 11 Paint Options

• Each layer can have its own paint object(s).
• For example, in this example, each layer has its own object: background, Person and Text.

fig. 3 - Microsoft Paint - Each Layer Has Its Own Object

• Click the Save button.

fig. 4 - Microsoft Paint with Layers Example

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• How to Enable Dark Mode in Microsoft Paint
• How to Master Snap Layouts in Windows 11
• How to Adjust Windows 11 Sound Volume with This Cool Tip

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Microsoft @Microsoft #Windows @Microsoft #technology #tech #innovation #technews #gadgets #Windows11 #MicrosoftPaint #layers #digitalart #TechTips #OneCoolTip @OneCoolTip 

New iOS 17 Feature Makes iMessage Apps More Customizable Than Ever

Do you find yourself constantly scrolling through your iMessage apps to find the one you're looking for? 

If so, you're not alone. 

Here's a Cool Tip.   Customize the order of your iMessage apps.

With iOS 17, Apple has introduced a new feature that makes it easier than ever to customize your iMessage app drawer.

You can rearrange your iMessage apps to put your most-used apps at the top of the list. 

You can even add more apps to the top row, so you can have all of your favorite apps within easy reach.

Here's how to do it.

1. Open the iMessage app and start any conversation.
2. Tap the "+" button next to the text input field.
3. Swipe up to see all of your iMessage apps.
4. Tap and hold on the app you want to move, and then drag it to the desired location.
5. Release your finger to drop the app in its new location.

fig. 1 - Rearrange iMessage Apps

The main benefit of rearranging your iMessage apps is that it makes it easier to find the apps you use the most. 

This can save you time and frustration, especially if you have a lot of iMessage apps installed.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• How to Move the Address Bar in Chrome for iPhone
• How to Use Apple's New Adaptive Audio and Conversation Awareness for AirPods Pro
• How to Use the New iPhone Camera Level in iOS 17 to Take Straighter Photos
• MORE iOS 17 Cool Tips

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Apple @Apple #iPhone #iOS #iOS17 #iMessage #iMessageApps #TechnologyTips #ProductivityTips #TechTips #OneCoolTip @OneCoolTip 

Visit the British Museum from the Comfort of Your Own Home

Have you ever dreamed of visiting the British Museum, one of the world's largest and most comprehensive museums? 

But maybe you don't have the time or money to travel to London. 

Or perhaps you're simply not comfortable visiting a crowded museum?

Here's a Friday Funday Cool Tip.  Visit the British Museum with a virtual tour!

Here's how to do it.

1. Go to the British Museum Virtual Tour: https://g.co/arts/MsDFrrfLGngeXu3f7
2. Use the mouse or arrows to move around the gallery
3. Or select one of the items from the bottom row of the screen
4. Click on objects to learn more about them

fig. 1 - Bust of Ramesses - British Museum

The British Museum virtual tour is a great way to explore the museum's vast collection of objects from around the world.

Here are just a few of the items you can see:

• The Rosetta Stone in the Egyptian Sculpture Gallery
• The Parthenon Sculptures in the Greek and Roman Galleries
• The Assyrian Lion Hunt Reliefs in the Assyrian Northwest Palace Gallery
• The Lewis Chessmen in the Room of Enlightenment Gallery
• The Mildenhall Treasure in the Early Medieval Gallery
• The Sutton Hoo Ship Burial in the Early Medieval Gallery
• The Lindow Man in the Britain in the Roman World Gallery
• The Staffordshire Hoard in the Anglo-Saxon and Viking Gallery
• The Hoa Hakananai'a in the Oceania Gallery
• The Benin Bronzes in the Africa Gallery
• The Chinese Jade in the China Gallery
• The Japanese Prints in the Japan Gallery
• You can also explore the museum's extensive Prints and Drawings collection, which includes works by Old Masters such as Dürer and Michelangelo, as well as new and exciting contemporary pieces.

In addition to the virtual galleries, the British Museum also offers a variety of virtual visits and events. 

For example, you can take a virtual tour of the museum's Egyptian Sculpture Gallery, or learn about the history of Greek temples in a live interactive workshop.

You can learn more about the world famous British Museum on their full website: https://www.britishmuseum.org/

Enjoy!

 

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• G'day Mate! Here's How to Watch Koalas
• Waddle on Over to the Saint Louis Zoo Penguin Cam
• Get Your Daily Dose of Cuteness: Visit the Kitty Cam Today!

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#BritishMuseum #VirtualTour #MuseumFromHome #Culture #History #Art #Travel #FridayFunday #TechTips #OneCoolTip @OneCoolTip

How to Move the Address Bar in Chrome for iPhone

Do you have difficulty reaching the address bar at the top of the screen when using Chrome on your iPhone? 

You're not alone. 

Here's a Cool Tip.  Move the address bar to the bottom of the screen, where it would be easier to reach with one thumb.

Google has finally released a new Chrome feature for iOS that allows you to move the address bar to the bottom of the screen, or back to the top if you prefer.

Sorry Android users.

The main benefit of moving the address bar to the bottom of the screen is that it makes it easier to reach with one thumb. 

This is especially useful for people with larger iPhones, or for people with limited mobility in their hands.

Here's how to do it.

1. Open Chrome on your iPhone.
2. Long-press on the address bar.
3. Tap "Move address bar to bottom."
4. To move the address bar back to the top of the screen, follow the same steps, but tap "Move address bar to top" instead.

fig. 1 - Move Chrome Address Bar on iPhone

You can configure the new Chrome feature to move the address bar to the bottom of the screen in the Chrome settings app. 

1. Open the Chrome settings app.
2. Tap "Address bar."
3. Under "Position," tap "Bottom."
4. You can also move the address bar to the top of the screen from this menu.

fig. 2 - Chrome Address Bar Setting iPhone

The new Chrome feature to move the address bar to the bottom of the screen is a welcome addition for iOS users. 

It makes Chrome easier to use for people with larger iPhones, or for people with limited mobility in their hands. 

That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• Hey Chrome, Where's My Download?
• How to use the New Copy Video Frame Feature
• Unleash the Power of Google Chrome's Task Manager

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Google @Google #Chrome #iOS #iPhone #Apple @Apple #AddressBar #Bottom #Top #NewFeature #HowTo #TechTips #OneCoolTip @OneCoolTip

How to Rename Files on Windows and Macs

Have you ever found yourself lost in a sea of ambiguously named files on your computer? 

Ever wished there was a quick and easy way to rename them without going through a series of clicks? 

Here's a Cool Tip for Windows.  Use the F2 key.

Here's how to do it.

On Windows:

1. Navigate to the file you want to rename.
2. Click on the file to select it.
3. Press the F2 key.
4. Type the new name for your file.
5. Press Enter to save the new name.

Renaming files using these methods is quick and efficient, saving you valuable time. 

fig. 1 - Rename Windows with File F2

On Mac:

1. Navigate to the file you want to rename.
2. Click on the file to select it.
3. Press the Return key.
4. Type the new name for your file.
5. Press Enter to save the new name.

That's it.

Enjoy.

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• How to Master Snap Layouts in Windows 11
• How to Use the New 'End Task' Feature in Windows 11
• How to Use the New Windows 11 Copilot
• MORE Windows 11 Cool Tips

#Microsoft @Microsoft #Apple @Apple #Mac #Macintosh #TechTips, #FileManagement, #WindowsGuide, #MacGuide #OneCoolTip @OneCoolTip 

How to Boost Your Gmail Productivity with the New Message Icons

Do you find it difficult to navigate Gmail?

Did you notice the cool recent change?

Here's a Cool Tip.  Check out the new icons when reading an email.

Google's Gmail has recently added icons to the menu when you are reading an email.

The new Gmail icons allow you to quickly perform common tasks, such as printing, downloading, and moving messages.

Here's how to see them.

1. Go to Gmail, www.gmail.com
2. Double-click to open and read an email in your Inbox.
3. Click on the three dots in the top right corner of the Gmail message window. This will open a menu with all of the available icons.

fig. 1 - New Gmail Message Icons

The new Gmail icons are a great way to improve your productivity and get the most out of your Gmail account.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• Hot to Use the New Inclusive Emoji Picker in Gmail
• How to Add Gmail Emails to Your Task List
• How to Clean Up Your Gmail Storage
• MORE Gmail Cool Tips

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Google @Google #Gmail @Gmail #GmailTips #NewGmailIcons #GmailProductivity #GmailFeatures #GmailUpdates #TechTips #OneoolTip @OneCoolTip 

How to Quickly Create a Table in Microsoft Word

Have you ever wondered how to create a table quickly in Microsoft Word ?

Maybe there's a quick keyboard shortcut?

How about an "old school" trick?

Here's a Cool Tip.  Use simple ASCII characters.

Here's how to do it.

1. Open Microsoft Word. 
2. Type a plus sign (+) followed by a series of minus signs (-) and end with another plus sign (+). 
3. For example, to create a 3 cell table, type: +-----+-----+-----+ and then Enter.

fig. 1 Create a Table in Microsoft Word Using + and -s

    4. Just follow the pattern to create a table with more columns.

    5. Click into the last cell and press Tab key to create a new row.

Creating tables with ASCII characters is quick and easy. 

It’s also a fun way to impress your colleagues with your Word prowess!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• How to Quickly Create Different Types of Lines in Microsoft Word
• Unleash the Power of Online Videos in Microsoft Word
• Windows Super Secret Keyboard Shortcuts to Open Microsoft Applications
• More Microsoft Word Cool Tips

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

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

How to Use Google’s New ‘About This Image’ Feature

Have you ever come across an image online that looked too good to be true? 

Or maybe you saw a photo that was used in a misleading or false context? 

How can you tell if an image is reliable or not?

Here's a Cool Tip.  Use Google's New About This Image feature.

Google  recently launched a new feature called About This Image that can help you find more information about the images you see on the web. 

This feature can help you check the credibility, context, and origin of an image, as well as whether it was generated or manipulated by artificial intelligence.

Here's how to do it.

From the three-dot menu in Google Search: 

When you come across an image on Google Images or Google Search page, tap the three-dot menu on the top right corner and select About This Image. 

Google will then tell you the background of the image so that you can check its credibility and context1.

fig. 1 - Google About This Image

The About This Image feature provides you with four types of information about an image:

1. When did Google first index the image and similar ones: This can help you determine how old the image is and whether it was published before or after a certain event.
2. Where it may have first appeared: This can help you find the original source of the image and whether it is credible or not.
3. Where else it’s been seen online: This can help you see how the image has been used on other websites, such as news, social media, and fact-checking sites. You can also compare how different sources present the same image and whether they are consistent or contradictory.
4. Image metadata: This is information that image creators and publishers have added to an image, such as the title, description, author, date, location, etc. It also includes fields that may indicate whether AI has generated or enhanced the image. All Google AI-generated images have this markup in the original file.

fig. 2 - Google About This Image Results

The ‘About This Image’ feature has several benefits for users:

• It can help you spot fake images and misinformation by providing you with more context and sources about an image.
• It can help you verify the authenticity and accuracy of an image by showing you when and where it was first published and how it has been used online.
• It can help you find more information and related content about an image by showing you other websites that have displayed it.
• It can help you give credit to the original creator or publisher of an image by showing you their name and website.

About This Image can help you find more information about the images you see on the web.

Be sure to check it out.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• How to Use the New Google URL Autocorrect Feature
• Imagine It, Create It: Google's SGE Image Creator Opens Up a New Realm of Artistic Expression
• How to Play Google Tic-Tac-Toe

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Google @Google #Images #GoogleImages #Search #AboutThisImage #TechTips #OneCoolTIp @OneCoolTip

How to Share Your Location and ETA with Google Maps

Ever felt the frustration of trying to describe your location when you're lost? 

Or the anxiety of making someone wait because you're stuck in traffic and they have no clue where you are? 

What if you could share your exact location and Estimated Time of Arrival (ETA) with just a tap on your smartphone? 

Here's a Cool Tip.  Use Google Maps.

Here's how to do it.

Sharing Your Location:

• Open Google Maps 
• Make sure you're signed in to your Google account.
• Turn on your location services if it’s not already enabled.
• Located at the top right corner, tap on your profile picture.
• Choose Location Sharing.
• Select New Share. 
• Choose how long you want to share your location and whom to share it with.
• Tap Share to send your location.

fig. 1 - Google Maps Share Location

Sharing Your ETA:

• Enter your destination and start the navigation.
• Tap on '↑': Locate the upwards arrow at the bottom of the screen or the Estimated Time.
• Choose Share trip progress.
• Select Contacts.
• Tap on the Send button.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

READ MORE

• How to Play the Google Maps Snake Game
• Hot to Use Google Maps to Find Gas Stations and Gas Prices
• Discover the Power of What3Words

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life

#Google #Maps @Google #GoogleMaps #LocationSharing #TimeManagement #TechTips #Navigation #TechTips #OneCoolTip @OneCoolTip