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 Top 4 Ways to Write Vertically in Excel: Features, Pros, and Best Use Cases
Excel is normally designed to be written horizontally, but it can also be written vertically. There are several ways to do this, but in this article, we will introduce four methods, two using "cell formatting" and two using "text boxes. Using "Vertical Writing" Cell Formatting1....
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...
Excel Functions Locking cells to protect only a specific range of sheets Excel (Excel)
When using the sheet protection function, there is a function that allows detailed usage such as "allow selection and input in this range of cells, but not in other cells". For example, let's say you have a system that automatically creates transfer data when you enter a company name and amount of money as shown below. In this example...
Excel Functions How to set up a link by inserting a hyperlink Excel (Excel)
Here is how to set up a hyperlink using the Insert Hyperlink function. For example, let's say you have created a document with a table of contents as shown below, which jumps to a cell within the page. Let's say you have created a page with a table of contents as shown in the figure below, and when you click on the name of an item in the table of contents, you will jump to that item. First, let's create a page with a hyperlink to a cell in the page...
Excel Macro (VBA) Automatically create invoices from sales invoices3 Excel (Excel)
Continuing from the previous article, "Creating Invoices Automatically from Sales Statements 2: Excel," we will now move on to creating invoices. If you haven't read it yet, please also read "Creating Invoices Automatically from Sales Statements 1: Excel". Putting details on an invoice (using a macro)...
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 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 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...
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.
English 
日本語