When using the pull-down entry function in Excel with the default settings, if you try to enter an item that is not in the list prepared for entry, an error message like the one shown below will appear and you will not be able to enter the item. In such a case, you can either allow any item to be entered, or display a message...

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

Master the wavy line technique to compress images in Excel! Step-by-step tutorial showing how to create professional image breaks and save space in your spreadsheets and presentations.

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

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