Excel Functions

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)...

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...

QR codes are a very convenient way to tell someone a URL or email address, rather than a string of text. It is a very convenient tool because all the recipient has to do is read it. However, the only way to make them is to create and download them using free sites on the Internet...

Click here to see how to create a basic pull-down. Creating a Pull-Down (Drop-Down) in Excel If you try to select the name of a large number of enrolled employees from a pull-down, you will have a very large number of choices to choose from. So, you need to create a drop-down menu that allows you to select a department by...

When you want to display employee names in the pull-down menu as shown in the image above, it is very inconvenient if all employees are displayed, because it is too much to display and it is not clear who is in which department. In this case, I would like to select a department first, and then only the people in that department will be displayed in the employee name pull-down...

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...".