ReBizRU

How to use the input screen "InputBox" Excel Macro (VBA)

If you want to use values or arbitrary characters that do not exist in Excel, the "InputBox" is useful to easily create an input screen during macro execution. In this article, we will briefly explain how to use this "InputBox".

2025.02.21

Excel Macro (VBA)

How to Disable the Copilot Icon in Excel (4 Simple Ways)

最近Excelで上図のような「Copilot」マークが表示されるようになった方も多くなってきているのではないでしょうか。便利な機能もたくさんあるCopilotですが、セルを選択すると常に出てくるというのはさすがに邪魔な時もあります。そこで今...

2025.07.12

Excel Functions

[For Beginners] Step-by-Step Guide to Installing SeleniumBasic

This article offers a beginner-friendly, detailed guide to installing SeleniumBasic. Stuck on the installation and thinking about giving up on automation? The truth is, anyone can install it by taking it one step at a time. A professional with 20 years of experience teaching Excel will walk you through the process.

2025.06.16

Excel Macro (VBA)

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

How to apply mosaic (blur) Excel

When you are preparing a document or manual for external publication, you may need to refer to a web site or a screen where non-public information is visible. In such a case, you would like to put a mosaic like this on the non-public part. We will explain this method in detail in this issue...

2024.07.05

Excel Functions

How to Enable Excel Macros: Fix 'Macro Has Been Blocked' Error Safely

If you are having trouble running Excel macros, you have come to the right place. This article explains how to solve the red band message that appears in version 2203 and later. Actually, it can be easily solved by file saving and property settings. This article will help you solve the macro block problem completely.　

2025.06.12

WindowsExcel Macro (VBA)

How to Extract Data Using the VLOOKUP Function in Excel

Being able to use the VLOOKUP function will expand the range of data handling, and will help you be seen as an intermediate Excel user by beginners. In this article, we will show you how to use the VLOOKUP function, and how to use the INDEX and MATCH functions to compensate for the weaknesses of the VLOOKUP function...

2024.07.04

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)

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

Excel: Color Cells When Input Doesn’t Match Dropdown List

In this article, you'll learn how to use conditional formatting in Excel to automatically change cell colors when a value entered doesn't match the dropdown list. If you've been struggling with errors during data aggregation using the VLOOKUP function, you're not alone. Fortunately, combining the MATCH and ISNA functions offers a simple and effective solution.

2025.06.11

Excel Functions