How to add diagonal line on active cell in Microsoft Excel
If you want to give attractive look or then you have to use diagonal line. It helps you to add diagonal line…
#Excel
189 postsHow to convert cell contents from General to Date format in Excel
If you fill any date in general format is not understandable by the Excel. Now, it convert cell contents from General to…
Add or insert leading zeros to text or numbers in MS Excel
If you need to add leading zero to a value then read this article to provide quick way to add or insert…
2 Ways to Fill blank cells with 0 or any specific value in Excel
During working on the large worksheet data with balnk cells, you will be able to easily and quickly fill blank cells with…
Automatically open a specific Excel file whenever you start Excel
Automatically open a specific Excel file whenever you start Excel allows you to customize how Excel starts or create a startup file…
Get the File Names from a Folder using Excel function
Excel has many useful tricks which is very useful for us. You can use given trick to get the file names from…
How to Filter Bold Cells Character Formatting in Excel
Find and Replace command allows you to apply bold formatting that can be filtered. Now you can use Filter bold cells character…
How to Apply Alternate Color Shading Between Rows in Excel
Conditional Formatting gives decorative look on active worksheet. This feature allows you to apply alternate color shading between rows.
3 Ways to find duplicate values on same worksheet – Excel
Excel allows you to search or find duplicate values on same worksheet. You can use given three methods to identify the duplicate…
How to Identifying Duplicate Values in two Excel worksheets
Excel allows you to quickly search duplicate values in Excel. You can use given ways to identifying duplicate values in two excel…