You are reading the article How To Enable Or Disable Error Checking Rules In Microsoft Excel updated in December 2023 on the website Kientrucdochoi.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 How To Enable Or Disable Error Checking Rules In Microsoft Excel
The real power of Microsoft Excel lies in its formulae. However, as a Microsoft Excel user would know well, making mistakes with formulae are common since they are complicated. You can fix this by tracing these errors and checking suggestions for improvements. This is called Background error checking. We will show you the procedure to enable or disable the same.
What is Background error checking in Excel?Microsoft Excel is not only about arranging data in sheets. The real purpose of the software is to make calculations. Microsoft Excel is used to create information out of random data. Formulae are used for this purpose. Since formulae in Microsoft Excel can get very complicated, it is important to check them for errors. When Microsoft Excel does this process automatically in the background, then it is called Background error checking.
How to enable or disable Error checking rules in Microsoft ExcelBackground error checking is enabled on Microsoft Excel by default. However, if a third-party extension disabled it or another user disabled the option, it can be re-enabled again as follows:
Launch Excel
From the menu, select Options.
Go to the Formulas tab.
In the Error checking section, check the box associated with Enable background error checking.
If you wish to disable Background error checking, then simply uncheck the box.
If the enabling or disabling or Background error checking is caused due to a third-party extension, you will have to disable the same.
How to change the color for Background error checking in Excel?The color for errors marked through the Background error checking process are all green. This is because green is the default color for these marked errors. You can change this color as well. The procedure is as follows:
Go to the Formulas window as explained earlier.
In the Error checking group, you will find an option for Indicate error using this color.
Change the color from the drop-down menu.
How to reset Ignored errors in Microsoft Excel?The Background error-checking process marks errors as per a set procedure. Many errors marked by the process could be genuine formulae or instructions. In this case, you can ignore them or whitelist them. Should you be willing to reset this list of Ignored errors, then the procedure is as follows:
Go to the Formulas window as explained earlier.
Scroll down to the Error checking section.
You will notice a button for Reset Ignored Errors.
How to modify Error checking rules in Microsoft Excel?The Background error checking is dependent on a set of rules which can be modified. Basically, these rules indicate which figure or formula will be marked as an error. The procedure to change these error-checking rules is as follows:
Go to the Formulas window as explained earlier.
You will notice options with checkboxes.
Check a box to enable the associated option and uncheck the box to disable the associated option.
How to change error checking rulesin Microsoft Excel?The meanings of the error checking rules are as follows:
1] Cells containing formulas that result in an errorWhenever the error is with the syntax of the formula itself, then this rule comes into play. It is marked with #VALUE! or #DIV/0! .
2] Inconsistent calculated column formula in tablesThis rule marks cells in which the syntax of the formula may be correct, but the formula might be inconsistent with the column. Eg. If you mark a column which doesn’t fit in the formula, then you will get an error.
3] Cells containing years represented as 2 digitsYears should be represented as 4 digits. Some people prefer them as 2 digits. This rule will mark the cell if the year is marked as 2 digits. If you did this intentionally, then you can consider unchecking the checkbox associated with this rule.
4] Numbers formatted as text or preceded by apostropheWriting ten and mentioning 10 is read differently by Microsoft Excel. Similarly, writing 10 and “10” is read differently by Excel. Anything other than numerical representation of numbers is not read by formulas.
5} Formulas inconsistent with other formulas in the regionWhen you use lots of formulas in Microsoft Excel, eventually, formulas become dependent on each other. In many cases, the value obtained by one formula is used by another one. In this case, the mentioned rule will mark an error if a formula you created in not in conjunction with other formulas of the region in the Microsoft Excel sheet.
6] Cells containing data types that couldn’t refreshA lot of data in Microsoft Excel is picked from other sources. As an example, you can add stock market data to Microsoft Excel. Since this data keeps changing, Microsoft Excel keeps refreshing the data and uses that data for other calculations. However, imagine a case where the internet is not working, or the server of the stock market is down. In this case, the data will not refresh. This rule will mark an error to indicate the same.
7] Formulas which omit cells in a regionFormulas may or may not influence all cells in a region. However, if they do not impact each cell, the mentioned rule will come to play. Should this be done intentionally by you, the rule can be left unchecked.
8] Formulas referring to empty cellsAn empty cell carries a default value of 0 but that might not always be the intention for keeping the cell empty. If a cell included in a formula is empty, it will be marked if this rule is active.
9] Data entered in a table is invalid 10] Misleading number formatsWhen you read dates, time, etc, they use a specific format. This is called number format. The Misleading number format rule can help with marking such number formats.
Why does Background error checking in Excel keep disabling on its own?A lot of functions in Microsoft Excel are managed by its extensions. These extensions can also manage the Background error checking and disable the option. Merely re-enabling it will not solve the problem for long-term. You can disable the problematic extension as follows.
Open Microsoft Excel.
In the left pane, go to the Add-ins tab.
Corresponding to the drop-down menu associated with Manage, select COM Add-ins.
Try this method till your problem gets fixed. You will be able to figure the problematic extension using the hit and trial method.
How do I enable error checking in Excel?To enable error checking in Excel, you need to follow the steps as mentioned above. Open the Excel Options panel first and switch to the Formulas tab. Then, find the Enable background error checking option and enable it to turn the feature on. You can also follow the article for a detailed guide.
How do you enable the Formulas referring to empty cells in the error checking rules?As of now, there is no option to enable or disable this functionality in Microsoft Excel. However, if you want to turn on or off error checking in the same app, you can go through the above-mentioned steps. For your information, you can set various conditions to enable or disable the error checking.
You're reading How To Enable Or Disable Error Checking Rules In Microsoft Excel
How To Enable Or Disable Nvidia In
Nvidia’s GeForce Experience brings with it a lot of benefits, including the Nvidia in-game overlay. This feature allows you to start broadcasting your game, perform instant replays, and record gameplay with just a tap of a button.
The Nvidia in-game overlay also lets you adjust Nvidia GPU settings on the fly to achieve optimal performance in your game, regardless of whether you’re trying to beat your high score or win a close game of Overwatch. This guide will show you how to open the Nvidia in-game overlay and troubleshoot potential issues.
Table of Contents
How to Enable The Nvidia In-Game OverlayThe overlay works with most games, but it requires you have GeForce Experience installed first. Many modern systems including Windows 10 and Windows 11 come with this application pre-installed, especially if they use an Nvidia graphics card. However, if you need to download the latest version, you can do so from the Nvidia website.
After you have installed GeForce Experience, you can open the overlay at any point by pressing Alt + Z. Doing this opens up several other features, too. You can take a screenshot with the overlay open by pressing Alt + F1, or you can enter Photo Mode by pressing Alt + F2.
Once in Photo Mode, you can change the way the game looks on-screen to snag screenshots with special effects. You can lay a 3×3 grid over the game, or you can apply different filters to what’s on-screen.
The filters include options like Colorblind Mode, which makes it easier for people that are colorblind to distinguish things in the game. You can also apply a Black and White filter, or a Painterly filter that makes the game look like it’s illustrated with brushstrokes. These filters only remain in place for the screenshot; as soon as you navigate away from the Photo Mode menu, the look of the game returns to normal.
If you do want to continue to play the game with the filters in place, that’s where the third option comes in: Game Filter. With the overlay pulled up, press Alt + F3 to bring up Game Filters. You can choose any of the filters you used for Photo Mode–along with a few new additional options, like the ability to remove the in-game HUD–and play the game differently.
This feature adds accessibility options, since colorblind players can use the Colorblind filter to better see the game. You can also access Performance metrics to measure the voltage, temperature of your GPU, and more. Keep in mind that using some features of the overlay, like the custom filters, can affect your frame rate.
How to Fix Nvidia OverlayIf you find that you can’t open the Nvidia overlay or that it doesn’t respond when you give commands, there are several steps you can take to troubleshoot and correct the problem.
Restart Your PCThe first and easiest step is to simply restart your PC. It takes only a couple of minutes and can resolve most common issues with your software.
Update Your GPU DriverOut-of-date drivers are another one of the most common causes of problems with the Nvidia overlay. You can fix the Nvidia overlay by updating your drivers to the most recent version.
Open GeForce Experience.
Select Drivers at the top of the screen.
Select Download at the top of the screen.
After you download the file, you may need to restart your PC before it takes effect.
Check For Microsoft Windows UpdatesIf your drivers are up to date, then the problem with opening the Nvidia overlay might lie in Windows itself.
Open Windows Settings.
Select Update & Security.
Select Check for updates.
If there’s an update available, Windows will download and install it. After this is complete, restart your PC and test the Nvidia overlay once more.
Run GeForce Experience as AdministratorSometimes you might need to run GeForce Experience as an administrator for it to have access to all the privileges it needs to run properly.
A window will pop up asking for confirmation. Select Yes.
Once GeForce Experience opens, launch a game and then press Alt + Z to open the overlay. This method will run it as an administrator just one time, but if it works, you’ll want to run it as an admin every time.
Select the GeForce Experience icon and choose Properties.
When the Properties menu opens, select the Compatibility tab.
Select Run this program as an administrator and then select Apply.
Doing this will ensure GeForce Experience runs in administrator mode every time.
The Nvidia in-game overlay is easy enough to activate and use, and opens up a lot of potential for users. You can change your gameplay experience with a filter, take customized screenshots, or even use accessibility features. It’s a useful program, and free to download.
How To Enable Ie Mode In Microsoft Edge Chromium
Microsoft deprecated Internet Explorer in favor of Edge Chromium in recent builds of Windows 10. The new browser, which comes with a plethora of cool new features also includes a compatibility mode for the Trident MSHTML engine from Internet Explorer 11. Known as ‘IE Mode‘, the feature helps load old websites and supports old applications that haven’t been updated to work with the Chromium-based software (or other newer browsers). So today, we will show you how to enable or activate IE Mode in Microsoft Edge Chromium via in-app settings and through the Windows Group Policy Editor for better compatibility with older apps and services.
Enable IE Mode on Microsoft Edge ChromiumAimed largely at enterprises that still run apps and intranet sites written for Internet Explorer, the IE Mode is available in both the legacy Edge based on the EdgeHTML engine, as well as on Edge Chromium, which started rolling out on Windows 10 early last year before being expanded to other desktop and mobile platforms. However, since the legacy Edge itself has been deprecated, our tutorial will deal exclusively with Edge Chromium. So without further delay, let’s check out how you can enable or activate IE Mode in Microsoft Edge Chromium on your Windows 10 PC.
What is IE Mode in Microsoft Edge Chromium?IE (Internet Explorer) Mode on Microsoft Edge Chromium is a compatibility mode that helps the browser render older sites and webpages written for Internet Explorer. It also enables enterprise users to use all of the sites their organization needs in a single browser.
The IE Mode uses the integrated Chromium engine for modern sites and the Trident MSHTML engine from Internet Explorer 11 (IE11) for legacy sites. As part of the functionality, only those sites that you specifically configure (via policy) will use IE mode, while all other sites will be rendered using the new engine.
Method 1: Using In-app Settings2. Now select Default Browser on the left pane. If you’re not in full-screen mode, the option may be hidden behind a hamburger menu (three small parallel horizontal lines) on the top-left.
Method 2: Using Local Group Policy Editor
You can also enable IE Mode on Microsoft Edge Chromium with Group Policy. However, to do that, you will have to download the policy template from the official Microsoft website. Here’s how you go about it:
Note: If you don’t have a file archiving software already on your computer, download WINRAR (free) to get started.
Note: The Group Policy Editor is only available in Professional and Enterprise editions of Windows 10. It is not available in Windows 10 Home.
8. First, enable this option [1] in the same manner as described earlier. Then set the path to your XML-sitelist [2], either as URL or as UNC if you’re using a local XML file. Finally, hit OK [3] at the bottom to save your changes.
Note: If you don’t have an Enterprise Mode site list, download the Enterprise Mode Site List Manger v2 from Microsoft (free). Make sure to specify your language before downloading.
Enable IE Mode on Microsoft Edge Chromium for Compatibility With Old Apps and WebsitesThe guide above works for Microsoft Edge Chromium v77.0.223 or higher (the latest version is Edge 88) in Windows 10 v1903 with KB4503293 or higher and KB4501375 or higher or v1809 with KB4509479 or higher. Once you enable IE mode, you will be able to run older websites and intranet pages, while still loading newer websites using Chromium.
How To Create A Combo Chart In Microsoft Excel
When you want to display different data sets visually, you can create a combination chart. If you want to show something like sales with costs or traffic with conversions, a combo chart in Microsoft Excel is ideal.
We’ll show you how to create a combo chart in Excel as well as customize it to include the elements you need and give it an attractive appearance.
Table of Contents
How to Create a Combo Chart in ExcelYou have a few ways to create a combo chart in Excel. You can convert an existing chart, select a quick combo chart type, or set up a custom chart.
Convert an Existing Chart to a Combo Chart
If you already have a chart showing your data, like a bar chart or even a pie chart, you don’t have to delete it and start from scratch. Simply turn it into a combo chart.
Select your current chart and go to the
Chart Design
tab.
Choose
Change Chart Type
in the Type section of the ribbon.
When the chart window opens, pick
Combo
on the left.
Then, select one of the combo chart layouts at the top and customize the series at the bottom.
Choose
OK
and you’ll see your new chart replace the original one.
Select a Quick Combo Chart TypeExcel offers three combo chart types that you can pick from for your data.
Select your data set and go to the Insert tab.
In the Charts group, choose the Insert Combo Chart drop-down arrow to see the options. Pick from a clustered column with a line chart, a clustered column and line chart with a secondary axis, or a stacked area and clustered column chart.
Create a Custom Combo Chart
If you don’t have an existing chart and prefer to customize the series and axis for the combo chart from the start, you can create a custom chart.
Select your data set and go to the
Insert
tab.
Choose the
Insert Combo Chart
drop-down arrow and pick
Create Custom Combo Chart
.
When the chart window opens, you’ll see four combo chart types at the top. Select one of these as the base for your custom chart.
At the bottom, you’ll see your data series, chart types, and options to pick a secondary axis. As you make your adjustments, you’ll see a nice preview of the combo chart directly above.
While a column chart and line graph work well together, you can choose a different chart type for each data series if you like. Select the drop-down box below
Chart Type
to the right of the series you want to change and select the new chart type.
By default, the first data series displays on the primary axis. However, you can change this or simply add a secondary axis using the
Secondary Axis
check boxes on the right side.
When you finish creating your custom combo chart, pick
OK
to save it and place it on your worksheet.
How to Customize a Combo ChartOnce you choose and insert your combo chart, you may want to add more elements or give the chart some pizzazz. Excel offers several features for customizing a chart.
Go to the Chart Design TabFor basic appearance features and chart elements, select your chart and go to the Chart Design tab.
Starting on the left side of the ribbon, you can use the Add Chart Element drop-down menu to add and position items like the chart title, data labels, and legend.
To the right, use the Quick Layout menu to change the layout to include and position elements without having to do so one-by-one.
In the Chart Styles section, you can use the Change Colors drop-down menu to pick a different color scheme or the Styles box to choose a whole new design.
With the remaining options on the ribbon, you can switch columns and rows, change the chart data selection, pick a new chart type, or move the chart to another sheet.
Open the Format Chart Area Sidebar
Use Chart Options or Text Options at the top of the sidebar depending on which item you want to change. You can then use the tabs directly beneath to make your changes.
Chart Options: Change the fill and border styles and colors, add effects like a shadow or soft edge, and set the size or position for the chart.
Text Options: Change the fill or outline styles and colors, add effects, and position or align the text.
Use the Chart Buttons (Windows Only)One more way to make adjustments to your chart is to use the buttons that display on the right side of it. These are currently only available in Microsoft Excel on Windows, not Mac.
Chart Elements (plus sign): Like the Chart Elements drop-down box on the Chart Design tab, you can add, remove, and position items on the chart.
Chart Style (paint brush): Like the Chart Styles section on the Chart Design tab, you can pick a different color scheme or style for your chart.
Chart Filters (filter): With this button, you can check or uncheck the details in your dataset that you want to display on your chart. This gives you a quick way to view only specific chart data by hiding other details temporarily.
Now that you know how to create a combo chart in Excel, look at how to make a Gantt chart for your next project.
How To Use Microsoft Outlook Rules To Manage Your Inbox
Managing your inbox takes work, especially when you receive many emails every day. Using rules in Microsoft Outlook, you can take care of your inbox automatically. This saves you time from manually taking action on messages and helps you handle your email.
How Do Rules Work in Outlook?Rules in Outlook allow you to set up actions for email that meets particular criteria. When the messages arrive in your inbox, the rules take over to perform those actions automatically.
For example, you can move email from your favorite store to a shopping folder, mark messages that come from your supervisor as important, or automatically forward email to your partner.
You can do things like this automatically once you set up rules, then just sit back and let Microsoft Outlook rules do the work of managing your inbox without lifting a finger.
How to Create a Rule in OutlookSetting up a rule in Outlook is a step-by-step process that the application walks you through. Start by selecting the email criteria, move on to picking the actions, optionally add exceptions to the rule, then turn on the rule.
Create a Rule From Scratch
The Rules Wizard box gives you the basic types of triggers to start, similar to templates in Outlook. Below “Start from a blank rule,” you can choose whether the rule will apply to email you receive or send.
Give your rule a name at the top and select the “Setup rule options.” Check the box to “Turn on this rule.” Optionally, check the other two to run the rule immediately on current email and use the rule on all of your email accounts.
Your rule now shows with a checkmark next to it in the Rules and Alerts box. If you want to disable the rule later, you can return here and uncheck the box. Select “OK” or “Apply” to save and exit or “Cancel” if you change your mind.
Did you know: you can turn emails into tasks in Microsoft Outlook.
Create a Rule Based on an Email
To create a rule based on an existing email, select the message in your inbox or open it in its own window. Go to the “Home” tab, open the “Rules” drop-down menu, and select “Create Rule.”
In the “Create Rule” window, you’ll see the available conditions at the top. Because you’re creating a rule based on the email, you can use criteria such as from that person, what the subject contains, or sent to only you.
Choose the action you want to take based on the condition. You can display it in the New Item Alert Window, play a sound, or move it to a folder.
If you’d like to add more conditions or actions, choose “Advanced Options.” You’ll see the same boxes as the Rules Wizard. Make your selection(s) to create your rule.
Tip: the next time you’re taking a few days off, set an out-of-office message in Outlook.
Outlook Rule ExamplesNow that you know how to create a rule in Outlook, let’s walk through a few useful examples. We are creating these rules from scratch using the instructions above.
Move Messages to a FolderIf you often move your messages to folders to keep your inbox organized, you can set up a rule to automatically move them and save some time.
Move through the Rules Wizard as shown above by optionally choosing more conditions and actions, adding exceptions, and finally naming and enabling the rule.
Flag Email for Follow UpFlagging email is another good way to organize messages, as it allows you to assign and see the flag as soon as the email arrives.
Follow the remaining prompts to move through the Rules Wizard and save and enable your rule.
Note: once a flagged message pops up, you can schedule your response in Outlook.
Assign a Category to an EmailTo quickly spot email that falls into certain categories, why not create a rule to do so upfront? This will put the messages in their respective categories for you to see at a glance.
Mark Messages With Priority
If you assign a priority to select email, like those from your boss or a special client, you can mark them as important right off the bat. Or perhaps you want to mark email where you’re included as CC as low priority.
Tip: become an email pro with Outlook keyboard shortcuts.
Frequently Asked Questions Where do I find my Outlook rules?You can access your rules if you’d like to disable, edit, or delete one or more in the Rules Manager window.
Why doesn’t my Outlook rule work?There can be several reasons that a rule you set up in Outlook isn’t working as expected. Below are a few things to look for:
Check the “Manage Rules & Alerts” box to make sure the rule is enabled.
Be sure that the rule calls for a valid folder or contact and not one you’ve deleted.
Confirm that a different rule isn’t being applied first.
For additional causes and solutions, look at the Microsoft Support page.
Can I set up a conditional formatting rule in Outlook?Conditional formatting is available in Outlook in a separate spot than the email inbox rules discussed here.
Go to the “View” tab and select “View Settings” in the ribbon. In the box that appears, choose “Conditional Formatting,” then set up the rule in the subsequent Conditional Formatting box.
Image credit: Pixabay. All screenshots by Sandy Writtenhouse.
Sandy Writtenhouse
With her BS in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She wanted to help others learn how technology can enrich business and personal lives and has shared her suggestions and how-tos across thousands of articles.
Subscribe to our newsletter!
Our latest tutorials delivered straight to your inbox
Sign up for all newsletters.
By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.
How To Disable Suggested Actions In Windows 11
The Suggested Actions in Windows 11 is a new feature. It provides suggestions if you copy a phone number/date/time to the clipboard using apps like Notepad, Microsoft Outlook, Gmail, MS Word, Microsoft ToDo, Sticky Notes and more. When the suggestions appear, you have to select a suggestion to further action.
This feature was launched with the Windows 11 22H2 update with several other new features. Unfortunately, this particular feature had a mixed reception. Some Windows 11 users are grateful to have this option, but some are simply annoyed and want to disable it.
So, if you are not fond of the new Suggested Actions in Windows 11 and want to disable it, this article is just for you. Read the guide below and learn the steps to disable this feature.
Disable Suggested Actions in Windows 11
The Suggested Actions feature is not everyone’s cup of tea. So, you may want to disable it. Disabling this option is simple and complicated at the same time. There are two built-in options to disable Suggested Actions in Windows 11. But if you have enabled the feature using ViVeTool, it would be best to disable Suggested Actions using the same tool.
1. From Windows Settings
This is probably the easiest procedure and if possible, stick to it. Here’s how to do it.
1. Open Windows 11 Settings.
2. Using Windows Registry Editor
Using Registry Editor is extremely risky. It is the heart of Windows, where all the system settings are available. So, one mistake! Good Bye Windows. Experts recommend taking a backup of the Registry Editor. Do it if possible. Once you are finished, follow the steps below.
1. Open Windows Registry Editor. (Press Win + R to open the RUN dialogue box. Type regedit and hit Enter to open Registry Editor.)
2. Navigate to the SmartClipboard key.
3. Access its Disabled value.
4. Change the Value Data to 1.
5. Exit Registry Editor.
Not too complicated. Still, navigate through the registry editor carefully.
Note: You can disable the Suggested Actions by changing the value to 1. Similarly, you can enable it by changing the value to 0.
3. With Windows ViVeTool
If you have enabled Suggested Actions on Windows 11 22H2 using ViVeTool, then use the same tool to disable it. Here’s how to do it.
1. You probably have the ViveTool already. If you don’t, download it from the GitHub page.
2. A ZIP file will download and you have to extract the contents.
4. After that, select Next and extract the files.
5. Create a new folder and name it the same as the ZIP File.
11. Hit Enter to run the command.
12. Now, run the following command.
vivetool /disable /id:34592303After executing this command, exit the command prompt. Restart your computer and Suggested Actions should be disabled.
Frequently Asked Questions
How to turn off Microsoft Word suggestions?
How to get rid of search bar suggestions on Windows 11?
Summing Up
Hence, disabling the Suggested Actions in Windows 11 is not a difficult task. This feature was rolled out with Windows 11 22H2 update but disabled in some regions.
If it’s already disabled, then you don’t have to worry about it. But if you have it enabled on your computer and want to get rid of it as soon as possible, then you need a proper guide. So, follow the guidelines detailed in the article, and you will be able to disable Suggested Actions on your computer.
Update the detailed information about How To Enable Or Disable Error Checking Rules In Microsoft Excel on the Kientrucdochoi.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!