Category Archives: Microsoft Office

What is the SUMPRODUCT in Excel and how to use it?

SUMPRODUCT is a built-in function in Microsoft Excel that multiplies the range of cells or arrays and returns the sum of products. To calculate the sum of the products of corresponding numbers in one or more ranges, you can use Excel’s powerful SUMPRODUCT function. SUMPRODUCT first multiplies then adds the values of the cells or […]

How to Create a Photo Album in Microsoft PowerPoint?

Suppose you are working on an impressive PowerPoint project and want to include Photo Album in slides, whether for weddings, birthdays, or showcasing your family and friends. A Photo Album is a presentation that mainly consists of photographs or images. In this post, we will guide you through creating or editing a Photo Album in […]

How to change Row Height and Column Width in Microsoft Excel Worksheet?

There are several opportunities in Microsoft Excel Worksheet to beautify its contents. If you have some data in Excel Worksheet that doesn’t fit with your requirement, you may want to adjust the height and width of the rows and columns. Usually, the height of rows and the width of columns in Excel are automatic, but […]

How to print hidden text or paragraphs in MS Word on Windows PC?

With the default configuration of Microsoft Office Word document, it doesn’t print any hidden text. In case you want to print all hidden text, you need to change the default settings of MS Word. With the help of this tutorial, you can print hidden text in MS Word. What is hidden text or paragraph in […]

How to hide text or paragraphs in MS Word Document on Windows PC?

Microsoft Office Word document comes with a lot of features. Out of those features, one feature is hiding the text or paragraph in an MS Office word document. For any reason, if you want to hide a text or paragraph from others, this tutorial will help you to do the same. This feature is handy […]

How to print Microsoft Office Word Document with the background color or background image?

Microsoft Office Word documents can be customized with a lot of built-in options. One of the customizations is background color or background image. When you print a Microsoft Office Word document with default settings, the background color or background picture is not printed. Although you have set the background color or background picture in a […]

How to create a Hyperlink for an existing file or sheet in Microsoft Excel?

For easy navigation, in Microsoft Excel, you can use a hyperlink to connect the document in the worksheet to web pages, existing files, or other workbooks. This feature is useful for those who want to express MS Excel extraordinarily. Placing a Hyperlink into an MS Excel worksheet help others with easy navigation with related information. […]

How to Add or Remove Borders in Microsoft Excel Cells?

If you are working in Microsoft Excel and want to add or remove borders for cells in the worksheet, it is easy. To beautify the content of the cells in Microsoft Excel, you can choose to add color, styles, and thickness to borders, or even you can remove the borders from the cells. In this […]

How to Display and Work with Multiple Windows in Microsoft Word?

Most of us are familiar with Microsoft Office Word documents and use them almost daily. The default configuration of MS Word opens a single window where we usually type the contents. A few of us are aware that in Microsoft Word, we can display multiple windows, and even we can open multiple windows that can […]

How to use the TRIM Function in Microsoft Excel?

Whenever you copy text from other sources like MS Office into Microsoft Excel, it can occasionally come with some characters that you want to prefer to remove, such as unnecessary spaces. You can manually remove these characters anytime: however, a function is available in MS Excel, TRIM. MS Excel TRIM Function lets you remove unnecessary […]