Excel Macro (VBA) "How to Create Your First Excel Macro (Beginner’s VBA Guide)
To write a VBA, you start with the "Development" tab, which is not present by default. Click on the File tab, then click on the option...
Excel Macro (VBA) 
googlesheet 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 What does the error message "#NAME?
Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. Here are the meanings and countermeasures for this error message. Meaning of "#NAME?
Excel Macro (VBA) How to Disable Automatic Calculation in Excel VBA to Speed Up Your Macros
Learn how to disable automatic calculation in Excel VBA to dramatically speed up your macros. Simple code examples and performance tips included. Boost your Excel automation today!
Excel Functions 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 "...
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.
Excel Functions Top 4 Ways to Write Vertically in Excel: Features, Pros, and Best Use Cases
Excel is normally designed to be written horizontally, but it can also be written vertically. There are several ways to do this, but in this article, we will introduce four methods, two using "cell formatting" and two using "text boxes. Using "Vertical Writing" Cell Formatting1....
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...
Excel Functions The two reasons for garbled csv files and how to fix them [Thorough explanation by an Excel master] Windows version.
"Huh? What is this?" Have you ever opened a CSV file in Excel only to find that the text in the file is a series of unintelligible symbols? Yes, you are now facing a troublesome problem called "garbled characters," which is a common problem that many people suffer from...
Excel Macro (VBA) How to Auto-Resize Excel Columns and Rows with VBA Macros (Copy-Paste Ready)
Struggling with cell misalignment or manual resizing in Excel? This article shows how to efficiently adjust row height and column width using VBA—solved in just a few lines of code by a seasoned macro expert.
English 
日本語