How to run Visual Studio 2015 in safe mode?
There are times when you Visual Studio instance might not start up correctly. One of the best option during this time is to use Microsoft Visual Studio in safe mode. By running the Visual Studio in s...
Monthly Archives: January 2016
How to mark a class or method as deprecated in C# ?
There are times when you want to mark a class or method as deprecated in your source code so that you donor want any developers to use it any more in the project. You can use the obsolete attri...
Watch Window in Microsoft Excel 2016
You would have come across Watch Window in Visual Studio IDE , similarly Microsoft Excel 2016 too provides the Watch Window that lets the users to monitor the value of a cell when you are working on ...
How to find the Nth Smallest Number from a List of values in Excel ?
In one of the previous blog posts , we saw how to get the Nth largest number from a list of values in Excel. In this blog post , lets look at getting the Nth smallest value from the list. How to find...
How to find the Nth Largest Numbers from a List of values in Excel ?
There are times when you might want to find out the 3rd Largest value from the list of number from Excel cells. How to find the N Largest Numbers from a List of values in Excel ? Microsoft Excel prov...
How to show or hide Vertical & Horizontal Scroll bar in Microsoft ...
You can scroll through the worksheet using the horizontal and the vertical scroll bars which can be found at the bottom and the right side respectively. Here’s a simple tips demonstrating how y...
How to delete all hidden rows or columns in Microsoft Excel 2016 ?
Do you want to delete all the hidden rows or columns from your workbook in Microsoft Excel 2016?. Here’s how you can do it. How to delete all hidden rows or columns in Microsoft Excel 2016 ? 1....
How to retreive the highest or lowest value in Microsoft Excel ?
There are times when you might need to select the highest or the lowest value from a range of cells in Microsoft Excel. How to get the highest or lowest value in Microsoft Excel ? There are two formu...
How to find the nth occurrence of a character in a string in Excel ?
Assume that you have a text in cell A1 and you wish you to find the 2nd occurrence of a specified character and display the position of it. How to find the nth occurrence of a character in a string i...