Ravi Shankar – Page 13 – Tweaking Apps

Apply single or double strikethrough in Word

October 9, 2015 By Ravi Shankar Leave a Comment

Apply single/double strikethrough in Word 2010, 2013 & 2016

Microsoft Word allows users to apply strikethrough and double strikethrough using the options available as part of Font dialog.

For example if you want apply strikethrough for a paragraph in word document then you can do the following

Select the paragraph and press Ctrl + D on the keyboard or click the option handle available as part of Font section under Home menu.
This should launch the following Font dialog box

Now navigate to Effects section and mark the check box with label as Double strikethrough. Click OK to confirm and save the changes.
This would apply the Double strikethrough to the selected paragraph.

How to permanently change default font in Word

October 9, 2015 By Ravi Shankar Leave a Comment

The default font in Word 2016, 2013 & 2010 when a new word document is opened is Calibri. If you want to change the font for the current document then you can use the drop down available as part of the Font section. But if you want to set as the default font for all the new documents then you can do this in more than one way.

This can be done either by changing the font in Normal template but the easiest one is by using the Change Styles option.

To permanently change the default font in Word, navigate to styles section and click the Change Styles drop down and select Fonts option from the menu option.

Now select your desired Font either from the Built-in fonts or by creating new themes fonts.

After selecting the font click the Set as Default available as part of Change Styles menu option. This would set the font as the default one when you create a new document.

How to change worksheet theme in Excel

October 8, 2015 By Ravi Shankar Leave a Comment

In this short tutorial we will be seeing how to change theme of worksheet in Excel 2016, Excel 2013 & Excel 2010. You can change the theme using the option available as part of the Page Layout menu.

Navigate to Page Layout and click the Themes menu option under Themes section. The themes option allows users to change the overall design of the worksheet including fonts, colors and effects.

From the Themes drop down, you can pick any theme from the built-in list. If you want to look for more themes then you can download themes from office.com and select it using the Browse For themes option. Excel 2010 also provides option to save the current theme for future re-use.

How to create timeline using Word

October 6, 2015 By Ravi Shankar Leave a Comment

Word 2016, 2013 & 2010 have a feature that helps users to create timeline in a Word document. Listed below the steps that can be followed for creating a timeline.

Step 1: Navigate to Insert menu, click the SmartArt option under Illustrations section

Step 2: This would display the following Choose a SmartArt Graphic window as shown below.

Step 3: Click the Process section then scroll down and select a timeline option.

You can either select Circle Accent Timeline or Basic Timeline.

Step 4: A window for typing the timeline text will be displayed along with the Timeline as shown below. This window allows you to type the text for the timeline.

For example if you wanted to make a timeline for Word Cup T20 Cricket Winners.

A finished timeline will look as shown below.

How to clear the trash folder in Outlook

October 6, 2015 By Ravi Shankar 1 Comment

This is tutorial provides instruction for clearing all the items in Outlook 2016 & Outlook 2013 trash folder.

Step 1: Click the Outlook File menu then navigate to Info section.

Step 2: In the Account Information screen, navigate to Mailbox Cleanup section and click the Cleanup Tools arrow pointing downwards.

Step 3: Select Empty Deleted Items Folder from the Cleanup Tools drop down list.

Step 4: Click the Yes button to permanently delete all the items in the Trash folder.

When you have lots of items in your trash folder and want to clean up on a single click then you can use this feature.

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”.

« Previous Page