When you copy or input a url or an email address text into 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 provide filter function for you to find out required rows by customized condition in a very long excel worksheet. The filter feature include basic filter which provide simple condition filtering and advanced filter which provide complex condition filtering. This article will show you both 2 filter feature with example.
Excel provide an autorecover 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 generate a column chart ( bar chart ) in excel based on multiple excel cell data. 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 and column color and …
How To Quickly Generate Excel Column Chart Based On Cell Data Read More »
Some times you may want to verify user input data type or value in excel cell. And excel just provide such feature for you to customize the cell data validation process. You can define which data type and what data value are valid for one or multiple excel cell. 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 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 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 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 som 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 »
