Excel Functions Linking two pull-downs (drop-downs) without macros (when reflected in multiple rows) Excel (Excel)
Excel複数行連動プルダウンを作りたい人は必見！この記事ではマクロなしで複数行のドロップダウンを連動させる方法を詳しく解説します。実はINDIRECT関数と名前定義で簡単に実現できるんです。この記事を読めば効率的な一覧表が作れます。
Excel Functions 
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"...
Edge How to Change Digital Certificate Display Names in Microsoft Edge for Easy Identification
How to Change Digital Certificate Names in Edge | Stop Certificate Confusion. Set friendly names for easy identification. Step-by-step guide to distinguish multiple certificates in Microsoft Edge browser.
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...
Edge Excel Clipboard Error: “The content cannot be copied because it is being used by another application” — Symptoms and Quick Fixes
Frustrated by the "File is in use by another application" error during copy and paste? This article provides a detailed explanation of the issue along with both quick fixes and long-term solutions to resolve it effectively.
Excel Functions How to use Excel (Excel) INDEX and MATCH functions in combination
We will show you how to display the desired data by combining the INDEX function, which refers to data from a table on another sheet, and the MATCH function. How to Write the INDEX Function There are two ways to write the INDEX function. INDEX(array, row number,) INDEX(reference, row number, , )
Excel Functions How to extract characters before a specific character "LEFT and FIND functions in Excel"
As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))
Excel Functions Automatically create invoices from sales invoices 2 Excel (Excel)
Creating Invoices Automatically from Previous Sales Statements1 Continuing from Excel (Excel), we will create an invoice. Putting the details on the invoice (using a function)*Using the "FILTER" function using Spil*This one uses the Spil function, so you will need to use Microsoft365 or E...
Excel Macro (VBA) PrintOut" printer and automatic printing Excel(Excel) macro(VBA)
Have you ever had the experience of printing the same Excel file every time, only to have to set it up again and again? Have you ever had such an experience? Many people spend a lot of time on Excel printing. Especially in an environment where multiple printers are used, it is a big hassle to change print settings...
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...
English 
日本語