Excel 2016

Showing 41 - 60 of 72 results
There are times when you might want to set the column width and row height for a range of cells...
This blog post will demonstrate how you can insert the unique sequence numbers in Microsoft Excel 2016. How to quickly...
Microsoft Excel 2016 provides you with the PROPER function that lets you change the uppercase letters to title case. Let’s...
In Microsoft Excel 2016 , you can easily create or insert radio buttons in the worksheet using the Form Controls...
Microsoft Excel 2016 provides you with functions that lets you to remove characters from the cell which is of type...
This blog post will explain in simple steps on how to change the shape of comment box in Microsoft Excel...
Assume that you have a range of cells that contains values with 4 decimal places and you wish to round...
Here’s a simple trick that lets you to swap the contents of the cell quickly in Microsoft Excel 2016. How...
There are times when you might want to prevent the users from entering certain number of characters in a cell...
This blog will explain how to split the column that contains the full name to first name and last name...
Do you want to insert a random number between 2 numbers in a excel cell? For example , assume that...
You can unhide the worksheets in Microsoft Excel 2016 with different ways. These include using the Format option from Home...
Do you want to hide the worksheets in Microsoft Excel 2016?. Here’s how you do it. How to Hide worksheets...
You would have come across Watch Window in Visual Studio IDE , similarly Microsoft Excel 2016 too provides the Watch...
There are times when you might want to find out the 3rd Largest value from the list of number from...
You can scroll through the worksheet using the horizontal and the vertical scroll bars which can be found at the...
Do you want to delete all the hidden rows in excel or even remove hidden columns in Excel ?. This...
There are times when you might need to select the highest or the lowest value from a range of cells...
Assume that you have a text in cell A1 and you wish you to find the 2nd occurrence of a...
Ever wondered how you can show or hide comments in Microsoft Excel ?. This blog post exactly shows how you...

Categories

Archives