Tips

How to hide row and column headers in Excel

October 19, 2015 By Ravi Shankar Leave a Comment

Excel Worksheet by default displays the rows and columns header. For some reason if you want to hide these headers then you can use Excel Advanced Options. Listed below the steps to hide or unhide row and column headers in Excel 2016, Excel 2010 and Excel 2010.

Step 1: Click the File menu and then options link.

Step 2: In The Excel Options windows, select Advanced tab and scroll down to Display options for this worksheet section.

Step 3: To hide the rows and columns headers in a Excel 2010 worksheet, un mark the checkbox labelled as Show row and column headers.

Click OK button available at the bottom of the screen to confirm the changes.

Also See: How to hide header/footer while typing in Excel

How to check version of Excel

October 17, 2015 By Ravi Shankar Leave a Comment

In Excel 2016, 2013 and 2010, the version of excel can be checked using the Help or Account menu.

Click the File menu and select Help menu.

Navigate to the About Microsoft Excel section displayed on the right hand side. This would display the Excel Version details, as shown below.

Screenshot in Excel 2013

And if you want to see additional information then you can click on the Additional Version and Copyright Information. This would display the following About Microsoft Excel Window

Also See: Disable automatic conversion of hyperlink in Excel

How set paper size to A5 in Word

October 14, 2015 By Ravi Shankar 9 Comments

We had earlier covered about the steps required for changing the paper size in Word. And to this couple of readers had asked question on How to add A5 to the paper size list. So in case you don’t see A5 or any other paper size then use the custom paper size option available as Page Setup. Let us see how to add A5 paper size to the Page Setup in Word 2016, 2013 & 2010

Click File then Print menu and navigate to Settings section.

Click the drop down with value displayed as Letter. Then select the More Paper Sizes from the list.

In the Page Setup window, navigate to Page Size and set the value for the drop down to Custom Size. Then enter the Width and Height for A5 Paper Size as 5.8” and 8.3” respectively. Then click the OK button to confirm and save the changes.

Note :- If you are not sure about the Height and Width of Paper Sizes (4A0 to A10) then refer this website.

Prevent automatic insertion of current date in Word

October 13, 2015 By Ravi Shankar 9 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”.

« Previous Page