Enable

How to enable insert equation in Word

October 19, 2015 By Ravi Shankar 8 Comments

Word 2016, 2013 and 2010 provide users with the option to insert mathematical equations in a document. This is quite useful when you are preparing a word document with mathematical questions. Users can insert equations using the option available as part of the Office Ribbon’s Insert menu.

But when you open an existing document created in Word 2003, the equation menu option would be disabled.

This is because this feature is available only for document with extension as .docx and not doc. And to resolve this problem all you need to do is to resave the document in Word 2010 file format. Please make sure to pick the value for Save as type drop down as “Word Document (*.docx)”.

The following confirmation message would be displayed, click OK to continue with converting the document.

By this way you can enable the insert equation option in a Word document.

How to enable auto filter for protected sheet in Excel

October 10, 2015 By Ravi Shankar 11 Comments

We had already seen the following tutorials related with protection of worksheet in Excel 2016, 2013 & 2010.

Prevent users from adding new worksheet.
Password Protect Worksheet in Excel.
Unprotect Worksheet in Excel.

And if a worksheet with auto filter is protected then users will not be able to use auto filter unless it is enabled while protecting the worksheet. This tutorial is about the steps required for enabling auto filter for a protected worksheet in Excel 2010.

Click the Protect Sheet option available under Review menu or Info menu.

Review Menu

Click Review menu –> Changes –> Protect Sheet

Info Menu

Click File menu –> Info menu –> Protect Workbook –> Protect Current Sheet.

On clicking the Protect Sheet option would display the following Protect Sheet window.

Scroll down the “Allow all users of this worksheet to” list and make sure to tick the check box with caption as “Use AutoFilter”. Click OK button to confirm and save the changes.

Now excel users will be able to use the auto filter option even in a protected worksheet.

How to turn off display of screen tips in PowerPoint 2013 & 2010

July 20, 2015 By Ravi Shankar 1 Comment

PowerPoint 2013 and 2010 displays screen tips along with feature description when we hover the mouse over the menu items. By default screen tip feature is enabled in PowerPoint but if you do not want this extra information to be displayed then you can turn off using PowerPoint options.

Click File menu and then Options link

In PowerPoint Options under General tab, navigate to User Interface options.

Set the value for ScreenTip style dropdown to Don’t show ScreenTips and click OK to confirm and save the changes. This would disable the display of screen tips for all menu items in PowerPoint.

How to enable a disabled add-in in Excel 2010

December 27, 2014 By Ravi Shankar Leave a Comment

Office products such as Word, Excel Outlook will automatically disable installed add-in if any add-in prevented the software from functioning correctly. And it also provides option for enabling the disabled add-in items. In Excel 2010 you can enable a disabled add-in using the add-in options.

Click the File menu –> Options link –> Navigate to Add-Ins options.

Select Disabled Items in the Manage dropdown and click the Go button. This would display the following Disabled Items window using which you can see and also re-enable the disabled add-in. You can select the ones you wish to re-enable and click the Enable button.

How to disable advance slide on mouse click in PowerPoint

November 12, 2014 By Ravi Shankar 5 Comments

In this short beginners PowerPoint 2013 and PowerPoint 2010 tutorial, we will see the steps to disable advance slide on mouse click. During a slide show, you can move to next slide either by pressing ENTER or SPACEBAR on keyboard or on mouse click. And using Transitions menu, you can disable or enable the advance slide on mouse click.

Click the Transitions menu and navigate to Timing section

If you want to disable the feature, then un mark the check box labelled as On Mouse Click.

Also See: Start PowerPoint Slide Show using Windows Explorer

How to enable autocomplete in Google Docs Spreadsheet

August 24, 2011 By Ravi Shankar 5 Comments

Autocomplete feature helps users by automatically filling the content of cell when users starting entering the first couple of letters in the Cell. The automatic entry is picked from the previously entered values for the same column.

Let us say you have got the following list of entries in one of the column

Arizona
Alabama
California
Florida
Indiana

Now when you start typing Ar in the cell below Indiana, Spreadsheet will automatically display Arizona based on the entries done earlier for that column. And when you press enter this value will be automatically filled for that cell.

You can enable Autocomplete feature in Google Spreadsheet by clicking the Tools menu and selecting Enable AutoComplete from list of available menus.

Remember that if there is a empty cell before the active cell then Autocomplete feature will try to pick from the below column values.

Display Date Created in finder view on Mac OS

August 18, 2011 By Ravi Shankar 2 Comments

The Finder view on Mac OS by default does not display the Date Created field for the documents, folders and other items. And if you want to know the date created for these items then you can enable this using Finder View options.

In the Finder View Options window, tick the check box with label as Date Created.

This would display the Date Created column for the respective items as shown above.

How to archive Email messages in iPad 2

July 6, 2011 By Ravi Shankar Leave a Comment

Email accounts configured in iPad 2 allows user to archive the email messages. you can turn on the archive feature using iPad Mail settings. The archive email message option will be available when you touch and swipe on the email message or if you tap the trash icon.

When you swipe on the email message

When you tap the trash icon.

The above screenshots shows that archive message feature is disabled for the configured email account. To enable archiving for the email account, from iPad home screen tap the settings icon. In the Settings screen, navigate to Mail, Contacts, Calendars settings and then select email account to turn on archiving of email messages.

In the select mail account, navigate to Archive Messages section.

Tap and swipe Archive Messages to turn on the feature as shown below.

Now when you swipe on any email message the Archive option will be shown as shown below.