Category Archives: Microsoft Excel

How to Add New Tabs and New Groups to the Ribbon in Office 2010/2013/2016?

Many new features are available in Microsoft Office 2010/2013/2016, and many customizations are possible. These features can be accessed easily from the Office Ribbon. One can enable or disable Dark Mode, save a file as PDF, add color or image to an MS Office Word document’s background, and even change the default font in Word, Excel, and PowerPoint […]

How to save a file as PDF in Microsoft Office 2010/2103/2016/2019?

PDF (Portable Document Format) is supported on all desktop and mobile operating systems, including Windows, macOS, Linux, Android, iOS, Windows Phone, Blackberry, etc. Because of PDF’s popularity, most of us use it to share documents. Most modern browsers can also view PDF files without any third-party PDF reader software. If you work in 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 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 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 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 […]

How to change the default font in MS Office Word, Excel, and PowerPoint for Windows 10/8/7?

If you are working on an organization PC, do you know what Microsoft Office is for? Microsoft Office comes with a suite of applications required for day-to-day work in an office environment. A few years ago, Microsoft set the default font size and style to Calibri. There is nothing wrong with the Calibri, and you […]

How to use AutoSum function in Microsoft Excel?

Microsoft Excel comes with a lot of features. In this post, we will explain what is is AutoSum and how to use it? With this post’s help, you will learn to automatically sum columns or rows with the Sum shortcut, a sum only visible cells, sum selected range vertically and horizontally in one go, and […]

How to Rotate Text in an MS Excel Spreadsheet?

There is a lot of customization is possible in Microsoft Excel documents. In this post, we will see to rotate a text in an Excel spreadsheet. This article will help if you want to rotate a text in an Excel spreadsheet according to your requirement. At various times you need to customize an Excel spreadsheet […]