ReBizRU

Locking cells to protect only a specific range of sheets Excel (Excel)

When using the sheet protection function, there is a function that allows detailed usage such as "allow selection and input in this range of cells, but not in other cells". For example, let's say you have a system that automatically creates transfer data when you enter a company name and amount of money as shown below. In this example...

2024.10.08

Excel Functions

How to correct "###" in cell display Excel (Excel)

When dealing with numbers in Excel, it often happens that the sharpness of the numbers becomes "######" as shown in the title, and the value becomes unreadable. The conclusion is that the reason for the "#####" is that the length of the value is larger than the size of the cell, making it impossible to display...

2024.06.05

Excel Functions

Error display "#DIV/0!" Meaning and Countermeasures Excel

Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. If you know the meaning of the error and what to do about it, there is nothing to be afraid of. Meaning of "#DIV/0!

2024.05.30

Excel Functions

Easy with Excel and Word! Mastering the art of address printing that anyone can do!

Have you ever had to worry about writing addresses for New Year's cards and summer greeting cards? Writing dozens of cards by hand is a lot of work, but buying specialized software is also a bit expensive.... Everyone has experienced this dilemma at least once. But the truth is, your computer...

2024.09.22

Excel Functions

How to Adjust Column Width and Row Height in Excel (Manual Methods Explained)

Visibility is very poor if the column widths are too narrow to display all of the cell contents, or the row height is too narrow to display the contents. In this article, we will explain how to easily and automatically adjust row height and column width to just the right size. With a macro (VBA)...

2025.05.29

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 pass arguments between procedures ByRef,ByVal Excel(Excel) Macro(VBA)

This section describes how to pass arguments when procedures are separated. In the article below, I mentioned that it is easier to read and process the code by separating the procedures...

2023.12.27

Excel Macro (VBA)

Auto-filter cuts out in the middle, how to fix Excel (Excel)

Have you ever had a situation where you applied an auto-filter and found that the auto-filter was only working on the 20th row, even though data was included up to the 100th row? In this article, we will introduce what you should check when you encounter such a situation. Auto filter aperture...

2024.06.14

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

Allows you to see the address where the book is saved Excel (Excel)

You can display the path in the toolbar so that you can always see the address where you saved your Excel book. We will show you how to do this in this article. Click on the "File" tab, click on "Options", click on "Quick Access Toolbar" > "All...", and then click on "Quick Access Toolbar" > "Quick Access Toolbar" > "All...".

2024.05.16

Excel Functions