ReBizRU

Switch between manual and automatic recalculation methods in Excel (Excel)

Excel, which contains a large number of formulas, will recalculate each time you perform some operation, and you will not be able to perform the next operation until the calculation is finished. If you feel that Excel is too slow, you can stop the recalculation to make it run more smoothly. Also, for some reason without realizing it...

2024.05.30

Excel Functions

Excel Macro (VBA) to stop automatic calculations

One of the factors that can make a macro very heavy is a large number of formulas in an Excel sheet. In such cases, it may be possible to speed up the process at once by stopping the automatic calculations. First, we will show you how to do this. Calculations without macros...

2024.05.28

Excel Macro (VBA)

How to Prefer Manual Fill to Conditional Formatting Excel (Excel)

Conditional formatting is a very useful feature that automatically fills in or changes formatting based on specified conditions. However, many of you may have experienced the problem that conditional formatting takes precedence over manual filling. In this article, we will discuss how to use conditional formatting...

2024.07.09

Excel Functions

How to display file extensions [Windows 11].

For the beginning computer user, there may be little trouble with file extensions not being displayed. However, once you have started to tinker with computers to some extent, there are situations where you may need to change the file extension or process a file differently depending on its extension, so this...

2024.10.08

Windows

"How to Create Your First Excel Macro (Beginner’s VBA Guide)

To write a VBA, you start with the "Development" tab, which is not present by default. Click on the File tab, then click on the option...

2024.05.28

Excel Macro (VBA)

Name a cell Excel

There are many times when you need to refer to a cell with coordinates such as "=A1" or "=C50". However, when you try to get the value from another sheet or another book, the coordinates are not always the same.

2024.09.17

Excel Functions

What is an Excel (Excel) Macro (VBA) Module and Procedure?

When dealing with VBA, you will come across terms such as modules and procedures, which are not used in everyday life. So, here I will explain about modules and procedures. Modules include standard modules, book modules, sheet modules, fo...

2023.12.27

Excel Macro (VBA)

Digital certificate can no longer be selected when logging in to a site (Edge)

Have you ever seen the following error message when using login with a digital certificate? The certificate you have selected is not available for this service. Please close all browser windows and try again. Internet ban...

2024.08.02

Edge

How to delete a sheet by specifying the sheet name VBA(Macro)Excel(Excel)

As the number of unneeded sheets grows, browsing becomes worse, and Excel itself becomes slower. In such cases, you can use VBA to automatically delete unnecessary sheets. In this article, we will show you how to use VBA to delete sheets at high speed...

2024.08.23

Excel Macro (VBA)

How to Convert Excel to Google Sheets (Step-by-Step Guide for 2025)

This is a detailed beginner's guide to the specific steps for converting an Excel file to a Google Spreadsheet. Are you having trouble when your clients ask you to submit your work in spreadsheet format? The author, who has experience in streamlining IT operations, will teach you how to do it.

2025.06.05

spreadsheet