Excel Macro (VBA) How to Find the Last Row in Excel Using VBA (Macro Guide for Beginners)
We show you how to search through the data from the top down, and how to start from the bottom row of the Excel file and work your way up.
Excel Macro (VBA) 
Excel Functions How to Adjust Column Width and Row Height in Excel (Manual Methods Explained)
Visibility is very poor if the column widths are too narrow to display all of the cell contents, or the row height is too narrow to display the contents. In this article, we will explain how to easily and automatically adjust row height and column width to just the right size. With a macro (VBA)...
Excel Macro (VBA) How to display the Immediate Window Excel(Excel) Macro(VBA)
One of the skills that you will need to learn as you progress in your VBA studies is the skill of using Immediate Windows. To use it, you must first display the Immediate Window. In this article, we will explain how to display the Immediate Window...
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 Functions Linking two pull-downs (drop-downs) without macros (when reflected in multiple rows) Excel (Excel)
Excel複数行連動プルダウンを作りたい人は必見！この記事ではマクロなしで複数行のドロップダウンを連動させる方法を詳しく解説します。実はINDIRECT関数と名前定義で簡単に実現できるんです。この記事を読めば効率的な一覧表が作れます。
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.
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.
googlesheet How to Convert Excel to Google Sheets (Step-by-Step Guide for 2025)
This article provides a detailed, beginner-friendly explanation of how to convert Excel files into Google Sheets. Are you struggling because a client has asked you to submit your data in Google Sheets format? The truth is, the conversion process is easier than you might think. Written by someone with experience in streamlining IT workflows, this guide walks you through the steps clearly and practically.
Excel Functions Automatically create invoices from sales invoices1 Excel (Excel)
There are many useful software systems that automatically output invoices as you record sales data if you pay for them, but many people are unable to install software because they "don't have enough money to pay for it" or "management won't allow it" and are making each invoice by hand...
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?
English 
日本語