Actually,printing document is the result of your work. With excel, you can print the entire work sheet, specific area you need on a work sheet, multiple sheets, or all sheets. If you are new member, may be you do not know how to print it. So, today, I will guide to you how to print […]
excel tips
2 ways to convert comma to dot in excel
Data entered in Excel will automatically be separated by dots or commas. Users can use those to separate units in the sequence more clearly. However, if in a document the unit separator is not uniform, you need to switch back to the same type of sign. The following article will guide you how to convert […]
change cell background color in excel by equal formulas
In this article, I will show you how to change cell background color automatically in excel with Conditional Formatting tool. Conditional formatting: Easily spot trends and patterns in your data using bars, color, and icons to visually highlight important values. When working in Excel, have you ever faced with complicated and sometimes repeated data? A […]
How to insert header and footer in excel?
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 […]
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 […]