excel tips

If your task is to get Excel count and color blank cells in your worksheet, read this article to find the way to accomplish it. Learn how to count empty cells with Count Blank in Excel 2016,2013,2010,2019. I. How to count blank cells in excel? Step 1: Open the spreadsheet in Excel. Step 2: Use […]

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 […]

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 […]

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 […]

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 […]

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 […]