Header and Footer in excel are similar to headers and footers in word or in power point. It is a piece of text, images, special objects (page number, current time….) that are repeated on the sheets. The only difference is in the insertion steps, if in word it is on the Insert tab…in excel it […]
excel tutorial
2 ways to create border in excel
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 […]
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 […]