Excel Macro (VBA) How to use the variable type "Workbook" Excel(Excel) Macro(VBA) For other variable types, please refer to Excel (Excel) Macro (VBA) about variable types. First, we will explain the basic usage of the variable type "Workbook". 2024.06.14 Excel Macro (VBA)
Excel Functions Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel) この記事ではExcelで2つのプルダウンを連動させる方法を解説します。部署選択後に該当社員のみ表示したいけど作り方が分からず悩んでいませんか?実はINDEX関数とMATCH関数で簡単に連動可能。Excel専門家が伝授します。 2025.06.09 Excel Functions
Excel Macro (VBA) How to Auto-Resize Excel Columns and Rows with VBA Macros (Copy-Paste Ready) Struggling with cell misalignment or manual resizing in Excel? This article shows how to efficiently adjust row height and column width using VBA—solved in just a few lines of code by a seasoned macro expert. 2025.06.27 Excel Macro (VBA)
Excel Functions For beginners] Explanation of causes of Excel being slow and countermeasures. Manager, have you ever felt 'kind of heavy' when using Excel? Student Yes, sir! I recently started using Excel to improve my business, but I'm having trouble opening files because it takes so long. ManagerYes, that's right. Many people have the same problem... 2024.10.02 Excel Functions
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... 2024.08.02 Edge
Edge How to Install EdgeDriver for Selenium (Beginner’s Step-by-Step Guide) This article details the installation procedure of EdgeDriver for beginners.Do you want to start web automation with VBA but don't know how to set it up? In fact, it can be easily installed in 3 steps, which will be taught by an Excel operation professional. 2025.07.12 EdgeExcel 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 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 How to display time in 15-minute increments (CEILING and FLOOR functions) Excel In the last issue, we introduced how to use the TIME function to display the time in 15-minute increments, 30-minute increments, etc. (TIME function) Excel pointed out that it would be easier to use the CEILING and FLOOR functions... 2024.06.18 Excel Functions
Excel Functions Auto-filter cuts out in the middle, how to fix Excel (Excel) Have you ever had a situation where you applied an auto-filter and found that the auto-filter was only working on the 20th row, even though data was included up to the 100th row? In this article, we will introduce what you should check when you encounter such a situation. Auto filter aperture... 2024.06.14 Excel Functions