Tag: Excel 2016

Inserting the color coded drop-down list in Microsoft Excel

How to insert the Current file path to a Cell in Microsoft Excel ?

How to change the shape of a comment box in Excel 2016 ?

How to add prefix or suffix to range of cells in Microsoft Excel 2016 ?

How to Sum Alternate Rows/Columns cell values in Microsoft Excel ?

How to show “developer tab” in Microsoft Excel 2016 ?

How to View Named Ranges in Microsoft Excel ?

How to remove time from date in Microsoft Excel 2016?

How to fill Blank Cells with a specific value in Microsoft Excel 2016?

How to count the duplicate values in a column in Microsoft Excel 2016?

Setting the Column Width and Row Height for a range of Cells in Microsoft Excel

How to retreive the highest or lowest value in Microsoft Excel ?

How to remove the First and Last Characters from the Cell in Microsoft Excel 2016 ?

How to resize print area and fit to Single page in Excel 2016 ?

How to limit entries to numeric value in Microsoft Excel ?

How to find the Nth Largest Numbers from a List of values in Excel ?

Watch Window in Microsoft Excel 2016

How to quickly insert sequence numbers in Excel?

How to merge worksheets to one worksheet in Microsoft Excel 2016?

How to Reverse a string in Microsoft Excel ?