Archiving Verses Deleting Emails

When it comes to removing emails, there are two options that nearly every service has; Archive and Delete. It’s a little confusing why there are two choices that sound very similar. What’s the difference and which should you use?

RAYMOND OGLESBY @RaymondOglesby2
May 3, 2022

When it comes to removing emails, there are two options that nearly every service has; Archive and Delete. It’s a little confusing why there are two choices that sound very similar. What’s the difference and which should you use?

Both archiving and deleting emails will remove them from your Inbox, but that’s where the similarities end. Knowing the difference between the two can save you from some trouble. Let’s explore the difference

This is for devices running Microsoft Office 365 Outlook app. Screenshots are from Windows 10

Dilbert and IT
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Archive an Email

The Archive function in email services is essentially Delete Lite. The email is removed from your Inbox and instantly removed. It feels like you deleted the email, but it’s not gone forever.

If you think about physical mail, the Archive function is like shoving a piece of mail into a drawer. You will not see it anymore, but it’s still there if you need it.

Archived emails are usually put into a special Archive folder. First, open an Outlook email in your Inbox. Refer to the below image:

Email 1
Opening an Outlook email

Next, right-click on the email, and select Archive from the drop-down menu. The email will be moved to your Archive folder. Or, you can drag and drop email(s) to your Archive folder. If you do not have this folder, you will receive a message asking if you want to create the Archive folder or choose another folder. See the below image:

Email 2
Selecting to Archive an email

AutoArchive for Folders

If you want to clean up your folders but do not want to spend the time manually doing this, consider using the AutoArchive feature. Using AutoArchive, you can tuck away older emails and items you no longer need but do not necessarily want to delete.

You can decide when to archive your items, which ones to archive, and where they should be sent. You can set up AutoArchive for specific folders or completely remove folders from the archive process.

To get started:

Open Outlook, then click:

File > Options > Advanced > AutoArchive Settings

and select/change your options, then click OK when finished. See the following image:

Email 4
AutoArchive options

Delete an Email

Deleting an email is a permanent function. When you delete an email it’s usually moved to a Trash folder. That’s where it will sit for 30 days, after which it is removed for good (usually).

To use the physical mail example again, deleting is like putting mail in your trash can. You might have 30 days to retrieve it, but after you take it to the curb, it’s gone forever.

First, open an Outlook email in your Inbox. Next, right-click on the email, and select Delete from the drop-down menu. The email will be moved to your Trash folder. Or, you can drag ad drop email(s) to your Trash folder. Refer to the below image:

Email 3
Selecting to Delete an email

Archive and Delete an email is similar in Gmail. The difference lies in the location of these options. Once a Gmail is opened, they are located in the top toolbar.

Which One to Use

With these definitions in mind, you might be thinking there’s no reason to ever fully delete an email. Well, that might be true if you are willing to pay for storage. The days of unlimited free storage for email accounts are over.

All those archived emails are added to your storage. So unless you want to pay for more storage, you should delete some emails.

It’s a good practice to delete any email you know you will never need again and Archive the others. Keep in mind that the U.S. government can look at emails older than 180 days without a warrant.

Archive and Delete may sound familiar, but their functions are drastically different. By using them, you can maintain a clean Inbox.

Quote For the Day

Do something wonderful, people may imitate it.

Albert Schweitzer

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love to hear from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app, and version you are using. To help us out, you can send screenshots of your data related to your question.

Author’s E-book

You can access the e-book from a Kindle device, the Kindle App for the desktop or smartphone, which is a free app.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Really Shut Down Windows

Sometimes you need to shut down your Windows 10 or 11 PC, but thanks to something called Fast Startup, you might not be shutting it down all the way, with a fresh OS reload on the next power-up.

RAYMOND OGLESBY @RaymondOglesby2
April 19, 2022

Sometimes you need to shut down your Windows 10 or 11 PC, but thanks to something called Fast Startup, you might not be shutting it down all the way, with a fresh OS reload on the next power-up. Let’s explore how to really shut down your desktop completely.

This is for Windows 10 and 11. Screenshots are from Windows 10

Dilbert and Manager
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Fast Startup

Usually, you do not need to shut down your PC. Sleep Mode can place your PC into a low-power state that is quick to resume whenever you need to use your PC again.

