ReBizRU

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

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

How to extract characters before a specific character "LEFT and FIND functions in Excel"

As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))

2025.02.19

Excel Functions

Get the full path (save location and file name) of the opened Excel file "FullName" Excel (Excel) Macro (VBA)

There are many situations where it is useful to be able to retrieve the location of the Excel file you are currently operating on when you are trying 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 "FullName" command, which is useful in such cases. The currently open...

2024.05.30

Excel Macro (VBA)

VBA "Overflow occurred." Error cause and remedy (runtime error '6′:)

Cause of ErrorThis error occurs when the data type is not in a format that can be handled, or when the data type exceeds the range of numbers that can be handled. First, let's reproduce the error. As shown in the figure above, we have set up the code to copy the numeric value in cell "B3" to cell "B4".

2024.10.10

Excel Macro (VBA)

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

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

How to Disable the Copilot Icon in Excel (4 Simple Ways)

Many of you may have recently started seeing a "Copilot" icon like the one above in Excel. Copilot has many convenient features, but it can be annoying when it constantly pops up every time you select a cell. So, this time...

2026.07.07

Excel Functions

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

How to install .NET FrameWork

What are the versions of the .NET Framework? NET Framework (DotNet Framework) comes in various versions (types of toolboxes) with slightly different tools inside...

2024.10.01

Excel Macro (VBA)