Posts under Office category

field shading

How to disable or remove Field Shading in Word 2016

Users working on small screen devices like tablets and smartphones find it difficult to find the fields in documents. For this reason, Microsoft Office Word offers field shading feature that helps users find fields in their files quickly. How, simply […]

query editor

How to Unpivot Static Tables in Excel 2016

If you are a regular Microsoft Excel 2016 user, but not quite familiar with Power Query Add-in for Excel, then this post will acquaint and help you get started with it. Any advanced Excel user faces challenge of analyzing or […]

Parameters

How to customize the Calendar Insights template in Excel 2016

Calendar Insights template in Excel 2016 is professionally designed and easy-to-use template that can help you plan and schedule your meetings. Originally designed for accounting purposes, the Excel App has come a long way and has turned into one of […]

insert excel spreadsheet in word editable

How to insert Excel Spreadsheet in Word Document

Sometimes we need to insert Excel Spreadsheet in Word Document. It can be done is such a way that, whenever you update the Excel Spreadsheet, it automatically needs to be updated in the Word Document, so that we can avoid […]

select the image from the bulleted list

How to use Pictures as Bullets in Word

We list out things in Word using bullets. There are basic bullets available in Microsoft Word as numbers, symbols and more. We might be using numbers, dot symbols and regular symbols as bullets in Word. When you are preparing a […]

hide text in Word sample document

How to Show and Hide Text in Word

Microsoft Word has an interesting feature to show and hide text you want. You may be in a situation where you do not want to completely delete the text, but should not have it in the document. Then, you can use […]

Sync Mail Settings done

Manage Mail App Sync Settings in Windows 10

Unlike its predecessors, the Mail and Calendar apps for Windows 10 offer more options to setup different email services. Apart from the improved performance and a familiar three-pane email UI, you can find a toggle to quickly move between your […]

change Numbered list in word

How to change the default Numbered List in Word

We all know that the default numbered list used in Microsoft Word is like – 1, 2, 3, etc. But if you wish, you can change them to letters or another type, like the Roman numbers. If we look closely […]

error messages in excel error alert

How to add Error Messages in Microsoft Excel

As we all know Microsoft Excel is used to collect data in rows and columns. Sometimes, we want to restrict to only certain data to be in the sheet. We want to throw an error, when someone is trying to […]

Use Advance Filter in Excel added condition 2 in criteria region

How to use Advance Filter in Excel

We know that we can set filters on columns and filter the data with just a click in Microsoft Excel. It can be done by clicking on the ‘Filter’ under “Data” tab. Apart from just filtering the data based on […]

office-2016

Deployment Options for Office 2016

The latest in the productive suite from Microsoft is Office 2016 – with touch support and a hoard of features in each desktop application and web apps. Check out the list of new features in Office 2016 if you haven’t […]

find wildcard characters in excel using tilde

How to Find and Replace Wildcard Characters in Excel

Finding and replacing required text and numbers is very easy with the use of Wildcard Characters in Microsoft Excel. It might be single occurrence or multiple occurrences – everything can be found and replaced easily using Wildcards. There will be […]