How to Set Google Search Results Per Page

By default, when you search for something on Google, the site displays 10 results per page. If you would like to see more results, you can increase the results count from a Settings option on Google. (Note! As of this writing, this feature is only available for the desktop).

RAYMOND OGLESBY @RaymondOglesby2
November 16, 2021

By default, when you search for something on Google, the site displays 10 results per page. If you would like to see more results, you can increase the results count from a Settings option on Google. (Note! As of this writing, this feature is only available for the desktop). In this blog post, we will show you how easily this is done.

This is for desktop devices using Google Search

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

To view more search results without having to click the next page number for your Windows, Mac, Linux, or Chromebook computer, first, open a web browser on your computer and access the Google site.

At the bottom right-hand corner of the Google site, click Settings. Refer to the below image:

Search 1
Accessing Google Search Settings

Next, from the pop-up menu that opens, select Search settings. See the below image:

Search 2
Accessing Search settings option

Now, on the Search Settings page, from the left sidebar, select Search results. See the following image:

Search 3
Accessing Search results option

Next, on the right pane, you will see a Results per page slider. To increase the number of results per page, drag this slider to the right. Beneath the slider, you will see the number of search results you can enable on Google. Your options are 10, 20, 30, 40, 50, and 100. (Note! Your searches will be slower if you choose to display more results per page than the default). Refer to the below image:

Search 4
Setting the slider for the number of search results per page

Now, to save your changes, scroll down to the bottom of the page, and click Save. See the below image:

Search 5
Save your changes

Next, in the prompt, Your preferences have been saved, click OK. See the following image:

Search 6
Confirming your changes

You will now see your selected number of search results per page on Google Search on your desktop. If you ever want to modify this option, you can head to the same menu and choose a new number.

Here is a helpful insight on using Google Search for you to consider. As of this writing, Chrome 95 has a bug in its Reading List option. To research, this or any other problem, start with the highest level then drill-down levels. For example, you would enter the following text for the search:

Google Chrome 95 Reading List option Add current tab is dimmed

The highest level is Google, next is Chrome 95, and so on. You will get better search results by following this guideline.

Quote For the Day

When you’re an engineer, you want to analyze things a lot. But if you believe that the most important data points are people, then you have to make conclusions in relatively short order. Because you want to push the people who are doing great. And you want to either develop the people who are not or, in a worst case, they need to be somewhere else.

Tim Cook

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 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 Pin/UnPin a Facebook Post

What does it mean to pin a post on Facebook? A pinned post is a status update that you manually select to stay at the top of your page’s timeline, meaning it will not slip down as you continue to add other posts to your page.

RAYMOND OGLESBY @RaymondOglesby2
October 5, 2021

What does it mean to pin a post on Facebook? A pinned post is a status update that you manually select to stay at the top of your page’s timeline, meaning it will not slip down as you continue to add other posts to your page. Let’s explore how to do this.

This is for devices running Facebook

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

You can only have one post pinned to your profile at a time. If you try to pin a second post, that second post gets pinned and the first post gets unpinned.

Pin to Your Profile

First, launch a web browser on your computer and access the Facebook site. Next, log in to your account and in the top right-hand corner of the site, click your profile icon. Refer to below image:

FB 1
Accessing your Profile

Now, on your profile page that opens, find the post you want to pin. At the top right-hand corner of the post, click the three dots menu. See below image:

FB 2
Selecting the 3 dots menu

Next, from the three-dots menu, select Pin post. See following image:

FB 3
Selecting to Pin your post

And immediately, Facebook will pin the selected post to the top of your profile page. Scroll up your profile and your pinned post will appear there. Refer to below image:

FB 4
Your pinned post

To unpin a pinned post, from the top right-hand corner of the pinned post, select the three dots menu and click Unpin post in the menu. See below image:

FB 5
Selecting to Unpin your post

