Category: Microsoft Office

How to clean up unused PowerPoint master slides in PowerPoint?

If you are one of the users using Microsoft Office 365, you would have come across this small feature in PowerPoint 365, especially on the Windows desktop clients, which shows up a pop-up when you have more than 25 unused slide masters in your PowerPoint slide. How to clean up unused PowerPoint master slides in PowerPoint? Your message will look something like this. “PowerPoint found…

How to create drop down list in Microsoft Excel ?

This article will explain how to create drop down list in Microsoft Excel. Drop down list is one of the most commonly used ways in excel to allow users to select the items from the predefined list . The drop down list in Excel allows the users to select only the valid entries. How to create drop down list in Microsoft Excel ? Follow the…

REVIEW – Recover Excel Password with password-find Online

Forgetting passwords for an password protected excel or word document is one of the most common things that happens for a person. As long as the document is not that critical , it doesn’t matter , but there are times when you might want to recover the document that might contain important data. You can easily recover the passwords of the documents with some tools…

How to hide the status bar in Microsoft Excel with the VBA Code?

Do you want to hide the status bar in Microsoft Excel ?. You can use the VBA code to do it quickly. How to hide the status bar in Microsoft Excel with the VBA Code? 1. Open the excel workbook in Microsoft Excel 2016 and press the keyboard shortcut key “Alt + F11” to open the Microsoft Visual Basic for Applications window. 2. Click the…

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it using the VBA Code. How to display all the worksheet names in Excel using VBA Code ? Open up the Microsoft Visual Basic for Application Window using the keyboard shortcut key “ALT + F11” and enter the following run and free F5 to run…

How to change positive numbers to negative in Microsoft Excel 2016 ?

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) , reverse the sign of the numbers in Microsoft Excel 2016 ?. This blog post will provide you a simple tip on how to do it using the Paste special function. How to change positive numbers to negative in Microsoft Excel 2016 ? 1. Type the number…

How to convert number to text in Excel?

In Microsoft Excel 2016 , there are times when you don’t want the numbers present in the cell to be participating in the calculation. This means , you can either update the formula to not include the cell value or else change the number to text. How to convert number to text in Microsoft Excel 2016? You can use the TEXT function in Excel to…

Liked this content?. Please spread the word :)