ReBizRU

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 set and remove sheet and book protection Excel (Excel)

If you are thinking about preventing Excel mishaps, this is a must! This article details how to set up and remove sheet and book protection. In fact, you can easily set it with a password. This article will help you protect your important data.

2025.06.06

Excel Functions

Measure macro processing time Excel(Excel) Macro(VBA)

When trying to speed up a macro, it is first necessary to be able to determine how much time was saved before and after the improvement, and how much time was saved or not. To do this, it is necessary to be able to measure the time. In this article, we will show you how to do this. In this article, we will discuss the process of...

2024.01.03

Excel Macro (VBA)

Get the full path (save location and file name) of the opened Excel file "FullName" Excel (Excel) Macro (VBA)

There are many situations where it is useful to be able to retrieve the location of the Excel file you are currently operating on when you are trying to retrieve values from another Excel file or save a file as a name using a macro. In this article, we will show you how to use the "FullName" command, which is useful in such cases. The currently open...

2024.05.30

Excel Macro (VBA)

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

Mr. Sato, teacher, 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 set up read-only and password Excel (Excel)

Here is how to set Excel to read-only or set a password when opening. Display the General Options screen First, display the "Save As" screen. On the Excel screen, click the "File" tab, then click "Save As," then click "...

2024.01.10

Excel Functions

How to use the variable type "Workbook" Excel(Excel) Macro(VBA)

For other variable types, please refer to Excel (Excel) Macro (VBA) about variable types. First, we will explain the basic usage of the variable type "Workbook".

2024.06.14

Excel Macro (VBA)

Automatically create invoices from sales invoices 2 Excel (Excel)

Creating Invoices Automatically from Previous Sales Statements1 Continuing from Excel (Excel), we will create an invoice. Putting the details on the invoice (using a function)*Using the "FILTER" function using Spil*This one uses the Spil function, so you will need to use Microsoft365 or E...

2024.06.10

Excel FunctionsLet's make an invoice from a sales invoice.

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

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

2025.07.12

Excel Functions

3 Easy Ways to Hide or Show Zero Values in Excel: Simple Formatting Tips

As shown in the figure below, when "A1" cell contains 150 and "A2" cell also contains the same number, 150, the calculation result of "=A1-A2" is "0" zero. There are three ways to avoid displaying numbers when the result of the calculation is "0" zero. The result of the calculation is "0" zero...

2024.10.29

Excel Functions