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. 2025.06.18 Excel Functions
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, , ) 2024.07.27 Excel Functions
Excel Functions Allows you to see the address where the book is saved Excel (Excel) You can display the path in the toolbar so that you can always see the address where you saved your Excel book. We will show you how to do this in this article. Click on the "File" tab, click on "Options", click on "Quick Access Toolbar" > "All...", and then click on "Quick Access Toolbar" > "Quick Access Toolbar" > "All...". 2024.05.16 Excel Functions
Excel Functions How to Fix Missing Sheets in Excel (Step-by-Step Guide) This article explains how to solve the sheet heading hiding problem in Excel from the options settings. Have you ever had trouble finding a sheet in a file created by someone else? This article is written by the author, who has experience in supporting Excel operations. 2025.06.06 Excel Functions
Excel Macro (VBA) What is an Excel (Excel) Macro (VBA) Module and Procedure? When dealing with VBA, you will come across terms such as modules and procedures, which are not used in everyday life. So, here I will explain about modules and procedures. Modules include standard modules, book modules, sheet modules, fo... 2023.12.27 Excel Macro (VBA)
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? 2024.06.05 Excel Functions
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)... 2025.05.29 Excel Functions
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. 2025.05.30 Excel Macro (VBA)
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... 2024.07.03 Excel Functions
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... 2024.05.30 Excel Macro (VBA)