Here is the UDF to Convert Numbers to Words in Hindi Language. This can be extended for other Languages as well with little modifications, do let me know your thoughts in comments. How to create the function Called SpellNumber() 1) Start Microsoft Excel. 2) Press ALT+F11 to start the Visual Basic Editor. 3) On the […]
VLOOKUP is my first love of Excel, it is great function to get the corresponding values from a table easily, however there is situation where we might want to get the cell color and font color along with lookup value. VLOOKUP is a function which will return only values, but not the cell formats. Thankfully Excel allows […]
Problem Statement: Is there a way to display complete path of the document and not just the file name in the Excel title bar ? e.g. I would like to see C:\MyExcelFiles\MonthlyBudget.xlsx in Excel title bar instead of just MonthlyBudget.xlsx In Excel, there is no setting/straight way for us to display the full path in […]
At times you may want to select the cells that have specified type of data in it, by which you can distinguish between cells that contain different types of data, which allows you to delete, fill or lock cells by the data type for various other reasons.
Bonus Tip: How to use formulas to highlight the cells that only contain Text, Number or Errors
You can use conditional formatting to format or color the cells based on their contents. For example, you have a cell to turn red when it contains text ‘No’ or a value less than 90%. But how do you highlight an entire row? When a cell contain specified content.
This tutorial will help you learn how to highlight other cells based on a cell’s value? To see how this was done, read on.
Three tips that will help you to reset Excel’s default formatting. Set them once, and never again
It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate rows.
This page describes the Conditional Formatting tool. Use Excel conditional formatting to color rows, hide duplicates, highlight items or hide errors.
From mapping to specialized charting to invoice generation, these apps provide extra features within Excel 2013.
Your worksheets will be more polished and easy to read if you learn a few sophisticated formatting techniques.