ReBizRU

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

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)

How to Instantly Convert Address Numbers to Kanji Using SUBSTITUTE in Excel.

When printing addresses on envelopes using the address list of a New Year's card or a customer list, for example, horizontal envelopes are written in arithmetic (Arabic) numerals such as "1, 2, 3", while vertical envelopes must be written in Chinese numerals such as "1, 2, 3". Substitute the numbers...

2024.09.20

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

Macro suddenly stopped working Excel(Excel) Macro(VBA)

I have been experiencing a phenomenon around me where macros suddenly stop working after having been used normally until yesterday. The phenomenon is that I had set up a macro that is activated by double-clicking on a specific cell, but it no longer responds when double-clicked. I went to "Develop..." to check the contents of the macro.

2024.02.26

Excel Macro (VBA)

The two reasons for garbled csv files and how to fix them [Thorough explanation by an Excel master] Windows version.

"Huh? What is this?" Have you ever opened a CSV file in Excel only to find that the text in the file is a series of unintelligible symbols? Yes, you are now facing a troublesome problem called "garbled characters," which is a common problem that many people suffer from...

2024.09.12

Excel Functions

Excel (Excel) to automatically create a backup file every time you save

Here is how to automatically create a backup file every time you save Excel. Display the General Options screen First, display the "Save As" screen. On the Excel screen, click the "File" tab, then click "Save As," then click "So...

2024.01.10

Excel Functions

How to Change Digital Certificate Display Names in Microsoft Edge for Easy Identification

How to Change Digital Certificate Names in Edge | Stop Certificate Confusion. Set friendly names for easy identification. Step-by-step guide to distinguish multiple certificates in Microsoft Edge browser.

2025.07.03

Edge

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

Specific ways to present Excel skills that are useful in job interviews.

You use Excel in your daily work. But are those skills that allow you to say, "I'm good at Excel," really applicable in the job market? Many of us learn the basics of Excel in new employee training and use it in our daily work. Sure, we enter formulas, create graphs...

2024.09.29

change of occupation