Excel Functions Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel)
この記事ではExcelで2つのプルダウンを連動させる方法を解説します。部署選択後に該当社員のみ表示したいけど作り方が分からず悩んでいませんか？実はINDEX関数とMATCH関数で簡単に連動可能。Excel専門家が伝授します。
Excel Functions 
Excel Functions Excel RIGHT and LEFT functions to extract a specific number of characters from the right or left of a string
I want to display only the four characters from the right of the data entered in a cell, or I want to display the rest of the data without displaying the left few characters. Conversely, I want to display only 4 characters from the left of the data entered in a cell, or I want to display the rest of the data without displaying the few characters on the right. Thus...
Excel Macro (VBA) 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...
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) How to use the method of variable type "Workbook" Excel (Excel) Macro (VBA)
You can read more about how to use the variable type "Workbook" in this blog. How to use the variable type "Workbook" Excel(Excel)Macro(VBA)Here we will explain the "Workbook" method in a little more detail.Wor...
Excel Macro (VBA) VBA "Overflow occurred." Error cause and remedy (runtime error '6′:)
Cause of ErrorThis error occurs when the data type is not in a format that can be handled, or when the data type exceeds the range of numbers that can be handled. First, let's reproduce the error. As shown in the figure above, we have set up the code to copy the numeric value in cell "B3" to cell "B4".
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.
Excel Functions Excel to allow entry of items not in the pull-down (drop-down) list
When using the pull-down entry function in Excel with the default settings, if you try to enter an item that is not in the list prepared for entry, an error message like the one shown below will appear and you will not be able to enter the item. In such a case, you can either allow any item to be entered, or display a message...
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 
日本語