Excel Functions Linking two pull-downs (drop-downs) without macros (when reflected in multiple rows) Excel (Excel)
Excel複数行連動プルダウンを作りたい人は必見！この記事ではマクロなしで複数行のドロップダウンを連動させる方法を詳しく解説します。実はINDIRECT関数と名前定義で簡単に実現できるんです。この記事を読めば効率的な一覧表が作れます。
Excel Functions 
Excel Functions How to use the Spill function Excel (Excel)
I had neglected the "spill" feature implemented in Microsoft365 and Excel2021 for a while because I didn't really understand it, but when I tried it, I found it to be very useful. I found it to be very useful. Moreover, I thought that I could do a lot of things by applying this function...
Windows How to display file extensions [Windows 11].
For the beginning computer user, there may be little trouble with file extensions not being displayed. However, once you have started to tinker with computers to some extent, there are situations where you may need to change the file extension or process a file differently depending on its extension, so this...
Excel Macro (VBA) Get the path (save location) of the opened Excel file "Path" Excel Macro (VBA)
In many cases, it is useful to be able to get the location of the Excel file you are currently working on when you want to retrieve values from another Excel file or save a file as a name using a macro. In this article, we will show you how to use the "Path" command, which is useful in such cases. The currently open Excel file...
Edge Digital certificate can no longer be selected when logging in to a site (Edge)
Have you ever seen the following error message when using login with a digital certificate? The certificate you have selected is not available for this service. Please close all browser windows and try again. Internet ban...
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 Functions How to Extract Text After a Specific Character in Excel Using RIGHT and FIND
Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert.
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 Functions How to paste Excel (Excel) images
There are functions to do various things with images, such as sticking an image on Excel or fitting an image into a cell. In this article, we will introduce two ways to import images into Excel. Place the image on top of a cellOnce you save the image to a folder somewhere on your terminal, you can use this method...
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...
English 
日本語