Excel Tutorial

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 »

Sometimes you need to know which bit-version dose your installed Microsoft office software is, then you can download and install additional software such as office language package according to your current office software bit version. In this article, I will tell you how to check whether your installed office software is a 32-bit or 64-bit …

How To Check MS Office Is 32 Or 64 Bit Version Read More »