Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    Home2016Page 2

    2016

    Showing 21 - 40 of 146 results

    How to find the Created and Last Modified time in Microsoft Excel ?

    You can easily find out the exact date and time when the excel workbook was created and modified using the...
    Read more

    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...
    Read more

    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...
    Read more

    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...
    Read more

    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....
    Read more

    Auto Populate Cell Value on selecting value in Excel drop-down list

    This blog post will explain how you can auto populate the cell when you select a value from drop-down list...
    Read more

    How to generate random strings in Excel?

    In one of the previous blog posts , we demonstrated how you can use the function RANDBETWEEN in Microsoft Excel...
    Read more

    How to Generate Random Numbers in Microsoft Excel ?

    If you want to generate random numbers in Microsoft Excel , you can use the function RANDBETWEEN. How to Generate...
    Read more

    How to sort worksheets in alphabetical order in Excel 2016 using VBA Code?

    There are times when you wish to sort your worksheet tabs in excel in alphabetical order so that its easier...
    Read more

    How to Convert Date to Weekday Name in Microsoft Excel 2016 ?

    Assume that you have a date in a cell “A1” and you wish to display only the Weekday name for...
    Read more

    How to reverse the column order in Microsoft Excel ?

    This blog post will explain in simple steps on how you can flip or reverse the order of the column...
    Read more

    How to quickly delete all hyperlinks from a worksheet in Microsoft Excel 2016 ?

    It might be a time consuming task to delete all the hyperlinks from a worksheet in Excel if the user...
    Read more

    How to remove leading and trailing spaces in Microsoft Excel 2016 ?

    There are times when you would have the cell that contains the blank spaces before or after the text. You...
    Read more

    How to add or subtract days in Microsoft Excel ?

    In Microsoft Excel 2016 , you can easily add or subtract days directly by using the + or – operator....
    Read more

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

    There are times when you have to fill the blank cells within your worksheet in Microsoft Excel 2016 with the...
    Read more

    Changing the background color of a cell based on value in Microsoft Excel 2016

    This blog post will explain how the users can change the background color of a cell based on its value...
    Read more

    Useful Keyboard shortcuts in Microsoft Excel 2016 that you must know – Part 1

    There are plenty of shortcut keys available in Microsoft Excel that lets you to do few repeated tasks quickly. In...
    Read more

    C# 7.0 : Pattern Matching

    In one of the previous blog post , we saw the Out variables enhancements in C# 7.0. This blog post...
    Read more

    How to Display the Current Date in a Cell in Microsoft Excel ?

    Microsoft Excel 2016 provides the functions =TODAY() and =NOW() which displays the current date in a cell in Excel sheet....
    Read more

    Custom Cell Formatting in Microsoft Excel 2016

    This blog post will provide you a simple tip on how to use Custom Cell Formatting in Microsoft Excel 2016...
    Read more

    Categories

    Archives
    Tags
    c# C# Compiler Errors C# Programs C++ examples C programs csharp DB2 Errors Delphi Errors Download Excel Excel 2016 Excel Automation excel functions excel tips excel tutorials Excel VBA Functions in Excel how to HPE NonStop SQL/MX Java examples Microsoft Microsoft Excel MS Office MySQL Errors Oracle Errors Outlook Errors PolarDB for PostgreSQL Python examples python programs SQL Server SQL Server Errors Sybase Error Message tips tricks troubleshoot Visual Studio Visual Studio 2012 Win32 Windows 11 Windows 11 tutorials Windows BSOD Errors windows phone windows phone 8 Windows Store wp8