Excel 2016 | Developer Publish

How to wrap text using Wrap Text Command in Excel ?

December 25, 2016 no comments

Microsoft Excel provides the Wrap Text command that lets the users to quickly wrap long sentences and lets the users view the full content of the cell easily. How to wrap text using Wrap Text Command...

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

December 23, 2016 no comments

There are times when you need to change the orientation of the text with in the cell in Microsoft Excel and you can do that by following the steps as shown in this blog post. How to change the orient...

Insert Header and Footer in Microsoft Excel

November 10, 2016 no comments

Header and Footer in a Excel Sheet can help you to show certain information to the user on each printed page easily. This blog post will demonstrate how to add or insert header and footer in Microsof...

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

November 3, 2016 no comments

Assume that you want to display the name of the current file in a cell of your worksheet , you can easily do it using the formulas in Microsoft Excel 2016. How to insert the current file name in a ce...

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

November 2, 2016 no comments

There are scenarios where you might want to add more than one author names for a Workbook in Excel. You can do that easily in Microsoft Excel by using the Related People options. How to add additiona...

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

November 2, 2016 no comments

Do you want to insert the current excel workbook’s file path in to a cell in Microsoft Excel ?. You can use the formula to perform this. How to insert the Current file path to a Cell in Microsoft Exc...

How to limit entries to numeric value in Microsoft Excel ?

October 31, 2016 no comments

There are times when you might want to control what data the user can enter to a cell. For example , you want the user to enter only a numeric value that is greater than 75. How to limit entries to n...

Finding the nearest value in Microsoft Excel

October 30, 2016 no comments

Assume that you have a range of numbers in a column and you are required to find out the nearest value or the closest value to the specified number from the range. How to find the nearest value in Mi...

How to get the Created Time and Last Modified Time of your Excel Workb...

October 26, 2016 no comments

Do you want to retreive the created time and the last modified time of your Excel workbook and display it in the excel sheet ? Here’s a code snippet demonstrating how you can display them in th...

Removing Non numeric characters from cell in Microsoft Excel using VBA...

October 26, 2016 no comments

This blog will demonstrate how to remove the non numeric characters from the cell in Microsoft Excel 2016. Assume that you have a worksheet where a cells from the range “A1:D30” contains the alpha-nu...

1 2 3 4 5 6 7 Next »