ReBizRU

How to Instantly Convert Address Numbers to Kanji Using SUBSTITUTE in Excel.

When printing addresses on envelopes using the address list of a New Year's card or a customer list, for example, horizontal envelopes are written in arithmetic (Arabic) numerals such as "1, 2, 3", while vertical envelopes must be written in Chinese numerals such as "1, 2, 3". Substitute the numbers...

2024.09.20

Excel Functions

Absolute and relative references in Excel (Excel)

Absolute and relative references are explained below. Relative reference: If you want to display the same contents in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3. If you want to display the same content in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3

2023.12.27

Excel Functions

How to Clear Sheet Data with Excel VBA: Simple Macro Tutorial for Beginners

Tired of manually deleting large amounts of Excel data? This article explains how to delete sheet data using VBA macros with ClearContents, Clear, and Delete—completing the task in seconds.

2025.06.18

Excel Macro (VBA)

The Complete Guide to IF AND in VBA｜Thorough explanation from basic syntax to practical techniques

I want to combine IF and AND statements in VBA, but I don't know how to write it..." I have experienced such a problem. Actually, the way to write it is a little different from the IF function in Excel. In my 20 years of Excel work, I have used IF AND in VBA to automate many tasks...

2025.02.12

Excel Macro (VBA)

How to use the Spill function Excel (Excel)

I had neglected the "spill" feature implemented in Microsoft365 and Excel2021 for a while because I didn't really understand it, but when I tried it, I found it to be very useful. I found it to be very useful. Moreover, I thought that I could do a lot of things by applying this function...

2024.07.04

Excel Functions

How to find function references with trace arrows Excel (Excel)

If you are confused about reference relationships in Excel functions, you have come to the right place! This article details how to find references using trace arrows. In fact, you can easily visualize the relationship between cells from the formula tab. This article will help you understand complex functions.

2025.06.06

Excel Functions

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

[For Beginners] Detailed explanation of how to easily operate Edge/Chrome with VBA (summary)

Mr. Sato, is there any good way to import Web information into Excel? Ms. Sato, a student in the Excel course, asked the question with an enthusiastic expression. Manager, that's right. Actually, you can easily get information on the Web magically by using VBA... I have 20 years of Excel experience...

2024.10.02

Excel Macro (VBA)

How to Insert Rows in Excel Without Breaking Formulas

Having trouble with broken formulas after inserting rows in Excel? This article explains step-by-step how to fix them easily using formula copying—shared by an experienced Excel expert.

2025.06.18

Excel Functions

Insert rows without breaking formulas (using spil) Excel (Excel)

With Microsoft365 and Excel 2021 or later versions, you can insert, delete, and rearrange rows without breaking the formula by using a feature called Spill. In this article, we will show you a specific example...

2024.09.13

Excel Functions