Slide Show keyboard shortcuts in PowerPoint

PowerPoint 2016, 2013 and 2010 Slide Show keyboard shortcut will be displayed as part Slide Show help (by pressing F1 during a Slide Show). The different Slide Show Shortcuts available as part of PowerPoint are Advanced to the next slide ‘N’, space, right or down arrow, enter, or page down Return to the previous slide […] Read More

Go To specific page number in Word

In Word 2013 and Word 2010 you can go to specific page in the Word document using the Find and Replace dialog. To display the Find and Replace dialog, Navigate to Home menu and click on the drop down arrow under Find menu. Another shortcut for launching Find and Replace is by pressing Ctrl + […] Read More

Remove “Save password for free items” in App Store

Mac App Store has a feature that lets users to save password for downloading free apps. When you enable this option and installing any free app will be installed automatically without asking you to enter the password.Incase if you wish you disable this feature then you can do the following Step 1: Launch System Preferences […] Read More

Insert a Cover Page for document in Word

Now using Word 2010, 2013 and 2016 you can create a Cover page for your Word Document. This can be done using the Insert Cover Page option available as part of Insert menu. List below are the steps to add cover page for document in Word 2016, Word 2013 and Word 2010.Click Insert menu and […] Read More

Request for delivery message and receipt message in Outlook

Microsoft Outlook users can request for delivery message and read receipt message. These options are useful to keep track of the messages that are being sent and to find out whether the users have actually read these messages. Let us see the steps required for enabling tracking feature in Outlook 2013, Outlook 2010 and Outlook […] Read More

How to sort list of items in Word

In Microsoft Word, you can automatically sort list items in a paragraph. This can be done by using the "Sort Option" present in Paragraph ribbon.For example, if you want to sort the following list of items London New York Paris Delhi Tokyo Select the list items in the paragraphThen navigate to paragraph section in the […] Read More

Autocorrect in Word – Replace text as you type

Autocorrect in Microsoft Word 2016, Word 2013, 2010 and 2007 has a feature called replace any text as you type. This tutorial provides an example for replacing text with text and image in Word document.Replace text as you type in Word 2016, Word 2013, Word 2010 and Word 2007In Word 2013 and Word 2010 you […] Read More

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

1 2 3 4 142

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