But there are times when you might want to shut down your PC in a way that forces Windows 10 or 11 to reload completely when you boot it back up.

With a feature called Fast Startup, many PCs that support hibernation mode actually “shut down” to a state similar to hibernation, which saves the state of the operating system (in RAM) to a file called hiberfil.sys. This lets Windows load quickly when you power up your PC again.

So if Fast Startup is enabled on your PC and you select Shut Down in the Start menu, you are not getting a clean restart when you power it back up again.

Disable Fast Startup

It’s important to know that not all PCs support Fast Startup mode. So your PC might already be shutting down completely. (Restarting bypasses Fast Startup, as shown in the last section of this post). You will see another way to tell in the steps ahead.

To disable Fast Startup, first, open the Control Panel in Windows 10 or 11. For Windows 10, type “control panel” in the Cortana search box, then click the Control Panel app in the search results. For Windows 11, open the Start menu and type “control panel,” then click the Control Panel icon when it appears. Refer to the below image:

Windows Shutdown 1
Accessing the Control Panel in Windows 10

Next, when the Control Panel opens, click Hardware and Sound section. See the below image:

Windows Shutdown 2
Selecting the Hardware and Sound section

Now, under the Power Options section, click Change what the power buttons do link. See the following image:

Windows Shutdown 2
Selecting Change what the power buttons do link

Next, on the Define power buttons and turn on password protection page, first, click the Change settings that are currently unavailable link near the top of the page.

Now, look under the Shutdown Settings section near the bottom. If you see Turn on fast startup (recommended), remove the checkmark beside it. Refer to the below image:

Windows Shutdown 4
Turn off Fast Start

Note: If you do not see the Fast Startup option, it means your PC does not support Fast Startup and is already shutting down completely, so no changes are necessary.

Next, click Save Changes and exit the Control Panel.

The next time you shut down your Windows PC, it will shut down completely without any hibernation. And the next time you start it up, you will get a clean boot with a full reload of Windows.

Just Restart

It’s important to note that if you need a completely clean Windows boot, you can also achieve it by using the “Restart” feature built into Windows; no disabling Fast Startup is necessary. Restarting this way bypasses Fast Startup if you have it enabled. Microsoft implemented it this way because people often restart their computers to fix problems, and a full shutdown and restart might refresh the Windows system kernel or your computer’s hardware drivers if either is stuck in a bad state.

To restart your PC, first, click the Start menu, then select the Power icon (located on the left side in Windows 10 and on the right side in Windows 11). In the menu that pops up, select Restart. See the below image:

Windows Shutdown 5
Selecting Restart in Windows 10

Your PC will restart completely with a fresh reload of Windows, which will hopefully solve any temporary problems that you have been troubleshooting.

Quote For the Day

The person who dumps garbage into your mind will do you considerably more harm than the person who dumps garbage on your floor, because each load of mind garbage negatively impacts your possibilities and lowers your expectations.

Zig Ziglar

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love to hear from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app, and version you are using. To help us out, you can send screenshots of your data related to your question.

Author’s E-book

You can access the e-book from a Kindle device, the Kindle App for the desktop or smartphone, which is a free app.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Change the Mouse Pointer snd Text Indicator on Windows 10

Windows 10 lets you increase the mouse cursor’s size and change its color as well as changed the text indicator.. Want a black mouse cursor instead? You can choose that. Want a huge yellow inverted cursor that’s easier to see? You can choose that, too. Want the cursor indicator that you can see? In our example, we will create a Scheme of yellow inverted size three cursor and a blue text indicator with a thickness of three.

RAYMOND OGLESBY @RaymondOglesby2
April 5, 2022

Windows 10 lets you increase the mouse cursor’s size and change its color as well as changed the text indicator. Want a black mouse cursor instead? You can choose that. Want a huge yellow inverted cursor that’s easier to see? You can choose that, too. Want the cursor indicator that you can see? In our example, we will create a Scheme of yellow inverted size three cursor and a blue text indicator with a thickness of three. Let’s explore how this is done.

This is for devices running Windows 10

Dilbert and Problem
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Change the Mouse Settings

