Tag Archives: how to
How to limit entries to numeric value in Microsoft Excel ?
There are times when you might want to control what data the user can enter to a cell. For example , you want the user to enter only a numeric value that is greater than 75. How to limit entries to n...
Finding the nearest value in Microsoft Excel
Assume that you have a range of numbers in a column and you are required to find out the nearest value or the closest value to the specified number from the range. How to find the nearest value in Mi...
How to get the Created Time and Last Modified Time of your Excel Workb...
Do you want to retreive the created time and the last modified time of your Excel workbook and display it in the excel sheet ? Here’s a code snippet demonstrating how you can display them in th...
Removing Non numeric characters from cell in Microsoft Excel using VBA...
This blog will demonstrate how to remove the non numeric characters from the cell in Microsoft Excel 2016. Assume that you have a worksheet where a cells from the range “A1:D30” contains the alpha-nu...
How to Export Excel data as HTML in Microsoft Excel 2016?
There are times when you might need to export the excel data to a HTML web page and its pretty easy to do it with Microsoft Excel 2016.
How to Export Excel data as HTML in Microsoft Excel 2016?
How to copy multiple sheets in Excel ?.
There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Microsoft Excel. In this blog post, lets see how to do it in Microsoft Excel 2016.
Inserting the color coded drop-down list in Microsoft Excel
There are times when you have to NOT just create or insert a drop-down list in Microsoft Excel sheet but also color code the value so that when the user selects a value from the drop-down list , the ...