Facebook will remove the post from the top of your profile page. It will continue to appear at its original location in your profile, though. Now, refresh the page or exit Facebook.

Related

How to Pin/Unpin a Twitter Tweet

Pin to Your Page

In addition to your personal profile, you can pin a post to your Facebook page, too.

First, access your page and find a post to pin. (Note! I am doing this on my business page using my iPhone). Next, at the top right-hand corner of the post, click the three dots menu. See following image:

FB 6
Selecting the 3 dots menu

Now, from the three-dots menu, select Pin to Top. Refer to below image:

FB 7
Selecting to Pin your post

Next, Facebook will add your selected post to the top of the page.

To remove the post from the top of the page, from the top right-hand corner of the post, click the three dots menu. Next, from the menu that opens, select “Unpin from Top. See below image:

FB 8
Selecting to Unpin your post

Quote For the Day

You can’t just ask customers what they want and then try to give that to them. By the time you get it built, they’ll want something new.

Steve Jobs

That’s it. You now know how to pin/unpin a Facebook post. 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 Add the Developer Tab in Office Apps

Sooner or later, you will need the Developer Tab in Word, Excel, PowerPoint, or Outlook. Even if you know nothing about programming, there are buttons on the Developer tab that are necessary for some of the clever features in Office.

RAYMOND OGLESBY @RaymondOglesby2
September 28, 2021

Sooner or later, you will need the Developer Tab in Word, Excel, PowerPoint, or Outlook. Even if you know nothing about programming, there are buttons on the Developer tab that are necessary for some of the clever features in Office.

The Developer tab is not displayed by default, but you can add it to the ribbon in a few easy steps.

This is for devices running Microsoft Office

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

First, open an Office app, like Word, and any document. Now, right-click within any Tab in the Ribbon and select Customize the Ribbon. Refer to below image:

Ribbon 1
Select Customize the Ribbon option

Next, in the right-hand side, select All Tabs from the drop down menu and simply checkmark the Developer tab box. Now, select OK to enable the Developer tab. See below image:

Ribbon 2
Enable the Developer tab

Next, exit your Office app, restart the app and load your document. You will see the Developer tab in your ribbon. Just click the tab to view its options. See following image:

Ribbon 3
Your Developer tab

Quote For the Day

‘Fahrenheit 451’ postulates a lot of things I didn’t want to have happen.

Ray Bradbury

That was easy. 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 Check if Chrome 93 is Installed

Google Chrome 93 is officially here. There is plenty to be excited about. For example, with Chrome 93, progressive web apps (PWAs) feel a lot more like native desktop apps, as clicking on a link can open an associated web app. There’s also improved multi-screen support for web apps, making this an update web app users will love.

RAYMOND OGLESBY @RaymondOglesby2
JSeptember 21, 2021

Google Chrome 93 is officially here. There is plenty to be excited about. For example, with Chrome 93, progressive web apps (PWAs) feel a lot more like native desktop apps, as clicking on a link can open an associated web app. There’s also improved multi-screen support for web apps, making this an update web app users will love. Let’s explore how to install Chrome 93.

This is for Windows, Android, Mac, iPhone, and iPad

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

Some new features are related to recently closed tabs, a Material You theme for Android 12, a new Google Search UI on Android, the ability to sync Two-Factor OTP codes across devices (a true game-changer), the ability to use note-taking apps right from the browser, a new context menu on iPhone, and so much more.

Chrome 93 will now also show Google Drive documents on the New Tab page. The suggested documents will appear in a card underneath the Search Bar, allowing you to easily access recently edited Google Docs or Sheets.

First, you can check for an update by going to the three-dot menu hamburger icon on the top-right of Chrome. Next, click Help followed by About Google Chrome. Refer to below image:

Chrome 93 1
Selecting the About option

Now, the Chrome Settings window open. If Chrome is outdated, it will automatically download and install the latest version. See below image:

Chrome 93 2
Your Chrome version

