Excel Functions Linking two pull-downs (drop-downs) without macros (when reflected in multiple rows) Excel (Excel)
Excel複数行連動プルダウンを作りたい人は必見！この記事ではマクロなしで複数行のドロップダウンを連動させる方法を詳しく解説します。実はINDIRECT関数と名前定義で簡単に実現できるんです。この記事を読めば効率的な一覧表が作れます。
Excel Functions 
Excel Functions Insert rows without breaking formulas (using spil) Excel (Excel)
With Microsoft365 and Excel 2021 or later versions, you can insert, delete, and rearrange rows without breaking the formula by using a feature called Spill. In this article, we will show you a specific example...
Excel Macro (VBA) [For Beginners] Step-by-Step Guide to Installing SeleniumBasic
This article offers a beginner-friendly, detailed guide to installing SeleniumBasic. Stuck on the installation and thinking about giving up on automation? The truth is, anyone can install it by taking it one step at a time. A professional with 20 years of experience teaching Excel will walk you through the process.
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 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 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 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!
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 How to Round Time to 15-Minute Intervals in Excel (Easy Formula Guide)
Struggling with time rounding in Excel? This guide shows you how to combine TIME and ROUND functions effectively. Simple techniques that boost productivity. Master time rounding calculations with ease.
Excel Functions Creating a QR Code in Excel (Excel)
QR codes are a very convenient way to tell someone a URL or email address, rather than a string of text. It is a very convenient tool because all the recipient has to do is read it. However, the only way to make them is to create and download them using free sites on the Internet...
English 
日本語