Category: Excel

Go to the File tab located on the Ribbon menu. Click the tab to open its menu. Then, under the Office Theme heading, click the drop-down arrow to choose the Black theme. This will enable the Dark mode across all your devices using the same Microsoft account. Windows 10’s system-wide dark mode won’t affect Office […]

First, check to see if Excel is freezing in more than one spreadsheet. If Excel freezes in any file you open, it is likely related to the program itself. If it only happens in one file, you will have to pinpoint what exactly is causing the problem in that file. The COM add-ins are very […]

If your Excel file is opened as ‘read-only’ due to antivirus settings, then you might need to adjust the setting from your antivirus software’s properties. If the problem still persists, you might need to check with the antivirus provider to find out how the setting can be changed. If an antivirus is causing the Workbook […]

How to Find the Version of Excel with VBA Code Press Alt + F11 to open the Microsoft Basic for Applications window. Copy and paste the below VBA code into the Module window, and then press the F5 key to run the code. Then a Microsoft Excel dialog box pops up with the version number […]

Select data > Home tab > Style group > Click on Conditional Formatting > New Rule > Select Format only cells that contain > Select greater than or equal to > > Enter number > Select color > Click OK 1. Select the range in which you want to highlight cells if the number is […]

List all selected hyperlinks with VBA code. Select the range which contanis the hyperlinks that you want to list. Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following code into the Module: Address:=””, SubAddress:= (cl. Parent. Name) & “!”. Why […]

There are no practical tips or tricks for doing math. Instead, this is a self-help book about how to learn “better. ” (There’s a whole section on the Pomodoro Technique, for crying out loud.) If you already value studying and understand how your brain wrestles with new information, this book won’t tell you anything you […]

Check if the number is integer with formulas in Excel. To check if the given number is integer or not, here are some formulas may help you. Please do as follows: 1. In a blank cell, please type this simple formula: =int (A1)=A1, see screenshot: 2. Below is the INT Formula in Excel. Number or […]

Overview By default, Excel activates certain “protected view” settings. This is meant to prevent you from opening an potentially infected file downloaded from the Internet, sent to you in an Email, etc. The reality, however, is that it typically ADDS an additional step to opening many Excel files that you receive. Excel Protected View is […]

Just ONE cell with ONLY one Number is copied&pasted, not formulas, the cell does not depend on any other cell. It happens to both online shared files and domestically saved files. Big files and small files. When the slow down happens, only excel is affected, all other apps or office apps run perfectly. Why excel […]