Now, close Chrome and restart the app.

If you are on iPhone or Android, update the app as you would for any other application.

Quote For the Day

The most remarkable discovery in all of astronomy is that the stars are made of atoms of the same kind as those on the earth.

Richard P Feynman

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 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 Create a People Graph in Excel

If you take advantage of Excel’s charts for helpful visual displays of your data, check out the People Graph option to create a simple depiction of the number of people or items you have logged in your spreadsheet.

RAYMOND OGLESBY @RaymondOglesby2
September 9, 2021

If you take advantage of Excel’s charts for helpful visual displays of your data, check out the People Graph option to create a simple depiction of the number of people or items you have logged in your spreadsheet.

This is for devices running Excel. Screenshots are from Excel for Office 365 and Windows 10.

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

You can display things like the number of visitors to your website, downloads of your app, sign-ups for your event, calls to your support center, and much more.

Add People Graph Add-In

People Graph is an Add-In developed by Microsoft, and there’s already a button for it in your Excel ribbon. But before you can use it, you will have to trust the add-in to install it. First, open the Insert tab in Excel and look for the Add-ins group. Click the button for People Graph. Refer to below image:

Graph 1
Select the Add-In

Next, You will see a pop-up window with a link to See Details. This takes you to the Add-In on the Office Store, where you can read an overview, reviews, and other details. Click Trust this add-in to get started. See below image:

Graph 2
Trust the Add-In option

Now, once the add-in is installed in Excel, you can click the button on the Insert tab to use the feature.

Insert a People Graph

Whenever you hit the People Graph button in the ribbon, you will see a sample graph. First. click the Data icon that looks like a small grid. See following image:

Graph 3
Select the People Graph button

Optionally, you can enter your graph Title before selecting your data, or you can just head back to this spot to add the title later. Next, click Select your data, and then drag through the cells that you want to use. Currently, you must use two columns of data, but you can have multiple rows. Refer to below image:

Graph 4
Select your data

Now, click Create on the People Graph screen. See below image:

Graph 5
Create the People Graph

Customize Your People Graph

First, click the gear icon to open the Settings. You can then move through the three settings for type, theme, and shape. See following image;

Graph 6
Select the Settings gear icon

You can currently pick from three graph types. Each has a slightly different layout and appearance. Now, click Type, and then choose one on the right side. Refer to below image:

Graph 7
Select your Type of graph

Next, you can select a Theme that changes the background and colors of your graph. Click Theme, and choose one of the seven options. See below image:

Graph 8
Select your theme for the graph

Finally, you can use a different Shape. So if your data is better represented by a Shape other than people, you can choose the best fit. Now, click Shape and pick from the 16 options. See following image:

Graph 9
Select the Shape of your graph

Next, you can select and drag your People Graph wherever you want it on your spreadsheet. And if you edit the data on which the graph is based, Excel will update the graph automatically. Refer to below image:

Graph 10
Your final result

Other Options

On the top right of your People Graph, you will see an arrow (Windows) or an Info icon (Mac). When you click, you will see several actions .Choose Reload to refresh the graph, Delete to remove it, and Select to select the graph if you want to move it. You also have options to Get Support, Attach Debugger, and view the Security info. See below image:

Graph 11
Select Other Options

If you are looking for a simple way to visually display data, especially if it includes a number of people like customers, clients, or contacts, try out the People Graph in Microsoft Excel.

Quote For the Day

If you don’t like what you’re doing, then don’t do it

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.

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 Add Videos to PowerPoint Kiosk Mode

It is possible to add videos to a PowerPoint Kiosk or self-running presentation. You have been able to do this for years but it’s become a lot easier in recent versions of Office. Making the video work within a self-running presentation takes a little extra trickery. L

RAYMOND OGLESBY @RaymondOglesby2
September 7, 2021

