Viewing: MS Office

How to include original message in Outlook

Microsoft Outlook users can include the original message while forwarding or replying to an email. The users can choose any one of the following options for original message Do not include original message Attach original message Include original message text Include and indent original message text Prefix each line of the original message  Listed below […] Read More

Turn Off feature description in screen tips in Microsoft Word

In Microsoft Word 2007, screen tips are available for each command. The screen tips by default show feature description. For example, the replace command screen tips with feature description looks as shown belowMicrosoft Word provides option to enable or disable feature description in Screen Tip. If you do not want to display the feature description […] Read More

How to insert special characters in Excel

This short tutorial is about the steps required for inserting special characters in Excel 2016 & 2013. For example, you want to insert Copyright, Registered, Trademark symbols then you can use the available as part of Insert menu. Listed below are the steps for inserting copyright symbol in ExcelStep 1: Place the cursor to the […] Read More

Screen capture in Excel

Excel 2016 & 2013 allows users to insert screenshot of open windows or take quick snapshot of part of screen. The screen capture feature in Excel is available as part of the Insert menu.Click the Insert menu and navigate to Illustrations section.Under Illustrations section, click the Screenshot option.Now if you want to insert any open […] Read More

How to move or copy worksheets in Excel

This is a short tutorial is about the steps required for moving or copying worksheets in Excel 2016 and Excel 2013. Excel users can copy or move users using the right click context menu or Format menu options.Step 1: Select the Sheet tab that needs to be copied or moved. If you want to copy […] Read More

How to use conditional formatting to colour alternate rows in Excel

Excel 2016 & 2013 users can use conditional formatting to colour alternate rows. Let us take the following sample dataNow you can add background colours to alternate rows by adding conditional formatting rules.Listed below are the steps for changing the background colour of alternate rows using conditional formatting.Step 1: Select the data for which the […] Read More

How to use Watch Window in Excel

Watch Window in excel helps users to monitor cells and their formulas. This tool is quite useful when you have a large data set and want to periodically monitor the result. Let us see this with an example worksheet used for calculating expenses.This excel worksheet uses formula for calculating Total monthly expenses and Annual Expense. […] Read More

How to hide and unhide worksheets in Excel

When you are sharing your excel workbook to other users and want to hide unnecessary worksheets then you can follow below mentioned steps.If you want to make life little tougher for the users to unhide the worksheet then you can use xlSheetVeryHidden attribute to hide a Worksheet.Click the Developer menu and navigate to Controls section. […] Read More

How to perform simple math calculation in Word

In this tutorial we are going see about “Calculate” feature that can be used for doing simple math calculation in Word 2016 & Word 2013. Some of the popular calculation supported by Calculate are Addition, Subtraction, Multiplication and DivisionIf you want to find out the sum of the following series of numbers then select those […] Read More

Add Office ribbon command to Quick Access Toolbar in Word

In this short tutorial, we will be covering the steps required to add Office Ribbon command to Quick Access Toolbar. Let us see this with an example by adding Show comments command to QAT in Word 2016 & 2013. If you are frequently using Show comments then you can add this as part of QAT […] Read More

Fix functionality is currently limited problem in Word

In this tutorial we are going to see the steps required to fix the functionality is currently limited problem is Word 2016 & 2013.One of the possible reason for this issue might be that you have opened the document compatible with the previous version of Microsoft Word.Functionality is currently limited issue can be fixed by […] Read More

How to use Word as PDF Converter

In this tutorial we are going to see the different ways to convert word document in to PDF in Word 2016 & 2013.Step 1: Open the word document that needs to be converted to PDF.Step 2: Click the File menu and select Export from the menu list.Step 3: In the Export screen, select Create PDF/XPS […] Read More

How to check document compatibility in Word

This tutorial is about using document compatibility checker in Word 2016 & 2013. You will find this useful when you are sharing a document created in Word with users using previous version of Word. This tool will help us to find out whether document created in Word 2016 & 2013 will be compatible with previous […] Read More

How to enable developer menu in Excel

This tutorial is about the steps required to enable developer menu Excel 2016 and Excel 2013. The Developer menu provides option for writing VBA code, enable or disable add-ins, form controls and XML interactionsStep 1: Click the File menu and select Options from the list.Step 2: In the Excel Options window, navigate to Customize Ribbon […] Read More

How to quickly send worksheet as PDF in Excel

We have already covered the procedure for converting excel worksheet in to PDF. In this short tutorial we are going to see the the steps required for quickly sending worksheet as PDF in Excel 2016 and Excel 2013.Step 1: Open the Excel worksheet that needs to shared with other as PDF file.Step 2: Click the […] Read More

1 2 3 44

Get your free copies of the following tech guides by joining the Digital Answers mailing list.