First, open Mouse Settings. In the Cortana search box at the lower left-hand corner, type in “mouse settings“. From the results, in the upper left-hand corner, click the Mouse settings result. The Mouse window will then open.

Next, in this window, you can adjust:

  • Cursor speed – move the slider from slow to fast
  • Mouse wheel scroll – select Multiple lines at a time
  • Lines to scroll – as you move the slider, hover on it to see the number to scroll
  • Scroll inactive windows – to enable, switch the toggle to ON

Refer to the below image:

Adjust the mouse options

When finished, click Adjust mouse & cursor size in the upper right-hand corner. Now, on the window that opens, you can adjust:

  • Pointer size – change the size from small to large
  • Pointer color – change the color by clicking the second and fourth tile. A color picker will appear for you to choose a color
  • Set touch feedback – change touch feedback toggle to ON

See the below image:

Cursor 3
Adjust the mouse pointer options

Change the Text Indicator

Next, in the pane on the left, select the Text cursor option. See the following image:

Cursor 4
Select the Text cursor option

Now, on the menu that opens, you can adjust:

  • Text cursor indicator – toggle the switch to ON
  • Text cursor size – from small to large
  • Text cursor indicator color – select a color from the tiles
  • Text cursor thickness – as you move the slider, hover on it to see the number for thickness

When finished, navigate back to the Mouse settings window. In the find a setting box in the upper left-hand corner, type in “mouse” and choose Mouse settings option.

Next, on the window that opens, select Additional mouse options in the upper right-hand corner. Refer to the below image:

Cursor 6
Select Additional mouse options

Now, the Mouse Properties window will open. Select the Pointers tab. Then label the Scheme by clicking the drop-down box and type in a name, click OK. When finished, click OK at the bottom. See the below image:

Cursor 7
Adjust the Mouse properties

In our example, we have created a Scheme of yellow inverted size three cursor and a blue text indicator with a thickness of three.

Quote For the Day

Yesterday ended last night. Today is a brand-new day.

Zig Ziglar

That’s it. If you ever want to tweak your mouse cursor again, just come back here. Please feel free to share this post! One way to share is via Twitter.

I hope you have found this post helpful. If so, click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love to hear from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app, and version you are using. To help us out, you can send screenshots of your data related to your question.

Author’s E-book

You can access the e-book from a Kindle device, the Kindle App for the desktop or smartphone, which is a free app.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Convert JPG/PNG Image to PDF on Desktop

Got a JPG/PNG image file you need to convert to PDF? You can use Windows 10 or 11’s built-in PDF Printer to make a PDF out of your JPG/PNG images.

Got a JPG/PNG image file you need to convert to PDF? You can use Windows 10 or 11’s built-in PDF Printer to make a PDF out of your JPG/PNG images. Let’s explore this nifty feature.

This is for devices running Windows 10 or 11

Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

How the Conversion Works

Both Windows 10 and 11 have a virtual PDF Printer. When you print something from an app with this printer, the printer turns that file into a PDF file. You can then save the resulting PDF file anywhere on your computer.

You will use this virtual printer to turn your JPG/PNG image into a PDF file. After saving it, you can email it, upload it to the cloud, or print a physical copy.

Convert the Image

The steps to convert JPG/PNG to PDF on both Windows 10 and 11 are pretty much the same.

First, open the folder where your JPG/PNG image is in a File Explorer window. If you are on Windows 10, right-click the image and select Print. If you are on Windows 11, right-click the image and choose

Show More Options > Print.

Refer to the below image:

Selecting the Print option

Next, a Print Pictures window will open. In this window, select the virtual PDF Printer by clicking the Printer drop-down menu and choosing Microsoft Print to PDF. Specify the paper size by clicking the Paper Size drop-down menu and selecting an option. To change the quality of the output PDF file, click the Quality drop-down menu and select an option. See the below image:

Setting the Print Pictures options

Now, on the Print Pictures window’s right sidebar, you have options to change how your JPG/PNG image appears in the PDF. Click an option in this sidebar to view its preview on the left. See the following image:

Selecting the Layout

Next, at the bottom of the window, specify how many pages you want in your PDF using the Copies of Each option. To make your photo fit the PDF, enable the Fit Picture to Frame option. Click Print to start making your PDF file. Refer to the below image:

