iOS 15 introduced a redesigned Safari interface that puts the address bar at the bottom of the screen. Refer to below image:
New Safari
If you prefer to keep it at the top of the screen, like most web browsers, it can be easily swapped. Let’s explore how this is done.
This is for the iPhone running iOS 15 or above
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS
There are a few advantages to having the address bar at the bottom. First, it’s easier to reach with one hand on a large screen. Second, it puts all the browser controls in one place. If you are still not convinced to give it a try, let’s switch it back. Personally, I like the old Safari.
First, open the Settings app from the home screen. See below image:
Accessing Settings
Now, scroll way down and tap Safari. See following image:
Accessing Safari
Next, go to the Tabs section and switch it to Single Tab. Refer to below image:
Toggle to Single Tab
Now, the address bar is back at the top of the screen and the other browser controls are still at the bottom. See below image:
The old Safari
Regardless of which interface you prefer, the same amount of content is visible, so it’s just a matter of what you like best.
Quote For the Day
Creativity is just connecting things. When you ask creative people how they did something, they feel a little guilty because they didn’t really do it, they just saw something. It seemed obvious to them after a while. That’s because they were able to connect experiences they’ve had and synthesize new things.
Steve Jobs
That’s it for getting back the old Safari interface. 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.
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
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.
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
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:
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:
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:
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.
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
The stock Photos app for iOS and iPadOS comes with a built-in editing tool that can let you automatically resize a pic. Besides, you can also get rid of the unwanted parts manually to ensure there is no blemish. You do not need any photo editing apps to rotate, crop, or straighten your photos.
There could be all sorts of reasons why you would like to crop photos on your iPhone and iPad. Maybe you are not pleased with the actual size of the image or want to make it perfectly fit a frame.
The stock Photos app for iOS and iPadOS comes with a built-in editing tool that can let you automatically resize a photo. Besides, you can also get rid of the unwanted parts manually to ensure there is no blemish. You do not need any photo editing apps to rotate, crop, or straighten your photos.
However, the best part is that you can go back to the original size just in case the end result does not turn out as expected. Let’s see how this is done.
This is for the iPhone and iPad
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS
Crop Your Photo
First, open the Photos app on your iPhone or iPad and navigate to the photo that you want to crop. In the top right-hand corner, tap the Edit button. Refer to below image:
Selecting to Edit a photo
Now, in the photo editing view, you will see the bottom toolbar. Tap the Crop button which looks like a box with arrows around it. See below image:
Selecting the Crop button
Next, you will see the image surrounded by a white frame. Swipe in from any edge to crop the image. You can do this from all corners. Just, lift your finger to see the cropped image. See following image:
Cropping a photo
Now, you can also crop the image using a specific aspect ratio if you need the photo to be a perfect square. Tap the Aspect Ratio button in the top toolbar which looks like overlapping boxes. Refer to below image:
Selecting the Aspect Ratio button to crop a photo
Next, you can choose the Aspect Ratio (such as “4:3” or “16:9”) or switch between the Portrait and Landscape formats.
Even after selecting the Aspect Ratio, you can continue to crop the image. The difference is that now, the Aspect Ratio will be locked. If you do not want to use the Aspect Ratio feature, choose the Original option. See below image:
Selecting an Aspect Ratio
Now, if you are satisfied with the crop dimensions, tap the Done button in the bottom toolbar on iPhone. See following image:
Selecting the Done button
Your photo will be cropped, and the result displayed on the screen. Refer to below image:
Original on left, cropped on right
Do not forget that you can share the photo with your friends using the Share button in the bottom toolbar which looks like a box with an arrow coming out of it. See below image:
Selecting the Share icon
Undo Your Crop
All edits in the Photos app are non-destructive. This means that you can revert any photo to its original state.
First, open the photo in the Photos app. Tap the Edit button in the top right-hand corner. See following image:
Selecting the Edit button
Now, in the bottom right-hand corner on iPhone, tap the Revert button. Refer to below image:
Selecting the Revert button
Next, in the pop-up, choose the Revert to Original option. See below image:
Revert your photo back to the original
Now, your photo will be back to its original form!
Quote For the Day
We are cups, constantly and quietly being filled. The trick is, knowing how to tip ourselves over and let the beautiful stuff out.
Ray Bradbury
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.
Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.
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
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.
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
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:
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:
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.
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
The Reading List is a similar concept to bookmarks but intended for reading material that you find online. At the time of this writing, it’s available in Chrome on the desktop (Windows, Mac, and Linux) and for iPhone and iPad. The feature is not available on Android.
The Reading List is a similar concept to bookmarks but intended for reading material that you find online. At the time of this writing, it’s available in Chrome on the desktop (Windows, Mac, and Linux) and for iPhone and iPad. The feature is not available on Android. For this blog post, we will explore this feature for the iPhone and iPad.
This is for the iPhone and iPad using Google Chrome
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS
Chrome for iPhone and iPad has two different ways to add web pages to your Reading List. It can either be done from Chrome or from another app.
Method 1 – Within Chrome
First, find a page to save for later, and then tap the Share icon in the address bar. Refer to below image:
Accessing the Share icon
Next, select Read Later from the menu. See below image:
Selecting Read Later option
That’s it! The page is now in your Reading List.
Method 2 – Use an App
The second method allows you to add things to the list from outside of Chrome. Now, find a news article or story that you would like to read later in any app. In our example, we are using Apple News. Next, find the Share icon in the app and tap it. See following image:
Accessing the Share icon
Now, find Chrome in the app row and select it. If you do not see Chrome, tap the three-dot More menu. Refer to below image:
Finding the Chrome app
Now, find Chrome from the app list and tap it. See below image:
Selecting Chrome app
Next, from the Chrome menu, tap Read Later. See following image:
Selecting Read Later option
To access the Reading List on your iPhone or iPad, first, open Chrome and tap the three-dot Menu icon at the bottom. Refer to below image:
Accessing the Menu icon
Next, select Reading List from the menu. You will notice a number that indicates unread pages. See below image:
Accessing Reading List option
Now, the Reading List will open with Unread pages at the top and Pages You’ve Read at the bottom. Pages marked with a green check are ready to read offline. See following image:
Your Reading List
Next, tap Edit in the bottom corner to manage the list. Refer to below image:
Selecting to Edit your Reading List
From here, you can select pages and delete or mark them as read. See below image:
Selecting Delete or Mark as Read option
The Reading List is a nice, simple alternative to apps that provide similar services. It all happens right inside of Chrome without any additional software.
Quote For the Day
We’ve gotta reinvest in space travel. We should’ve never left the moon.
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.
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
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.
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.
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:
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:
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:
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:
Select your data
Now, click Create on the People Graph screen. See below image:
Create the People Graph
Customize Your PeopleGraph
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;
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:
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:
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:
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:
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:
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.
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
iPhones are awesome communication devices. So it makes sense that you would want to put the people you talk to the front and center.
Surprisingly, Apple does not make it clear that it’s even possible to do this. The functionality is buried in the powerful Shortcuts app. Let’s explore how this is done.
This is for the iPhone and iPad
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS
There are basically two different actions that can be associated with contact Shortcuts. You can have the Shortcut give you the option of how you want to contact the person; Message, Call, FaceTime; or it can jump straight into one of those. We will be covering the first option.
Create the Shortcut
First, open the Shortcuts app on your iPhone or iPad. Refer to below image:
Accessing your Shortcuts app
Next, go to All Shortcuts See below image:
Find All Shortcuts
Now, switch to the Gallery tab in the bottom bar. See following image:
Open the Gallery of Shortcuts
Add the Contact
Next, do a search for Contact, and select the Contact on Home Screen shortcut. Refer to below image:
Search for a contact
Now, tap the Add Shortcut button. See below image:
Add contact Shortcut
On the next screen is where you will select a person for the Shortcut. Tap the “+” button. See following image.
Selecting to add a contact
Now, find the person you want to use for the Shortcut in your contacts list. Refer to below image:
Locate a contact
Next, tap Done to finish. See below image:
Finish the setup
View the Newly Added Shortcut
Now, go back to the My Shortcuts tab, and you will see the newly added Shortcut. Touch and hold to bring up some options. See following image:
View your Shortcut
Next, select Details from the menu. Refer to below image:
Accessing Details for the Shortcut
Add to Home Screen and Customize
Now, select Add to Home Screen. See below image:
Add contact Shortcut to your Home screend
Next, tap the text to enter the name that you would see under the icon on the Home screen. See following image:
Label the Shortcut icon
Now, select the icon to choose a photo for it or the other two options. Refer to below image:
Select a photo for the contact
Next, once you are done customizing the icon, tap Add in the top right-hand corner. See below image:
Finish customizing
Now, the icon will be added to your Home screen. When you tap it, a menu with communication choices will appear. Simply do this for all of your favorite people! See following image:
Your Shortcut in action
Quote For the Day
It doesn’t matter how beautiful your theory is, it doesn’t matter how smart you are. If it doesn’t agree with experiment, it’s wrong.
Richard P Feynman
Pretty nifty feature. It’s like having a person on speed dial. 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.
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
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
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
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:
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:
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.
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
One of the upgrades to Accessibility in iOS and iPadOS 15 is a new Background Sounds feature that plays relaxing audio tracks to help you stay calm and focused, and to block out background distractions.
One of the upgrades to Accessibility in iOS and iPadOS 15 is a new Background Sounds feature that plays relaxing audio tracks to help you stay calm and focused, and to block out background distractions.
This is for iPhone and iPad
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS
What Are Background Sounds
Background Sounds are like having a sound machine from your bedroom in your iPhone and iPad. The sounds can also be played over Bluetooth to external devices.
With thenew Background Sounds feature, you can play balanced, bright, and dark noise, as well as ocean, rain, and stream sounds to help you concentrate and relax when using your iPhone or iPad.
The feature may negate the need to purchase or subscribe to third-party background noise apps. Its not a dedicated app, but rather hidden away inside your device’s Accessibility settings.
It’s worth noting that at the current time, there is no way to load your own background sound. Note as well that they do not have a time limit. They will only turn off when you disable them. This is a glaring omission by Microsoft. I would like to turn on sound at night as I fall asleep and have it automatically turn off at a certain time. Anyway. let’s explore how to use this feature.
Background Sounds in Accessibility
Apple sees Background Sounds as a way to diversify its array of accessibility features by being more inclusive.
The company says in its official announcement of the feature that it targets “support of neurodiversity” and aims to mitigate “distracting, discomforting, or overwhelming” everyday noises. In other words, the feature can help you focus and relax during the day and mitigate distracting sounds that are bothering you.
That being said, the feature has the ability to appeal to many different people, so it’s interesting that Apple decided to stick with the accessibility angle instead of a more generalized approach.
Enable Background Sounds
First, open the Settings app. Refer to below image:
Accessing Settings app
Next, scroll down and tap Accessibility. See below image:
Accessing Accessibility option
Now, under the Hearing section, tap Audio/Visual. See following image:
Accessing Audio/Visual option
Next, tap Background Sounds. Refer to below image:
Accessing Background Sounds option
Now, you can toggle Background Sounds On and Off and choose which sound you would like. You can also adjust the volume of the sound as it plays over other media. If you do not want the background sound to play while, for example, listening to music, uncheck Use When Media Is Playing. See below image.
Selecting your sound
You are ready to listen to relaxing, distraction-free sound from your iPhone or iPad. If you want other particular sounds, consider trying out a third-party white noise app.
Quote For the Day
It’s not going to do any good to land on Mars if we’re stupid.
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.
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
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.
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
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:
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:
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:
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:
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:
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:
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:
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:
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:
Select formatting for errors
Now, those errors will be very visible! Refer to below image:
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.
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
Tech Savvy Life 