How to add or remove Cell Borders in Excel In Microsoft Excel, borders are lines that form around a cell. In Excel, there are options to add both predefined cell borders and custom cell borders. 1] How to add borders to a cell in an Excel worksheet Open Microsoft Excel. Click on a cell in the worksheet. On the Home tab in the Font group, you will see a border icon; click on it, you will see a list of predefined borders; click any choice you desire, it will automatically appear into the cell you selected....

What is Layered Group Policy in Windows 11? This Group Policy aims to ensure the machines get less corruption, the number of support cases drops, and the most important is to reduce data theft. The policy ensures to restrict any installation, i.e., the use of devices both in the internal and external environment is blocked. IT admins can choose to pre-authorized devices to be used/installed. Available here, the script makes sure not all classes are blocked: Computer Configuration > System > Device Installation > Device Installation Restrictions this means that if you chose to block the USB device usage, it only blocks it....

How to blacklist or block websites 1] Using Proxy Script to block websites in Chrome, Edge, IE You can use a proxy script to block all websites except the ones belonging to your organization. In effect, you are whitelisting one site here, and blocking out the others. I found a script at berkeley.edu, which does this: If you copy the above script to Notepad and save it as a .pac file, you will be able to open websites related only to TheWindowsClub....

What is Email Tracking? Email Trackers use some form of an interactive element in the email that gives out the details when we interact with them. It could even be a very small image that is not visible. This is called Pixel Tracking. This information is then used to decide the nature and the frequency of the emails that will be sent to you. Block Email Trackers One of the simplest ways to track someone online is by the use of a redirect link, and it is easy to spot....

How to calculate CAGR in Excel When calculating the CAGR, you must first add the periods and the values for each period. To do this, you need a column focused on Years and another column focused on the Amount. If you are still unsure, then the information below will explain all the things you need to know. Here are the steps involved: 1] Add the data to Cells From the first Cell under A, you must type the word Year....

When you start Excel on your computer, you will find only one sheet. Let’s assume that you want to create a report for students that requires multiple worksheets. You can click on the “New Sheet” button to create a new sheet. But, what if you need to create multiple reports of say thirty or forty students? If you go to click on the New Sheet button every time, you will end up wasting a lot of time....

How to change File and Folder permissions in Windows I was talking about individual criteria that you need to meet. Those criteria are user authority or power. If you are an admin user, you can almost change anything in Windows. It includes the ability to modify files that are owned by others. However, if you are standard users, you are limited to changing files that only belong to you. In this post, we will discuss the following: While it looks complicated, it is relatively easy to manage permissions....

Before you go on, you might want to know the difference between Key Repeat rate and Repeat delay. Change Keyboard Repeat Rate & Repeat Delay There are two major methods to set the Keyboard Repeat Rate and Repeat Delay on Windows 11/10. They are as follows: 1] Using the Keyboard Properties Open the Keyboard Properties by typing in control keyboard in the Run box (Win+R) and hit Enter. You can now use the slider to make the respective options of Repeat Delay and Repeat rate longer or shorter as per your preferences....

Change ruler unit in Word & Excel It works on any Office installation. I tried it with Office 365 on my computer. As an example, we will show you how to do it in Word: You can change the ruler unit from inches to centimeters, millimeters, points, and Picas. Points are used when you need to simulate pixels, while Picas are typically used to represent fixed horizontal measurements. When you want to see how exactly it will look on a physical paper, this is what should be used....

What is a UEFI system? In a nutshell, UEFI (Unified Extensible Firmware Interface) is an evolvement over BIOS (Basic Input Output System), and it acts as a software interface between the operating system and platform firmware. Since HackBGRT only supports UEFI systems, you need first to find out if your computer is using UEFI or BIOS. Caution: Making changes to the bootloader is a little risky, and it could make the system unbootable....

Windows now includes an improved Storage Optimizer. When the Storage Optimizer detects that the volume is mounted on an SSD – it sends a complete set of TRIM hints for the entire volume again – this is done at idle time and helps to allow for SSDs that were unable to clean up earlier – a chance to react to these hints and cleanup and optimizer for the best performance....

How to check GPU health on a Windows computer There are different methods by which you can check GPU health on a Windows Computer. Below, we have explained all these methods in detail. Let’s start. 1] Check your GPU health by using the DirectX Diagnostic Tool DirectX Diagnostic Tool is used to test DirectX functionality and troubleshoot sound and video-related hardware problems. You can also use it to check your graphics card health....

The exact problem from a user How to compare same files in same folder in different locations What is needed here is a software that can compare the two folders, which may or may not have the same name, but the folders are essentially in two different locations. Problem: Sometimes, my C-Drive might have a folder containing way more files in it than the EHD does. For example, the My Pictures folder located on the C-Drive might have 1,100 files in it, and the same folder located on the external hard drive might have less, 950 files in it....

How to configure use of passwords for BitLocker removable drives To configure the use of passwords for BitLocker removable drives in Windows 11/10 using Group Policy Editor, follow these steps: Let’s find out more about these steps in detail. First, you need to open the Local Group Policy Editor on your PC. For that, search for gpedit or gpedit.msc in the Taskbar search box and click on the search result....

Convert MP4 to MP3, AVI, GIF, MOV WAV, WMV file formats We list below a free file format convertor software, a Microsoft Store app and a free online file converter tool that will help you convert MP4 to MP3, AVI, GIF, MOV WAV, WMV file formats easily. 1] Free File Converter software for Windows PC File Converter is an open-source Windows program that converts and compresses your files without compromising the quality....

People often use VHDX as it comes with more storage capacity than VHD. For your information, VHD can carry up to 2 TB of storage, but the VHDX can carry up to 64 TB of storage. If the virtual machine plays an essential role in your work, you should opt for VHDX, as this format is compatible with most of the virtual machine managers as well. However, let’s assume that you had a virtual machine that supports only VHD format, and now you want to move to VHDX....

But what if you want to access your resources at home while you are away? What if you want to use the private server at your office or home while you are away? This brings in the callout for a VPN server for yourself. Today, we are going to learn to do the same. How to create a public VPN Server on Windows 11/10 In this process, we will be undertaking the following steps...

How to create a Roadmap in PowerPoint There are two methods to create a roadmap in PowerPoint presentations including: Let’s check out these methods in detail! 1] Use a Pre-designed Roadmap template from Microsoft The easiest and quickest method to make a roadmap is to use a pre-designed template available from Microsoft. You can find some roadmap templates in the PowerPoint’s online library that you can import and use in your presentation....

How to create a Tabbed Form in Access Follow the steps below on how to create a tabbed form in Microsoft Access: 1] Launch Access & open Form Layout Design Launch Microsoft Access. You can either open the form on Design View or Layout View. We have decided to open the form in Layout View. On the Form Layout Design tab in the Controls Gallery, click Tab Control. Now click where on the form you want to place the tab control...

Create a textured slide background in PowerPoint Another question you might ask is “Is White background not good enough to lend a professional look?”. Again the simplest answer is that, yes, any single color will work but they might look like a spotlight to the audience who are sitting at the back. Moreover, having a textured background fills your presentations with some color which keeps the audience hooked to your presentation....