ReBizRU

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

Macro suddenly stopped working Excel(Excel) Macro(VBA)

I have been experiencing a phenomenon around me where macros suddenly stop working after having been used normally until yesterday. The phenomenon is that I had set up a macro that is activated by double-clicking on a specific cell, but it no longer responds when double-clicked. I went to "Develop..." to check the contents of the macro.

2024.02.26

Excel Macro (VBA)

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)

Automatically create invoices from sales invoices3 Excel (Excel)

Continuing from the previous article, "Creating Invoices Automatically from Sales Statements 2: Excel," we will now move on to creating invoices. If you haven't read it yet, please also read "Creating Invoices Automatically from Sales Statements 1: Excel". Putting details on an invoice (using a macro)...

2024.05.16

Excel Macro (VBA)Let's make an invoice from a sales invoice.

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 Extract Text After a Specific Character in Excel Using RIGHT and FIND

Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert.

2025.06.18

Excel Functions

Color every other line alternately to make stripes.

When creating a table, it is possible to make the table very easy to read if each row is colored alternately and striped. In this issue, we will show you three ways to do this. How to use the table functionHow to set up a tableSelect a cell anywhere in the table you want to make a table and click "Insert...

2024.05.16

Excel Macro (VBA)Excel Functions

Fix Excel Clipboard Error: 'The Clipboard Cannot Be Emptied' or 'In Use by Another Application'

Frustrated by the "File is in use by another application" error during copy and paste? This article provides a detailed explanation of the issue along with both quick fixes and long-term solutions to resolve it effectively.

2025.06.18

EdgeExcel Functions

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 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)