PDF 4
Selecting other p[topms

Now, Windows will open a Save Print Output As window. Here, select the folder to save your PDF file. Click the File name field and type a name for your PDF. Then click Save. See the below image:

Selecting a location and file name

Next, to access your newly created PDF, open the folder where you saved it, and you will see the PDF version of your JPG/PNG image there, ending in “.pdf”. See the following image:

Locating your saved PDF file

Now, click or double-click the file to open. Refer to the below image for our final PDF file of Beautiful Lady:

Your PDF file

That’s all there is to converting JPG/PNG to PDF using the built-in option on Windows 10 and 11.

Quote For the Day

Listen with your eyes for feelings.

Stephen Covey

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love to hear from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app, and version you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Scroll Through Photos Fast on Windows 10

You may be used to tapping the arrow keys to quickly scroll through images in Windows’ Photos app, but an even faster method is using the mouse wheel.

RAYMOND OGLESBY @RaymondOglesby2
December 7, 2021

You may be used to tapping the arrow keys to quickly scroll through images in Windows’ Photos app, but an even faster method is using the mouse wheel. Let’s explore how to make the mouse wheel scroll instead of zoom.

This is for devices running Windows 10

Dilbert and Class
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

By default, when an image is open in Photos and you use your mouse wheel, your photo either zooms in or zooms out. By adjusting Photos’ settings, you can change this behavior so the mouse wheel opens the next or previous photo in your folder.

First, open the Photos app on your Windows 10 device by opening the Start menu, entering Photos in the Cortana search box, and clicking the app in the search results. Refer to the below image:

Photos 1
Selecting your Photos app

Next, in the top right-hand corner, click the three dots Menu. See the below image:

Photos 2
Selecting Photos Menu

Now, select Settings to open the Photos app’s Settings Menu. See the following image:

Photos 3
Selecting Photos Settings

Next, scroll down to the Viewing and Editing section. At the bottom of this section, in the Mouse Wheel subsection, enable the View next or previous item option. Refer to the below image:

Photos 4
Changing your mouse wheel option

And that’s it. In Photos, your mouse wheel will now navigate between the images in your folder.

Quote For the Day

Everything comes to him who hustles while he waits.

Thomas A Edison

You are finished. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app, and version you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Turn Off Entering a Password For Your Microsoft Account

Microsoft is leading the way for a passwordless future. You no longer are required passwords to login to your Microsoft account as you can now use the Microsoft Authenticator app, Windows Hello, a security key or a verification code sent via SMS or email.

RAYMOND OGLESBY @RaymondOglesby2
November 4, 2021

Microsoft is leading the way for a passwordless future. You no longer are required passwords to login to your Microsoft account as you can now use the Microsoft Authenticator app, Windows Hello, a security key or a verification code sent via SMS or email. Let’s explore how to setup this feature.

The company has been preparing for a passwordless future for quite some time and its reason behind is the fact that passwords can be easily manipulated.

Vasu Jakkal, Corporate VP of Microsoft’s Security, Compliance and Identity, said “Weak passwords are the entry point for the majority of attacks across enterprise and consumer accounts. There are a whopping 579 password attacks every second—that’s 18 billion every year,” Jakkal added.

This is for devices using Microsoft Account. Screenshots are from iPhone XR.

Dilbert and Tails
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

First, install the Microsoft Authenticator app and link it to your Microsoft account. There are several authenticator apps, ensure you install the correct one from Microsoft. Refer to below image:

Password 1
Download and install the Microsoft Authenticator app

Next, open your Microsoft account. See below image:

Password 2
Your Microsoft account

Now, scroll down to Advanced security section and toggle on Passwordless account. See following image:

Password 3
Setting Passwordless account option

Then follow the on-screen prompts and approve the notification from the Authenticator app.

Your Microsoft account is now passwordless. You can always go back to using a password for your account.

Quote For the Day

A lot of people in our industry haven’t had very diverse experiences. So they don’t have enough dots to connect, and they end up with very linear solutions without a broad perspective on the problem. The broader one’s understanding of the human experience, the better design we will have.

Steve Jobs

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Log Out of Facebook on All Devices

With so many devices and so many social media accounts, it can be hard to remember where you are logged in to which accounts. To protect yourself from potential hacks, it’s a good idea to log out of social media sites, like Facebook, once you are done with your session, especially if you are using someone else’s device.

RAYMOND OGLESBY @RaymondOglesby2
October 28, 2021

With so many devices and so many social media accounts, it can be hard to remember where you are logged in to which accounts. To protect yourself from potential hacks, it’s a good idea to log out of social media sites, like Facebook, once you are done with your session, especially if you are using someone else’s device.

But, if you forgot to log out, or suspect an unauthorized third-party login, you can still log out of all devices at once from your Facebook’s account settings. Let’s explore how this is done.

This is for devices running Facebook

Dilbert and Accomplishment
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Use Mobile App

If you use an iPhone, iPad, or Android phone, you can use the official Facebook app to sign out from Facebook on all your devices at once.

First, launch the Facebook app on your smartphone.

In the Facebook app, tap the three horizontal lines menu. On an iPhone or iPad, this menu is at the bottom of the screen. On an Android phone, you will find this menu at the top-right corner of the display. Refer to below image:

FB 1
Accessing the Menu

Next, scroll down the Menu screen that opens, and tap Settings & Privacy. See below image:

FB 2
Accessing Settings & Privacy option

Now, select Settings. See following image:

FB 3
Accessing Settings option

Next, scroll down to the Account section. Here, tap Password and Security. Refer to below image:

FB 4
Accessing Password and Security option

Now, on the Where you’re logged In header, tap See All. (Note! My display text automatically changes size and the See All may be somewhat hidden depending on font size. See below image:

FB 5
Accessing See All option

Facebook will display the list of devices where you use your account. At the bottom of this screen, tap Log Out of All Sessions. See following image:

FB 6
Accessing Log Out Of All Sessions option

Next, select Log Out. Refer to below image:

FB 7
Confirm your action by tapping Log Out

And Facebook will log you out from all your logged-in devices!

To use your Facebook account on those devices again, you will have to enter your Facebook username and password.

If you just want to log out of one session, tap the 3-dot icon to the right of a session, then tap Log Out and the session will be removed. See below image:

FB 16
Log Out of one session

Use Facebook Site

If you are on a Windows, Mac, Linux, or Chromebook computer, use the Facebook site to sign yourself out from all your Facebook logged-in devices.

First, launch a web browser on your computer and open the Facebook site.

Next, at the top-right corner, click the down-arrow icon. See following image:

FB 8
Accessing the Menu

Now, select Settings & Privacy. Refer to below image:

FB 9
Accessing Settings & Privacy option

Next, choose Settings. See below image:

FB 10
Accessing Settings option

Facebook will take you to your account’s settings page. Here, in the sidebar to the left, click Security and Login. See following image:

FB 11
Accessing Security and Login option

Now, from the Where You’re Logged In section, click the See More option. Refer to below image:

FB 12
Accessing See More option

Next, you will see a list of devices where you use your Facebook account. To sign out of all these devices, click Log Out Of All Sessions at the bottom-right corner of the Where You’re Logged In section. See below image:

FB 13
Accessing Log Out Of All Sessions

Now, a Log Out of All Sessions prompt will appear. Next, click Log Out in the prompt to confirm your choice. See following image:

FB 14
Confirm your action by tapping Log Out

And Facebook will log you out from all your logged-in devices!

To use your Facebook account on those devices again, you will have to enter your Facebook username and password.

If you just want to log out of one session, click the 3-dot icon to the right of the session, then click Log Out and the session will be removed. Refer to below image:

FB 15
Log Out of one session

Quote For the Day

The thing that doesn’t fit is the thing that’s the most interesting: the part that doesn’t go according to what you expected.

Richard P Feynman

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Use Paste Special for Simple Calculations in Microsoft Excel

Do you find yourself doing a lot of copy and paste of data in your spreadsheets? Did you know that you can use a special Excel’s paste feature to perform simple calculations? You can add, subtract, multiply, or divide in a few clicks with the paste special in Excel.

RAYMOND OGLESBY @RaymondOglesby2
October 26, 2021

Do you find yourself doing a lot of copy and paste of data in your spreadsheets? Did you know that you can use a special Excel’s paste feature to perform simple calculations? You can add, subtract, multiply, or divide in a few clicks with the paste special in Excel. Let’s see how this is done.

This is for devices using Microsoft Excel. We are using Excel for Office 365.

Dilbert and Like
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Maybe you have prices that you want to increase or costs that you want to decrease by dollar amounts. Or, perhaps you have inventory that you want to increase or decrease by unit amounts. You can perform these types of calculations quickly on a large number of cells with Excel’s paste special operations.

Setup Paste Special

For each of your simple calculations, you will open the Paste Special dialog box. Next, you will start copying the data and then selecting the cell(s) that you are pasting to.

First, open Microsoft Excel. To copy, you can press Ctrl+C or right-click and select Copy. Refer to below image:

Paste Special 1
Selecting Copy option

Now, do one of the following to access Paste Special.

  • Click the Paste drop-down arrow in the ribbon on the Home tab, then select Paste Special.
  • Right-click cells that you are pasting to and select Paste Special in the shortcut menu.

See below image:

Paste Special 2
Selecting Paste Special option

Use Simple Calculations With Paste Special

For basic numbers, decimals, and currency, you can choose from All, Values, or Values and Number Formats in the Paste section of the window. Use the best option for your data.

Next. you will use the section labeled Operation to add, subtract, multiply, or divide. See following image:

Paste Special 3
The Paste Special dialog box

Let’s look at a simple example of one operation to see how it all works.

Add With Paste Special

For this example, we want to add $50 to each of the amounts for our ski jacket prices to accommodate an increase.

We enter $50 into a cell outside of our data set and copy it. You might already have the data in your sheet or workbook that you need to copy. Refer to below image:

Paste Special 4
Selecting the amount for the increase

Now, we select the cells that we want to add $50 to and access Paste Special as described. Next, we choose Add in the Operation section and click OK. See below image:

Paste Special 5
Selecting to Add

And that’s it. All of the cells in your selection have increased by $50. See following image:

Paste Special 6
Your final result; all Ski Jackets are increased by $50

Subtract, multiply, or divide an amount works the same way. For multiply or divide, you would use units instead of currency.

Be sure to switch the operation back to None when you are finished.

The next time you need to add, subtract, multiply, or divide a large group of cells in Excel by the same amount, remember this trick using Paste Special.

Quote For the Day

I’m sorry, if you were right, I’d agree with you.

Robin Williams

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Set Chrome As Your Default Browser in Windows and iPhone/iPad

Features like Google account’s password and bookmark sync, extension support, cross-device migration, etc., make Chrome the number one choice over competitors. Chrome is the most installed web browser used today.

RAYMOND OGLESBY @RaymondOglesby2
October 20, 2021

Features like Google account’s password and bookmark sync, extension support, cross-device migration, etc., make Chrome the number one choice over competitors. Chrome is the most installed web browser used today. Let’s explore how to set Chrome as your default browser.

This is for Windows 10 and iPhone/iPad running Chrome

Dilbert and CEO
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

Before we go any further, you need to have the Google Chrome browser installed on your computer or iPhone/iPad. You can download the Chrome app from the app or play store for your iPhone/iPad or from Google’s website if you are using a desktop or laptop.

Set Chrome as Default Browser on Windows 10

First, open System settings by pressing Windows key+I, and then click on Apps. Refer to below image:

Chrome 1
Selecting Apps from Settings

Next, from the pane on the left side, click Default Apps. See below image:

Chrome 2
Selecting Default Apps

Now, locate the Web Browser section, click on your current default browser, and then scroll through the list and select Google Chrome. See following image where Google Chrome is already my default browser:

Chrome 3
Setting Chrome as default web browser

Next, close Settings. Chrome is now your default web browser.

Set Chrome as Default Browser on iPhone/iPad

If you are running iOS 14 and iPadOS 14 or higher, Apple made it possible to change the default web browser on iPhone/iPad.

First, locate your Settings app on your iPhone/iPad and tap it. Use Apple’s built-in Spotlight Search (your first screen) to quickly find the app if you can not locate it on your Home screen. Refer to below image:

Chrome 4
Accessing Settings

Next, scroll down and select the Chrome app. See below image:

Chrome 5
Selecting Chrome

Now, select the Default Browser App from the menu. If the setting has not been changed before, it will list Safari as the default. See following image:

Chrome 6
Selecting Default Browser app

Next, choose Chrome from the list of installed web browser apps. Refer to below image:

Chrome 7
Setting Chrome as default web browser

Now, close Settings. The next time you click on a link in any app installed on your iPhone/iPad, it will automatically open Chrome.

Quote For the Day

I was born not knowing and have had only a little time to change that here and there.

Richard Feynman

And that’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Checkout TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

How to Open HEIC Files on Windows

Apple’s iPhone and iPad takes photos in the HEIF image format by default. These photos have the HEIC file extension. Windows 10 can view HEIC files in just a few clicks; or you can convert them to standard JPEGs and view them anywhere.

RAYMOND OGLESBY @RaymondOglesby2
October 19, 2021

Apple’s iPhone and iPad takes photos in the HEIF image format by default. These photos have the HEIC file extension. Windows 10 can view HEIC files in just a few clicks; or you can convert them to standard JPEGs and view them anywhere. Let’s explore how this is done.

This is for devices running Windows 10, iPhone, and iPad

Dilbert and Directors
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

What is HEIC

HEIC is the name that Apple gave to its container for the HEIF (High Efficiency Image File) image format and is based on the HEVC (High Efficiency Video Compression) video format.

What it means for you are high-quality images that take up less storage space thanks to a more modern compression method.  

You can disable HEIC on the iPhone, but since its introduction in iOS 11, it has become Apple’s default photo storage format.

How to View HEIC Files

On modern versions of Windows 10, you can install support for HEIC image files.

First, locate an HEIC file in File Explorer on your computer and double-click it. If you are asked which application you want to open it in, select Photos.

Note! If the HEIC file does not open in the Photos app, right-click the HEIC file and select

Open With > Photos

Refer to below image:

HEIC 1
Selecting how to open HEIC photos

The Photos app will tell you that the HEIF Image Extension is required to display this file. Click the Download and install it now link to get it from the Microsoft Store. It’s a free download. If you do not see this requirement screen, do a Google search and install the extension. See below image:

HEIC 2
Google search for HEIF extension

If Windows asks Did you mean to switch apps?, select Yes.

This will open the HEIF Image Extensions page in the Microsoft Store app. Click the Install or Get button to download support for HEIC image files (which use the HEIF format.) See following image:

HEIC 3
Get or Install the HEIF extension

On the next screen, if the extension is already installed, you are set. If not, the Launch button will display Install instead. Just click to install the extension. Refer to below image:

HEIC 4
Status of the extension

Now, when you open an HEIC image in the Photos app, you will be able to view it like you would any other image file, like a JPEG, PNG, GIF, or BMP. See below image:

HEIC 5
HEIC photo

Windows 10’s File Explorer will automatically generate and display thumbnails for your HEIC image files, too. See following image:

HEIC 6
Thumbnails of HEIC photos in File Explorer

Convert HEIC to JPEG

To quickly and easily convert HEIC files to standard JPEG images on Windows, we recommend you download and install CopyTrans HEIC for Windows.

This tool installs full support for HEIC images in Windows, so it’s particularly useful on Windows 7 and older versions of Windows 10 that do not have integrated support in the Photos app. It adds support for HEIC images to the classic Windows Photo Viewer.

CopyTrans HEIC also allows you to right-click an HEIC file in File Explorer and select Convert to JPEG to easily convert it to a JPEG file. Select the option and you will get a JPEG version of the image automatically placed in the same folder as the original HEIC file.

JPEG files are more widely supported, so this will help you use the HEIC file in applications that support JPEG images but not HEIC files. Refer to below image:

HEIC 7
Selecting to convert HEIC to JPEG

Change the Default

If you find dealing with HEIC files inconvenient, you can also configure your iPhone to always take photos in JPEG format.

Go to

Settings > Camera > Formats > (and checkmark) Most Compatible

instead of High Efficiency. See below image:

HEIC 8
changing the default on iPhone

However, HEIC offers higher image quality in smaller file sizes. It’s a more modern image format, and we recommend sticking with it if the applications you use support it.

Quote For the Day

When you’re older you want to learn from other people.

Ray Bradbury

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Checkout TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath
%d bloggers like this: