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) 
Excel Functions Excel (Excel) to automatically create a backup file every time you save
Here is how to automatically create a backup file every time you save Excel. 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 "So...
Excel Functions Find Out Which Version of Excel You’re Using – Quick Steps
The functions and functions that can be used may change depending on the version of Excel. You should be able to check if your version is supported when errors or problems occur, so we will show you how to check your Excel version in this issue. Acau...
Excel Macro (VBA) How to Clear Sheet Data with Excel VBA: Simple Macro Tutorial for Beginners
Tired of manually deleting large amounts of Excel data? This article explains how to delete sheet data using VBA macros with ClearContents, Clear, and Delete—completing the task in seconds.
Excel Functions What does the error message "#VALUE!" mean and what can I do about it?
Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. Here are the meanings and countermeasures for these errors. As an example of preconditions, let's make a table like this...
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 Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel)
この記事ではExcelで2つのプルダウンを連動させる方法を解説します。部署選択後に該当社員のみ表示したいけど作り方が分からず悩んでいませんか？実はINDEX関数とMATCH関数で簡単に連動可能。Excel専門家が伝授します。
Excel Functions How to Insert Rows in Excel Without Breaking Formulas
Having trouble with broken formulas after inserting rows in Excel? This article explains step-by-step how to fix them easily using formula copying—shared by an experienced Excel expert.
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...
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...
English 
日本語