MS Office

Showing 21 - 40 of 61 results

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

Excel
November 3, 2016

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

Excel
November 2, 2016

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

Excel
November 2, 2016

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

Excel
November 2, 2016

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

Excel
October 31, 2016

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

Excel
October 26, 2016

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

Excel
October 26, 2016

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

Excel
October 23, 2016

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

Excel
October 21, 2016

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

Excel
October 21, 2016

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

Excel
October 19, 2016

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

Excel
October 19, 2016

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

Excel
October 19, 2016

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

Excel
October 16, 2016

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

Excel
October 15, 2016

How to insert a picture into a comment box in Microsoft Excel?

This blog post will explain how to add or insert picture (image) to the comment box in Microsoft Excel 2016....

Excel
September 2, 2016

How to View Named Ranges in Microsoft Excel ?

Named range is a very useful feature in Excel especially when you work with lot of formulas but there are...

Excel
September 1, 2016

How to Reverse a string in Microsoft Excel ?

There are times when you might want to reverse a string or text in a cell in Excel to achieve...

Excel
July 3, 2016

How to save the workbook as PDF in Microsoft Excel ?

You would have been in a scenario where you want to save your entire excel workbook to PDF in Microsoft...

Excel
July 2, 2016

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

There are times when you might need to merge different worksheets in to a single worksheet in Microsoft Excel. You...

Excel
July 1, 2016

Categories

Archives