Posts

Highlight Rows with Dates using Conditional Formatting in Excel We will show you the following two methods to highlight the rows with dates earlier than today’s date or a specific date: 1] Highlight rows with dates earlier than today’s date by using the Today() function The Today() function represents the current date in Microsoft Excel. If you type the =Today() function in any cell and press Enter, Excel will show you the current date....

What is the Alt Gr key on my Keyboard ALT GR or the ALT GRAPH key is found on some international keyboard which also supports locale, i.e., accented letters or currency and special symbols. This key is handy for anyone assuming one working with a language where one needs to use accent characters sometimes. Using it is rather straightforward. Just like how you use the Control key for Ctrl + C, you can use ALT GR + key which also houses the special or the accented letter....

Social Engineering makes use of PDF for Phishing A new variant of the Phishing attack makes the PDF file look like a protected Excel file that can only be displayed with Microsoft Excel after entering email credentials. The attachment is mainly carried by an email message that pretends to be official communication, faking authenticity. It urges the potential victim to open the file by following the link offered in the PDF file....

It’s a great time to talk about Windows activation and how it’s going to work. For customers who are already familiar with activating Windows 11/10/8/7/Vista, this will feel pretty familiar and, as far as the user experience goes, it’s not too different from Windows XP. You can activate either online or by phone. When you install Windows and log in with the user account, Windows will ask you to activate it....

Photos app has been offering a lot of good features like create video from images, web image search, merge videos, create a living image, and more. You can also add various 3D effects and text animations to your images using it. Let us check out how! Add 3D Effects and Animated Text in Windows 10 Photos app Here is the stey by step procedure to add 3D effects and animated text using the Photos app in Windows 10:...

Many users have multiple email accounts associated with different email providers, such as Gmail, Outlook, etc. Being an Outlook and Gmail user, it is quite complicated to manage both email services without a dedicated email client for Windows 10. To get rid of that issue, you can take the help of the new functionality of Outlook.com to include your Gmail ID in Outlook.com so that you can use two email accounts at the same time....

Add Dropbox as a Place in Office You can add Dropbox as a Place through your Dropbox preferences but firstly, you must have the Dropbox app installed on your PC. Then, you can add the Dropbox as a save location in Microsoft Office. Follow these steps. Read the above steps in a bit more detail below! Sign in to your Dropbox account. If you do not have an account with Dropbox, create one....

How to attach a Folder to an Email To attach a folder to an email, you can either compress the folder into a file and then attach it, or upload the folder to a cloud service and then send its link. Compress the folder into a file and then attach it to your email One of the easy ways to attach a folder to your email is to compress it into a file....

Automatically fill Increment Cells in Excel Interestingly, we don’t even need a formula for this action. The Autofill function would be sufficient. Though we will discuss the formula as well. Increment numbers when value changes in another column using Autofill in Excel You can automatically fill increment cells in Excel using the Autofill function as follows: Pick a column and enter the numerical values in the first 2 cells. The difference between the numerical values in those two cells should be the increment value and the cell with the lower value should be above the cell with a higher value....

The first reason is that most of the websites are now using technology that gives away information that you are using a proxy. Only the new proxies are able to pass off your modified IP address as genuine while most such tools are detected and hence the websites get a little deeper into your computer to find out your identity. The second reason expands upon the first reason. I said that upon finding out you are using a proxy tool to access it, the website starts looking for something called browser independent cookies....

What is a Cookie Consent Popup? A cookie consent notification explicitly asks for users’ opt-in consent before deploying cookies. Some countries, including some EU countries, demanded it, and so now websites have to ask for visitors’ permissions before they drop cookies. If you have accepted them once you will not be asked again for a while; but if you use the Incognito mode, you will be asked every time you browse....

We should point out that the ability to determine the number of decimal places shown on a spreadsheet is possible on all versions of Excel from the year 2007 to date. For this article, we are using the Office 365 version of Excel, so the steps might be a bit different compared to the version you’re currently using. Now, there is more than one way we can change the number of decimal places in Microsoft Excel, and we will discuss each option....

As a Windows user, you must need to be well familiar with the basic commands and usage of the Command Prompt. In this guide, we will show you how to change directories in Command Prompt on Windows 11/10. How to change Directory in CMD If you want to change the directory in the Command Prompt, you have three options: 1] Using DIR and CD commands To get started, open the Windows search using Win+Q keyboard shortcut....

There might be a situation where you may want to have something other than a dot (.). What we can do, is remove that dot and replace it with the character that we want. If it is one or two, then it is easy, but what if we have many entries to change? Change Default Numbered List in Word This article will help you to change, edit or create the new numbered list as you want....

How to change the language of Widgets in Windows 11 Go through the following instructions to change the language of Widgets in Windows 11: As you change the language, the Microsoft News page will reload and you will see all the content in your preferred language. Now, restart your computer to see the Windows 11 Widgets in your preferred language. Unable to change the language of Widgets in Windows 11 You may experience an issue with Windows 11 Widgets where the language does not change after restarting the computer....

Before getting started, let us explain the process to easily go through the required steps. Without activating Windows 10, Windows Settings shows a message – You need to activate Windows before you can personalize your PC. Also, the options are grayed out before activation. Now, if you do not want to activate Windows, and instead, you want to change the theme for any reason, you need to have the ....

Let’s assume that you have made a few unnecessary or incorrect changes in a Word document. There are two ways to rectify the mistake. First, you can change all the wrongdoings manually. Second, you can press Ctrl+Z to undo all the changes. However, if the number of mistakes is more than 20, you won’t be able to get things done. In such situations, you need to increase the number of Undo limits in Word....

The CMD window sometimes gets very cluttered and in that case, well, you can always close and reopen a new window, there is a simple way to clear the entire CMD screen with just a simple command and start afresh. Let’s see how. Clear CMD screen in Windows 11/10 To clear the CMD screen on your Windows 11/10 PC, you just a simple command – Type, CLS and hit Enter....

What are web add-ins? An add-in enhances the performance and enriches the user experience. If an add-in uses a web service to complete a task in any Office app, it is called a Web add-in. You can install and use various web add-ins in Word, Excel, PowerPoint, and other Office apps on Windows 11/10. However, if you want to clear the web add-ins cache automatically when you close the app, you must follow this guide....

How to reduce the file size of a Word document? Here’s all that you can do to compress and reduce the size of your Word document. 1] Compress images in the document There is only so much drive space that words on a document may be eating up, it is the pictures that you’ve uploaded in your document which eat up the space. A method to remediate that is to compress these images....