MS Office

Prevent automatic insertion of current date in Word

October 13, 2015 By Ravi Shankar 8 Comments

This is in reference to a query posted by one of the blog reader on “how to prevent the date field getting automatically updated with the current date in a Word document. We had already seen the steps required to insert current date or modify date format for the date in Word 2016, 2013 & 2010. Similarly you can stop Word from the changing the date to the system date by following the below simple steps

Step 1: Open the document with the date field.

Step 2: Select the date field then click the Insert menu and navigate to Text section.

Step 3: Click the Date & Time option available under Text section.

Step 4: In the Date and Time window, un mark the check box with label as Update automatically then click OK button to confirm and save the changes.

By this way Word users can stop automatic update of date field to the current date.

Quickly print emails and attachments in Outlook

October 10, 2015 By Ravi Shankar Leave a Comment

Outlook 2016, 2013 and Outlook 2010 allow users to quickly print email & attachments using quick print options available as part of context menu. This is quite useful when you do not want to open an email and print the attachments.

Enable default printer

First you need to enable the default printer under Print options. Click File menu –> Print

In the Print screen, click Print Options button and mark the check box with caption as “Print attached files. Attachments will print to the default printer only.”

Quick Print in Outlook 2013 and Outlook 2010

Now you can navigate to the email with attachment. Right click and select Quick Print from the right click context menu.

Block emails based on subject in Outlook 2016, 2013 & 2010

October 3, 2015 By Ravi Shankar 8 Comments

This post is reply to a query asked by a Digital Answers reader <Thanks Brian>

Please tell me how to block a persistent group of junk mail senders. I have tried by “blocking sender” over 400 times without success. I get 10 t0 25 emails daily promoting “Viagra” and they keep changing the senders name and subject but nearly always include the words “sex”or “Viagra”or “Vigr” in the subject. Can we block the sender by somehow blocking those words?

Block emails by blocking domain

I am not aware of blocking emails based on the subject but you can try to block the domain name completely instead of email address. You can do this using the Junk Email Options.

Click the down available below the Junk Option under Delete section and select Junk E-mail Options from the drop down list

In the Junk Email Options window, navigate to Blocked Senders tab. For example, if you are receiving junk emails from senders with domain as “xx.com” then you can Add them to the blocked list using the Add button.

Block emails by creating Outlook Rules

The other best solution is to create rules to block all the emails based on their subject and move them to Junk E-mail folder

Navigate to Move section under Home menu then click the arrow pointing downwards available below the Rules Option and select Manage Rules & Alerts from the menu list.

In the Manage Rules & Alerts window, click the New Rule button.

Select “Move messages with specific words in the subject to a folder” and click specific words link available under the Edit the rule description.

In the Search Text window, enter the text that needs to checked with the email subject.

Now click specified link available under the Edit the rule description and choose the folder where you want to move these emails.

After specifying the folder, click Next until the Finish rule setup screen is displayed.

Then specify a name for this rule and click Finish button. Now any emails with specified text will be moved to Junk E-mail folder. These are some of the methods by which you can blocks emails in Outlook 2016, Outlook 2013 and Outlook 2010

How to turn off auto calculation in Excel

October 2, 2015 By Ravi Shankar Leave a Comment

In this tutorial, we will see how to disable auto calculation in Excel 2016, 2013 & 2010. Auto calculation in Excel is an useful feature which would automatically recalculate results based on the changes to the input values. But if you want to temporarily disable this option then you can use the settings available as part of the Formulas Ribbon menu.

Step 1: Launch Excel Application and click the Formulas menu.

Step 2: Navigate to the Calculation section and click on the Calculation Options.

Step 3: Select Manual from the Calculation Options drop down list.

Now when ever user makes any changes to excel cell values and if any formula is based on these input cells then the result will not be automatically recalculated.

There is also an option available to do manual recalculation. Navigate to the Calculation section and click the Calculate Sheet available next to Calculation options.

Insert check mark in Microsoft Word

October 2, 2015 By Ravi Shankar 6 Comments

Insert check mark in Word 2010 and Word 2013

This tutorial provides steps required to insert tick or check mark in Word 2010, Word 2013 and Word 2016. The most common method is to use the option available as part of Insert > Symbol. Another alternate way is to change the font type to Windings 2 and use the shortcut key for adding the tick mark.

Insert Symbol

Step 1: In the word document, place the cursor to the position where you want to insert tick mark.

Step 2: Click Insert menu, navigate to Symbols section and click the down arrow available below Symbols

Step 3: Select More Symbols from the dropdown list.

Step 4: Select the tick symbol available under Symbol window.

If you do not see the tick symbol, then change the Font to Windings 2 and select the tick symbol from the list.

Changing font to Windings 2

