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

How to automatically clear deleted items folder in Outlook

When you delete any items in Microsoft Outlook, they are moved to the deleted items folder. Microsoft Outlook has an option to automatically clear deleted items folder when user quits the application. In this tutorial, we will see the steps to enable auto clear deleted items option in Outlook 2016, Outlook 2013, Outlook 2010, Outlook […] Read More

Disable permanently delete items warning message in Outlook

Outlook displays a warning message when deleting outlook emails. It displays a dialog box with message “Are you sure that you want permanently delete the selected items” as shown belowThis is very useful warning option for the users before deleting the mail items permanently. But If you do not want to see the permanently deleted […] Read More

Turn off display search as you type in Microsoft Outlook

Microsoft Outlook provides option to display search results as we type the text in search box. This is a useful feature but if you think the real-time search result is a distraction then you can disable “display search as you type” feature using Search options. Listed below are steps to turn off this feature in […] Read More

How to add background image in Word

In one of the earlier article we had covered the steps required for adding background image in Excel. Similarly now we are going to see how to insert image background for a document in Word 2016 & 2013. Step 1: Open a new document in Word 2013. Step 2: Click the Insert tab and navigate […] Read More

Excel displays formula instead of value

In this article we are going to see one of the possible scenario where Excel 2016 & 2013 displays formula instead of value. Let us take the following sample data where cell C4 is showing test instead of calculated value. Navigate to Cell C3 and check the Format specified for the Cell. Now change the […] Read More

Repeat action keyboard shortcut in Microsoft Office

Microsoft Office Applications such as Word and Excel, last action can be repeated using keyboard shortcuts. For example if you have formatted a word with specific style and you want to repeat/apply the same format for other words then you can press F4 or Ctrl + Y or Alt + Enter. This can be used […] Read More

Add background color in Word

In this tutorial, we are going to see how to add background colour to a document in Word 2016 and 2013. This is quite useful when you want to design your word document with some difference instead of plain background look. Step 1: Launch Word 2013 and click the Design tab. Step 2: Navigate to […] Read More

How to add dropdown list in Excel

In this excel tutorial, we are going to see how to add dropdown list in Excel 2016 and 2013. Excel users can add drop down using the option available as part of Data Validation settings. Adding dropdown in Microsoft Excel Step 1: Click Data in Office Ribbon and navigate to Data Tools section. Step 2: […] Read More

How to change calendar time zone in Outlook

Outlook 2016, 2013 and 2010 provide users with the option to change calendar time zone. Listed below are steps to change the calendar time zone and adding second time zone in Outlook Outlook 2013 and Outlook 2010 have a feature that lets users to add second time zone to their Calendar. This is quite useful […] Read More

How to recall email message in Outlook

Recall message in Outlook 2016, 2013 and Outlook 2010 Outlook has a feature that lets users to recall a sent message. This can be done by accessing the Recall This Message option available as part of Actions drop down. This feature is quite useful If you had sent an e-mail message to an user with […] Read More

How to import text file in Excel

This tutorial is provided step by step instruction to import a text file in to Worksheet in Excel 2016 and 2013. For this demo, let us take the following sample data with the columns separated from tabs and spaces. Step 1: Launch Excel Workbook and click the Data menu. Then navigate to Get External Data […] Read More

How to insert numeric symbols in Word

In this tutorial, we are going to see the steps to required for inserting numeric symbols such as ?, ? in Word 2016 and Word 2013. This is in addition to earlier topic related with inserting symbol in a word document. Insert numeric symbols in Microsoft Word Step 1: From Home menu, navigate to the […] Read More

How to add background in Excel

Excel 2016 and 2013 users can customize the look of a worksheet by adding background image. Let say you have got the following worksheet and want to add background image to it. Step 1: Click the Page layout tab and navigate to Page Setup section. Step 2: In the Page Setup section, click the Background […] Read More

How to insert spreadsheet in Word

We had earlier seen about performing simple math calculation in Word. And in this tutorial we are going to see the steps for adding spreadsheet in a word document. Let us see this by creating an invoice for the purchased items using Word 2016 and Word 2013. Insert Excel spreadsheet in Word 2013 Click the […] Read More

1 2 3 4 141

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