Excel Macro (VBA) How to install .NET FrameWork
What are the versions of the .NET Framework? NET Framework (DotNet Framework) comes in various versions (types of toolboxes) with slightly different tools inside...
Excel Macro (VBA) 
Excel Macro (VBA) 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".
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...
Excel Functions Name a cell Excel
There are many times when you need to refer to a cell with coordinates such as "=A1" or "=C50". However, when you try to get the value from another sheet or another book, the coordinates are not always the same.
Excel Functions Excel (Excel) Conditional Formatting Methods
Excel has a function to change the format according to cell values and various conditions. Here is an example of a specific setting. Suppose you have a simple table like the one below, and you want to shade in red the cells where no sales have been entered. First, select the range you want to format. Next, select "Home"...
Excel Macro (VBA) How to delete a sheet by specifying the sheet name VBA(Macro)Excel(Excel)
As the number of unneeded sheets grows, browsing becomes worse, and Excel itself becomes slower. In such cases, you can use VBA to automatically delete unnecessary sheets. In this article, we will show you how to use VBA to delete sheets at high speed...
Excel Macro (VBA) Get the path (save location) of the opened Excel file "Path" Excel Macro (VBA)
In many cases, it is useful to be able to get the location of the Excel file you are currently working on when you want 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 "Path" command, which is useful in such cases. The currently open Excel file...
Excel Functions Forgot Password] How to remove sheet protection Excel (Excel)
I have a "sheet-protected" Excel file that I really need to unprotect, but the person in charge of applying the protection has already left the company or lost the memo, and I don't know the password. In such cases, do I have no choice but to give up? No, you can...
spreadsheet 2 Easy Ways to Hide or Show Zero Values in Google Sheets
Looking to hide zero values in Google Sheets? This must-read guide explains two easy methods—using custom formatting and the IF function. Discover how to instantly clean up your tables and boost the visual quality of your documents. Would you like a slightly shorter or more technical variation as well?
Excel Functions How to Hide Sheet Tabs in Excel – Fast & Easy
A must for Excel system creators and those considering preventing erroneous operations. This article explains with images how to hide sheet headings to prevent unexpected operations. In fact, it can be achieved with only a simple option setting. This article will help you create safe Excel files.
English 
日本語