Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    HomePosts tagged “Excel 2016”

    Excel 2016

    Showing 1 - 20 of 72 results

    How to insert drop down list in Microsoft Excel 2016 ?

    If you are one of the users who use excel more frequently at work, for instance, Data Analytics user, you...
    • Excel
    • November 22, 2019
    Read more

    How to Delete Blank or Empty Rows in Microsoft Excel 2016 ?

    This article teaches you how you can delete blank rows or rows that contains empty data in Microsoft Excel 2016....
    Read more

    How to wrap text using Wrap Text Command in Excel ?

    Microsoft Excel provides the Wrap Text command that lets the users to quickly wrap long sentences and lets the users...
    • Excel
    • December 25, 2016
    Read more

    How to quickly remove multiple line breaks in Excel using VBA code?

    There are times when you might copy few data from different source and you would end up getting unnecessary line...
    • Excel
    • December 25, 2016
    Read more

    How to change the orientation of text in cells in Excel ?

    There are times when you need to change the orientation of the text with in the cell in Microsoft Excel...
    • Excel
    • December 23, 2016
    Read more

    Insert Header and Footer in Microsoft Excel

    Header and Footer in a Excel Sheet can help you to show certain information to the user on each printed...
    • Excel
    • November 10, 2016
    Read more

    How to insert the current file name in a cell in Microsoft Excel ?

    Assume that you want to display the name of the current file in a cell of your worksheet , you...
    Read more

    How to add additional authors to the Excel Workbook in Excel 2016 ?

    There are scenarios where you might want to add more than one author names for a Workbook in Excel. You...
    Read more

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

    Do you want to insert the current excel workbook’s file path in to a cell in Microsoft Excel ?. You...
    Read more

    How to insert bullets in to cells in Microsoft Excel ?

    Do you want to insert bullets in cells of Microsoft Excel?. Here’s how you can do it. How to insert...
    Read more

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

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

    When you try to print a worksheet in Microsoft Excel 2016 , you may notice that the content might overflow...
    Read more

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

    How to get the Created Time and Last Modified Time of your Excel Workbook using VBA Code ?

    Do you want to retreive the created time and the last modified time of your Excel workbook and display it...
    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

    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

    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