Tips

How to disable auto fill feature in Excel

November 9, 2015 By Ravi Shankar Leave a Comment

Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill in Excel 2013, Excel 2010 and Excel 2007

Excel 2016, 2013 and 2010

Click on the File menu –> Options link and navigate to Advanced tab on the left hand side.

Under Editing options, un tick the check box with label as Enable fill handle and cell drag-and-drop. This will turn off the auto fill feature in Excel 2010.

Excel 2007

In Excel 2007, this feature can be turned on or off using the Excel Advanced Options.

Click on the Office button –> Excel Options

Under Excel Options select Advanced section

By checking or un checking “Enable fill handle and cell drag-and-drop”, you can turn on or off the Auto fill feature in Excel 2007.

Also See: How to disable autocomplete suggestion feature in Excel 2010

Export presentation handout notes to Word

November 2, 2015 By Ravi Shankar Leave a Comment

PowerPoint 2016 & 2013 users can use the export feature to create handout notes for their presentation in Word. This is quite useful when you want to quickly take print out of your presentation notes for all your audience.

Step 1: Open the presentation in PowerPoint 2013, click File menu and select Export option from the menu list.

Step 2: Click Create Handouts under Create Handouts in Microsoft Word (Export Screen)

This should display the following Send to Microsoft Word window.

Step 3: Now choose the Page layout in Microsoft Word and specify whether you want to add slides to Microsoft Word document and just link to the slides.

Since I want only the text, I have gone with Outline only option.

Step 4: Click OK button to start exporting the presentation from PowerPoint to Microsoft Word.

This should launch a new word document with content from PowerPoint Presentation.

How to change startup folder in Outlook

October 31, 2015 By Ravi Shankar Leave a Comment

When we launch Microsoft Outlook, the default startup folder will be Inbox.

The startup folder can be changed to your preferred choice using outlook options menu. Listed below are the steps to change the startup folder in Outlook 2016, 2013, Outlook 2010 and Outlook 2007.

Change startup folder in Outlook 2016, 2013 and Outlook 2010

In Outlook 2016, 2013 and Outlook 2010 the startup folder can be using the settings available as part of Advanced Mail options.

Click on the File menu –> Options link and navigate to the Advanced options

In Outlook start and exit section, using the Start Outlook in this folder field you can specify the startup folder. If you want to select a different folder other than Inbox then click on the Browse button and using the Select Folder dialog box you choose the required folder. Click OK button to select the folder. To save the changes, click on the OK button in the Advanced Options screen.

For example, you attend lot of meeting and want to start your day with list of meetings that is scheduled for that day. So you want to have Calendar as the startup folder in Outlook.

Click the File menu –> Options link then click the Advanced tab under Outlook Options window. In the Advanced Options, navigate to Outlook start and exit section.

Click the Browse button and select Calendar from the displayed items.

Then click Ok button to confirm and save the changes. By this way Outlook 2010 users can set Calendar as the startup folder.

Changing startup folder in Outlook 2007

Go to Tools –> Options –> Other tab and click on the Advanced button

In the Advanced Options dialog box under General settings, you can specify the value for Startup in the folder

The new folder can be selected using the Browse button.

select the new folder and click OK to save the changes.

Also See: Auto launch Outlook at Windows Startup

What is a status bar in Word document

October 27, 2015 By Ravi Shankar Leave a Comment

Microsoft Word 2016, 2013 and 2010 displays a status bar at the bottom of a Word document. Word status bar displays information such word count, page number, line number, zoom, zoom slider, Language and many more details.

These details displayed on the word status bar can be configured by using the Customize Status Bar context menu. The Customize Status Bar can be accessed by right clicking the status bar.

In order to turn on or turn off the display of a feature, You can check or un check on the left hand side of a feature.

Also See: Find out character count Microsoft Word document

Different ways to link another document in Word

October 26, 2015 By Ravi Shankar Leave a Comment

Users of Word 2016 and 2013 can create a link to another document within their document using the Insert Object or Hyperlink feature. This is quite useful when you want to include reference documents inside your document.

Insert Object

Step 1: In the main document, navigate and place the cursor to the position where you want to insert the document.

Step 2: Click the Insert menu then the Object option available under Text section.

Step 3: In the Object window, click Create from File tab and choose the required file via browse button.

Make sure to mark the check box with caption as “Display as icon”. If you want the changes to linked document to be reflected in your document then mark checkbox with label as Link to file.

Step 4: Click the OK button to confirm and save the changes. Now your document will have a link to the other document as shown below

Hyperlink

Another alternate way to link a word document is by creating hyperlink pointing to that document.

Step 1: Access the Insert Hyperlink window via the right click Context Menu or Hyperlink option under the Links (Insert menu)

Step 2: In the Link to section choose Existing File or Web Page then select Current Folder option under Look in section.

Step 3: Give a name to the Linked document by entering the name in Text to display and then pick the required document.

Step 4: Click Ok button to confirm and save the changes.

This should create a link to the document as shown below.

How to print black and white in Word

October 25, 2015 By Ravi Shankar Leave a Comment

All programs do not provide option to choose the colour for printing pages. Word 2016 and Word 2013 users can print their coloured document in black and white using the option available as part of the Printer properties.

Step 1: Click the Fie menu and select Print from menu list.

Step 2: Navigate to Printer section and click the Printer Properties.

Step 3: In the Printer Properties window, click the Paper/Quality tab.

Step 4: Navigate to Colour section and mark the radio option with caption as Black & White. Then click OK button to confirm and save the changes.

How to add a new page in Word

October 24, 2015 By Ravi Shankar 2 Comments

This is a short tutorial on Adding or inserting a new page in Word 2016, 2013 and 2010. This can be done using the options available as part of the Insert menu Word. To add a new page in a Word 2010 document, point the cursor to the place where you want to insert a page.

Navigate to the Insert menu and click the Blank Page menu option available as part of the Pages section.

This would insert a new page at place where the cursor placed before.

« Previous Page