Office 2010

Turn off display of hyperlinks in Outlook 2013 & Outlook 2010 messages

September 18, 2015 By Ravi Shankar Leave a Comment

Outlook 2013 & Outlook 2010 by default displays any Internet address as hyperlinks. This is pretty useful feature and by clicking the hyperlink would quickly launch the website. But if you want to disable this feature while reading as well as composing mail, then you turn off this feature using Editor Options.

Turn Off display of hyperlinks when reading messages

Click the File menu –> Options link then navigate to Mail Options.

Click the Editor Options button available under the Compose messages section. In the Editor Options window, click the AutoCorrect Options button available under the Proofing section.

In the AutoCorrect Window, navigate to Replace section under AutoFormat tab and un tick the check box with label as Internet and network paths with hyperlinks.

Turn Off display of hyperlinks when composing messages

In the AutoCorrect Window, navigate to Replace as you type section under AutoFormat as You Type and un tick the check box with label as Internet and network paths with hyperlinks.

Insert PDF file in to word document in Word 2013 & Word 2010

September 15, 2015 By Ravi Shankar Leave a Comment

This tutorial provides the instruction for inserting the content of PDF file in to a word document in Word 2013 & Word 2010. Please note that this feature in Word 2010 has limitation and will insert only the first page of the PDF file in to Word document.

Click the Insert menu in Word then navigate to Text section. Click the down arrow available for Object and select Object from the drop down list.

In the following Object dialog, navigate to Create from file tab.

Then click the browse button and select the PDF file that needs to be inserted and click the OK button.

This would insert the first page of the PDF document in to the Word document.

If you want a link to be created to PDF document then mark the check box with label as Link to file. Checking Display as icon would insert an icon with link to the PDF file a shown below.

How to see forward date in Outlook 2010 Calendar

August 29, 2015 By Ravi Shankar Leave a Comment

Outlook 2013 & Outlook 2010 Calendar provides option to the user to see forward date. This can be done by using the Keyboard shortcut Ctrl + G.

1. Navigate to Calendar View in Outlook 2013 or Outlook 2010

2. Press Ctrl + G to launch the following Go To Date dialog box

3. Type in the future date in the Date field and select the your preferred Calendar view and click OK button.

4. This would display the future date in Day Calendar view in Outlook navigation pane.

By this way you can check the future date in Outlook 2013 & Outlook 2010.

How to export Outlook events to Google Calendar

August 12, 2015 By Ravi Shankar 3 Comments

This tutorial explains the steps required to export Outlook Calendar events to Google Apps Calendar. In order the transfer events from Outlook 2013 and 2010 to Google Calendar, you need to do the following

Export Outlook events in to CSV file.
Import CSV file with Outlook events in to Google Calendar.

Export Outlook Calendar Events

Let us take the following example with two calendar events in Outlook.

To export these events in to a CSV file, click the File menu then navigate to Open menu.

Click the Import option, and select Export to a file in Import and Export Wizard and click the Next button.

Choose the file type as Comma Separated Values (Windows)

Select the Calendar from which you want to export the events and click the Next button.

Enter a name for the export file and click Next button.

Then click the Finish button.

The following message window will be displayed for setting the date range and events that fall between these dates will alone be exported. Click the OK button to complete the export.

Import Calendar Events in CSV to Google Apps Calendar

Login to your Google Apps Account and launch the Google Calendar page. Click the Option icon and select Calendar settings from the list of available menus.

In the Calendar Settings page, click the Calendar tab and navigate to Create new Calendar section.

Click the Import Calendar link and select the CSV file that has the Outlook Calendar Events. Then click the Import button.

The following confirmation message with the Processed and Successfully imported events will be displayed as shown below.

When you navigate back to your Google Calendar, the imported events should be displayed.

Save messages in sent items folder in Outlook

August 12, 2015 By Ravi Shankar 7 Comments

Microsoft Outlook automatically saves the sent messages in sent items folder. But if you do not want to automatically save the sent messages then you can turn off this feature using Outlook Options. Listed below are steps to enable or disable saving copies of messages in Sent Items folder in Outlook 2013, Outlook 2010 and Outlook 2007.

Outlook 2013 and Outlook 2010

Click the File menu –> click the Options link . In the Options window select the Mail tab and scroll down to Save Messages section.

You can turn off or disable the save sent messages sent items folder by un marking the checkbox with label as Save copies of messages in the Sent Items folder.

Save message in Sent Items for single message in Outlook 2013 and Outlook 2010

The above settings would affect all the message but if you want to specify only for selected messages then you can use the options available as part of Message window.

In the message window, navigate to Options menu then to the more options section.

Click the down arrow available below the Save Sent Item To menu option.

The different options that are available are

Use Default Folder – This would save the sent messages in the default sent items folder.

Other Folder – This allows users to specify the folder where this messages needs to be saved.

Do Not Save – This will not save the sent messages to any folder.

Outlook 2007

In Outlook 2007 to enable or disable “Save copies of messages in Sent Item folder”, Click Tools ->Options -> Email Options

Under Message Handling section, by checking Save copies of messages in Sent Items folder, messages that are being sent would be saved to Sent Items folder.

Also See: How to automatically save messages in Outlook 2010

Reset slide settings in PowerPoint 2013 & 2010

August 4, 2015 By Ravi Shankar 1 Comment

PowerPoint 2013 and 2010 have a reset option that can be used for resetting the position, size and formatting of slide place holders to the default settings. For example if you have resized the place holders for adding title and subtitle and now want to revert to default settings then you can use this reset option.

The reset option can be accessed via the home menu. In PowerPoint 2010 home menu, navigate to the slides section. And click Reset menu option, to revert the changes done to the slide to the default position.

Hide worksheet formula in Excel 2013 & Excel 2010

July 26, 2015 By Ravi Shankar Leave a Comment

Excel 2013 and Excel 2010 allow users to hide formula used in a Worksheet. You can use this feature when you want to prevent any one from accidentally changing the entered formula.

Let us say you want to hide the formula (=SUM(F5:F8)) which has been used in the bellow example.

Select the cell where the formula has been entered and navigate to Format menu and click the Format Cell menu option (You can also right click and select Format Cell in the Context menu).

In the Format Cell window, navigate to Protection tab and tick the checkbox with Label as Hidden. Click the Ok button to save the changes.

Then right click on the Sheet and select Protect Sheet from the list of available menu option.

In the Protect Sheet window, tick the check box with label as Protect worksheet and contents of locked cells.

If you want to just hide formula then it is not needed to password protect the sheet. Click Ok button to save the changes.

Now when you navigate to the Formula Cell, the formula bar will not displayed any information.

Bu this you can prevent excel users from seeing formula used in the worksheet.

How to unhide comments in Excel

July 25, 2015 By Ravi Shankar 1 Comment

Excel 2013 and Excel 2010 generally shows comments in worksheet with the Indicator as shown below.

And when you hover over the indicator it will display the added comments.

But in case if you are not able see the comments added to your worksheet then try the unhide option available as part of the

Click the File menu and then the Options link
In the Excel Option window, navigate to Advanced Options
Scroll down to display section and For cells with comments radio option select your preferred choice i.e either Indicators only, and comments on hover or Comments and indicators.
4. Click Ok to save and confirm the changes.

« Previous Page