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 […]
Category Archives: Microsoft Excel
Microsoft Excel, Microsoft Office, Microsoft PowerPoint, Microsoft Word, PDF
How to save a file as PDF in Microsoft Office 2010/2103/2016/2019?
27
Mar
Mar
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 […]
13
Mar
Mar
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 […]
Microsoft Excel, Microsoft Office
How to change Row Height and Column Width in Microsoft Excel Worksheet?
05
Mar
Mar
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 […]
Microsoft Excel, Microsoft Office
How to create a Hyperlink for an existing file or sheet in Microsoft Excel?
04
Mar
Mar
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. […]
03
Mar
Mar
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 […]
24
Feb
Feb
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 […]
Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Windows 10
How to change the default font in MS Office Word, Excel, and PowerPoint for Windows 10/8/7?
21
Feb
Feb
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 […]
23
Jan
Jan
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 […]
03
Jan
Jan
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 […]