When you enter data in cells in Excel, you will see line around those cells. They are designed to make it easier for users to work. If you do not have a border, you will not see the lines when print your page, you just only see data you have entered. This brings unprofessional for […]
excel tutorial
How to add leading zeros in excel
In excel, if you type a number as 01234, it will show 1234 immediately, this is default setting of excel. How to keep it? There are many ways to add leading zeros in excel. If you read this post, I think you will find the best way to do it. I. Keep leading zeros in […]
Create random number in excel
Have you need random data for test? I usually use random data for excel function test. You can create random number in excel very easily and simple. In this tutorial, we will create random number in excel by Rand and Ranbetween command. I. Create random number with rand() command. Rand() command will give us random […]