The quickest way to insert tick mark is by changing the font type of your Word document to Windings 2 and then use Keyboard combination “Shift + P”.

How print only notes in PowerPoint

October 2, 2015 By Ravi Shankar Leave a Comment

We had seen the steps for adding notes in PowerPoint and now we will see how to print only notes in PowerPoint 2016, 2013 and 2010. The default print settings in PowerPoint is set to full slides and you can change this using the Print option.

Click File menu and then the Print menu option.

In the Print screen, navigate to Settings section then option with the arrow pointing downwards and label as Full Page Slides.

By selecting Notes Pages for Print Layout will print only the notes added for the slides.

Default Print Settings

If you want to change the default Print Layout for the presentation to Notes Pages then you can do the following.

Click File menu then Options link and in the Options window navigate to Advanced option.

Scroll down to “When printing this document” section and select the radio option Use the following print settings and set the value for Print what to Notes. Click Ok button to confirm and save the changes.

Insert and Save watermark in Microsoft Word

October 1, 2015 By Ravi Shankar Leave a Comment

In this tutorial we see the steps required to Insert, Save watermark in Word 2013, Word 2010 and Word 2007. Word users can insert a watermark in a document using the option available as part of the Page Layout menu.

Insert Custom Watermark in Word 2016, Word 2013 , Word 2010 and Word 2007

Step 1: Click on the Page Layout (Word 2010 and Word 2007) / Design (Word 2016 and Word 2013) menu then navigate to the Page Background section.

Step 2: Click the Watermark drop down under the Page Background section.

Step 3: Click the Custom Watermark option to add your own text for the Watermark.

Step 4: Now enter your text by selecting Text Watermark radio option and providing the required Text. Click the Apply button to add the Watermark to the document.

Insert Picture Watermark in Word document

If you want to insert picture watermark in the document then In the Printed Watermark window, choose Picture watermark radio option and select the logo that needs to be added as watermark. Then select appropriate Scale and Washout option for the Watermark. In this example, I have selected the logo of Digital Answers blog.

Step 5: Click Apply to have the preview of the Watermark. And if you are satisfied with the changes then click the OK button.

Save Watermark in Word 2013, Word 2010 and Word 2007

Step 1: Double click the Header section of document and select the Watermark as shown below.

Step 2: Click the Design menu (Word 2013) or Page Layout menu (Word 2010 and Word 2007) and navigate to the Watermark option under Page Background section. Then select Save Selection to Watermark Gallery from the drop down.

Step 3: In the Create New Building Block window, enter name for the Watermark and click OK button.

Newly saved Watermark should now be available as part of the Gallery.

Add line numbers in Word 2013, Word 2010 and Word 2007

September 27, 2015 By Ravi Shankar Leave a Comment

Microsoft Word users can add line numbers to a word document using the options available as part of Page Layout menu. In this tutorial we will see the steps for adding line number in Word 2013 and Word 2011 for Mac.

How to add line numbers in Word 2007, Word 2010, Word 2013 and Word 2011 for Mac

Word 2007 Word 2010 and Word 2013

Word 2010 allows users to add line numbers to a word document. This can be done using the Page Layout menu option. For example if you have the following text in your document and you want insert line numbers for each line then you use this feature.

To add line numbers for above paragraph, from Home menu click the Page Layout menu option and then navigate to Page Setup section.

In the Page Layout section, click the drop down arrow next to Line Numbers menu option. This would display the following menu options.

Now select Continuous from the list available menus and this would insert the line numbers in the Word document as shown below

The other line numbers options includes

Restart Each Page – To restart line numbers after each page.
Restart Each Section – To restart line numbers after each section.
Suppress for Current Paragraph – to remove line numbers for the selected paragraph.

Word 2011 for Mac

Step 1: Open the document for which you want to add line number.

Step 2: Click Layout menu and navigate to Text Layout section.

Step 3: Now click the Line Numbers option under Text Layout. This should display the following drop down list.

Step 4: Select Continuous from the Line numbers drop down list to add line numbers. You can also customise Line numbers by use other options in the list.

If you are looking for advanced line number options then click More Line Numbering.

Display of line number in status bar

If you just want to find out the current line number while editing a document then you can use line number option available as part of status bar for this purpose.

Word 2007, Word 2010 and Word 2013

Microsoft Word 2007 and Word 2010 provides option to display the line numbers in a word document. This would be a useful feature when you want to restrict your content based on the number of lines written in the document. If the status bar does not show the line numbers, then right click on the Status bar and select Line number.

After selecting Line Number option in the Customize Status Bar context menu, the status bar would display the line number as shown below.

Word 2011 for Mac

Word 2011 for Mac does not support the display of line number in status bar. This option is available in Window’s version of Microsoft Word but not in Mac OS X.

Also See: How to auto populate random sentences in Word 2010

« Previous Page