Excel Tutorial

When you copy or input a url or an email address text into the excel cell, it will add a hyperlink automatically. Sometimes this is useful, but for most times this is not useful at all. This article will tell you how to remove the hyperlink and how to disable auto hyperlinking in excel settings.

Microsoft Excel provides a filter function for you to find out required rows by the customized condition in a very long excel worksheet. The filter feature includes a basic filter that provides simple condition filtering and an advanced filter that provides complex condition filtering. This article will show you both the 2 filter features with …

How To Filter Excel Rows By Multiple Customized Condition Read More »

Excel provides an auto recover unsaved workbook feature for you to recover the unsaved excel workbook. This feature is very useful. It can save you a lot of time when you exit Excel without saving the workbook changes. This article will tell you how to use it.

In this article, I will tell you how to insert a column chart ( bar chart ) in excel based on multiple excel cell data in an excel worksheet. You can customize the column chart Chart Title, Axes, Axis Titles, Data Labels, Data Table, Legend, Trend Lines, etc. You can also customize the chart style …

How To Insert Chart In Excel Read More »

Sometimes you may want to verify user input data type or value in excel cell. And excel just provide such a feature for you to customize the cell data validation process. You can define which data type and what data values are valid for one or multiple excel cells. If the data is not valid, …

How To Create Error Message Pop-Up Alert When User Input Wrong Data In Excel Read More »

In this article, I will show you how to make an excel cell expand it’s width and height to fit the input text width or height automatically.

In this article, I will tell you how to wrap text in an excel cell manually and automatically when you input longer text in the excel worksheet cell.

There are three ways to adjust excel worksheet row height and column width as below. I will tell you how to do it one by one with an example in this article. Adjust it by hand. Adjust it by ribbon menu item. Adjust it by popup menu item.

Protecting an excel workbook/worksheet refers to setting the workbook/worksheet in a protected state to prohibit others from accessing, modifying, or viewing. This article will tell you how to protect an excel workbook/worksheet step by step.

My excel display language is Chinese by default, but for some reason, I need to change the excel display language to English. This article will tell you how to change the excel display and editing language, and after that, you will find the whole office software display and editing language has all been changed as …

How To Change Microsoft Office ( Word, Excel etc ) Display And Editing Language Read More »