We have already seen how to manage Windows Firewall. In this post, we will see in detail how to block or open a port in Windows 11/10/8/7 firewall. Block port in Windows Firewall When in the ‘Advanced Settings’ of Windows 8 firewall, click the Advanced settings link in the left-hand pane of the main firewall dialog. This will bring up the Windows Firewall with Advanced Security window. Now, if you see the firewall window shows a list of rules on the left side....

What are Sporadic Totals? The sporadic definition means anything appearing or happening at irregular intervals in time or occasionally. Sporadic numbers include numbers that are neither reliable nor periodic. These are not regular and cannot be counted on continuing. When it comes to Excel, it is not an easy task and cannot be done easily if we have huge data in an Excel sheet in this pattern. In this article, I will show you how to calculate sporadic totals in Excel easily, which helps you calculate the sum of intermittent cells....

You can even make the Control Panel applets appear in All Items List view. The list can further be displayed using Large icons or Small icons. All this can be easily changed using the View by settings’ drop-down menu and selecting the one you want. However, if you find that this view setting does not always stick, and changes every time you open the control panel or restart the computer, you might want to look at tweaking the Windows registry....

How to change Font size in Firefox Picture in Picture Mode To change the Font size in Firefox Picture in Picture Mode subtitles and captions, follow these steps: 1] Open the Mozilla Firefox web browser To begin, we must first launch the Firefox web browser since what we’re going to discuss here is not tied directly to Windows itself. Find the location of the shortcut icon for FirefoxClick on it once or double-click to launch it....

To change Langauge in Xbox 360, Xbox One, Xbox Series X/S, you need to follow different procedures. We have mentioned methods for each of the consoles separately hereinafter. How to change Language in Xbox 360 If you want to change language in Xbox 360, follow the prescribed steps. This will change the language of your console. If you want to change the location as well, click on Locale from Language and Locale option and then select a country....

What is the Navigation Pane in Microsoft Outlook? The Navigation Pane is a menu in Microsoft Outlook which can be used to navigate to functions other the email. It is either at the bottom or left-hand side of the window. You can access the following menus through Microsoft Outlook: EmailCalendarPeopleTasksNotesFoldersShortcuts How to change Outlook Navigation Pane position If you wish to change the Outlook Navigation Pane position back to the bottom, then you can try the following 3 methods:...

OneNote allows users to share the notebook with friends, colleagues, and family thus promoting multi-user collaboration. It is also possible to grant editing permissions with the people you share notes. The participants can view and fully edit your notes and all the modifications will be updated automatically. If you have already shared your OneNote notebook on OneDrive, you will be having the flexibility to change the permissions for a notebook on who can only view them or edit them....

Reduce column width size of the File Explorer in Windows 11 By default, the layout view set for the File Explorer is the Details layout view where all the folder details are displayed in columns. This column size can be modified primarily in four ways: 1] By using “Size Column to Fit” in Folder Open File Explorer by pressing the Windows + ‘E’ key combinationOpen the folder that you want to change the column width forPress and hold the column head that you want to resizeClick on Size Column to Fit...

Microsoft first introduced this in Windows Vista. Microsoft removed the Experience Index from Windows RT but kept it on the original release of Windows 8 in October of 2012 I think it’s a bad move from Microsoft that they decided to kill this feature. It was a nice way to benchmark a PC without any additional tools. Well, at least the geeks used to look at this score and compare the performance, but when it comes to average home users, they couldn’t care less about this feature....

There are different types of cloud providers – SaaS, PaaS, and IaaS etc. Microsoft offers all three types, from OneDrive to Office 365 to Azure and thereby covering all possible types of services one can expect. If you feel Microsoft is too costly, you can go for other cloud providers. You have to evaluate the services so that your data is safe, accessible anytime (low downtime), and gives you the freedom to move your functions to other clouds anytime....

Word Grammar and Style Settings By default, Microsoft Word basic Grammar checking is enabled. If required, one can turn on additional styles as well and configure other options. To do so, click on the ‘File’ menu and select ‘Options’. From the options displayed in the left pane, select ‘Proofing’. On the right-hand side look for ‘When correcting spelling in Grammar and Word’ section. When found, click the drop-down arrow under Writing Style: and select Grammar & Style....

Now, if you have models saved in DWG files and you want to share them with others, you will need to convert them to a common and user-friendly format like PDF. To help you out, we will be sharing different tools that enable you to convert DWG to PDF. You can use any of the listed methods to perform DWG to PDF conversion on Windows 11/10 PC. So, without much ado, let us get started with the main solutions now!...

What is the Convert function in Word To change from one form or use to another. In this article, we are going to discuss how to: Finding the Convert Table to Text and Convert Table to Text If you do not see the Data Group on your Standard Toolbar in the Layout tab, right-click on your Standard Toolbar, then click Customize the Ribbon; a Word Options dialog box will pop up....

How to count unique values in column in Excel Count the number of unique values from a list of a column using the array formula The syntax for counting the number of unique values from a list of a column using the array formula is as follows: Where, is the first cell in the column from which you begin the count. is the last cell in the column till which you count....

What is a Contact Group in Outlook for PC Contact group (formerly, Distribution List) is a list of people or email addresses that you can use to send emails to more than one person at once. If you create a contact group or list, you do not need to type all email IDs of a set of recipients when sending an email. This feature is handy when you want to send multiple emails to multiple people frequently....

PowerPoint allows users to add a theme from the Design tab. It changes the default background color, font, overall color scheme, etc. What if you need to use a different font? What if you need to make some tweaks in color and apply the same design to all the slides of your PowerPoint presentation? You can open each slide and make the changes, or you can create a preset or theme to apply the same at once....

How to setup Wallpaper Slideshow in Windows 11/10 The process to create a Desktop Wallpaper Slideshow in Windows 11 or Windows 10 involves the following steps, which we will go into detail later on: You need to lay out some groundwork before setting up the slideshow. This involves making a folder consisting of all the wallpapers you want to have displayed on your desktop as a part of the slideshow. Simply open File Explorer, visit the library where you want to house this folder (that could be Desktop, Downloads, Pictures, anything), click on ‘New Folder’ and paste all your desired wallpapers there....

How to make a Poll in Discord Folks who are members of Discord and are interested in learning about the feelings of other community members can take advantage of the poll feature offered. The platform gives us a few ways to create polls. For example, folks can use bots to create polls with ease or make use of what channels have to offer. Now let us see how to create polls in Discord using the above methods via a desktop computer....

When do you need an Autorun File Say you have a program “XYZ.EXE” and you want to run it automatically when you insert your USB/DVD/CD. Typically Windows look for an information file called Autorun.inf. Its a simple text file that contains information on which program Windows should automatically launch when the storage device is inserted. In other words, autorun.inf tells Windows how to deal open the presentation and treat the contents of the CD....

Create and Manage Xbox Guest Account The advantage of setting up a guest account goes both ways. You have more control compared to a regular account, and they can participate in side-by-side multiplayer games but does not have their own Xbox Live account or gamertag. What happens when you create a guest account? Xbox creates a temporary account. It is a copy of the account of the family member who is currently on the console....