It is possible to add videos to a PowerPoint Kiosk or self-running presentation. You have been able to do this for years but it’s become a lot easier in recent versions of Office. Making the video work within a self-running presentation takes a little extra trickery. Let’s explore how to do this.

This is for devices running PowerPoint

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

Here are the steps:

  • Go to the presentation and add a blank slide where you want the video to go.
  • Insert the video onto the slide from Insert | Video.
  • Make any changes you want to the video; trimming, effects, fades , and so on.
  • Ensure that Video Tools | Playback | Video Options | Start is set to Automatically. Refer to below image:
PP 1
Set the Playback to automatically
  • Using the slider below the video, note the running time of the video.
  • Switch to the Transitions tab. Under Timing | Advance Slide | After set the duration to the same (our video is 41 seconds) or a little more than the video playback time. See below image:
PP 2
Set the timing for the video

With those settings the video will automatically play when the slide appears and will advance to the next slide when the video ends. If the video slide gets ‘stuck’ set the Advance Slide duration to match the video playing time.

Quote For The Day

The saddest aspect of life right now is that science gathers knowledge faster than society gathers wisdom

Isaac Asimov

That was easy. 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: Events and Aftermath

How to Highlight Blank or Error Cells in Excel

Spotting things in a spreadsheet can be much quicker when you nightlight them. With conditional formatting in Microsoft Excel, you can make finding blank cells or formula errors easier.

RAYMOND OGLESBY @RaymondOglesby2
August 26, 2021

Spotting things in a spreadsheet can be much quicker when you highlight them. With conditional formatting in Microsoft Excel, you can make finding blank cells or formula errors easier. Let’s explore how this feature works.

This is for devices running Microsoft Excel

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

Highlight Blank Cells

When you have a spreadsheet full of data that you expect to fill every cell, you can easily overlook cells that are left empty.

First, open the sheet and select the cells where you want to apply the formatting. Next, go to the Home tab and click Conditional Formatting in the Styles group of the Ribbon. Now, choose New Rule. Refer to below image:

Excel 1
Select New Rule option

Next, in the New Formatting Rule window that appears, click Format only cells that contain under Select a Rule Type at the top. See below image:

Excel 2
Select a Rule Type option

Now, at the bottom, pick Blanks in the Format only cells with drop-down box. Next, click Format to the lower right of the preview to select how to format the blank cells. See following image:

Excel 3
Select Format Cells with blanks

Now, in the Format Cells window, use the tabs at the top for Font, Border, and Fill to choose your formatting. Click OK. For our example, we are using Fill to color our blank cells bright yellow. Refer to below image:

Excel 4
Select choose a Fill color

You will be back on the New Formatting Rule window, where you will see a preview of the formatting for blank cells. If you are happy with it, click OK to apply the conditional formatting. See below image:

Excel 5
Save your changes

You should then see any empty cells in the range that you selected highlighted with the formatting that you picked. See following image:

Excel 6
Your final result

Highlight Error Cells

Even though Microsoft Excel does a decent job of of pointing errors out to you, they might not be noticeable if you have a large sheet to scroll through. To make sure that you see the errors quickly, conditional formatting is the way to go.

You will actually follow the same process that you used in the previous section to highlight blanks, but with one difference.

First, switch to the Home tab, click Conditional Formatting, and then choose New Rule. Refer to below image:

Excel 7
Select New Rule option

Next, in the New Formatting Rule window, pick Format only cells that contain at the top. But this time, pick Errors in the Format only cells with drop-down box at the bottom. Now, click Format to choose the formatting. See below image:

Excel 8
Select Format for errors

For this example, adjust the Font options to make the cells with errors bold and red. Click OK. After you pick the formatting, click OK again to apply the rule. See following image:

Excel 9
Select formatting for errors

Now, those errors will be very visible! Refer to below image:

Excel 10
Your final result

Quote For the Day

The true delight is in the finding out rather than in the knowing

Isaac Asimov

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 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: Events and Aftermath
%d bloggers like this: