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 Macro (VBA) Color every other line alternately to make stripes When creating a table, it is possible to make the table very easy to read if each row is colored alternately and striped. In this issue, we will show you three ways to do this. How to use the table functionHow to set up a tableSelect a cell anywhere in the table you want to make a table and click "Insert... 2024.05.16 Excel Macro (VBA)Excel Functions
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
googlesheet 2 Easy Ways to Hide or Show Zero Values in Google Sheets Looking to hide zero values in Google Sheets? This must-read guide explains two easy methods—using custom formatting and the IF function. Discover how to instantly clean up your tables and boost the visual quality of your documents. Would you like a slightly shorter or more technical variation as well? 2025.06.18 googlesheet
Excel Functions How to correct "###" in cell display Excel (Excel) When dealing with numbers in Excel, it often happens that the sharpness of the numbers becomes "######" as shown in the title, and the value becomes unreadable. The conclusion is that the reason for the "#####" is that the length of the value is larger than the size of the cell, making it impossible to display... 2024.06.05 Excel Functions
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... 2024.05.16 Excel Functions
Excel Functions Find Out Which Version of Excel You’re Using – Quick Steps The functions and functions that can be used may change depending on the version of Excel. You should be able to check if your version is supported when errors or problems occur, so we will show you how to check your Excel version in this issue. Acau... 2024.06.05 Excel Functions
Excel Functions How to find function references with trace arrows Excel (Excel) If you are confused about reference relationships in Excel functions, you have come to the right place! This article details how to find references using trace arrows. In fact, you can easily visualize the relationship between cells from the formula tab. This article will help you understand complex functions. 2025.06.06 Excel Functions
Excel Functions SUMIF and SUMIFS Functions Excel The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF... 2024.07.04 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)