• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

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.

Word 2010 Insert Equation

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

Equation Diasabled

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

File Save as type .docx

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

image

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

Filed Under: MS Office, Word 2010, Word 2013, Word 2016 Tagged With: Enable, insert equation, mathematical, Word 2003, Word 2010

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

Review menu - Protect Sheet

Info Menu

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

Info Menu - Protect Sheet

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

Protect Sheet Excel 2010

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.

Protected Sheet with auto filter

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016 Tagged With: auto filter, Enable, Excel 2010, Protect, 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.

image

Click File menu and then Options link

image

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

image

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.

image

Filed Under: Office 2010, PowerPoint 2010 Tagged With: Disable, Enable, menu items, Powerpoint 2010, screen tip, ScreenTips, Turn Off

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.

Excel 2010 Add-ins

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.

image

Filed Under: Excel, Excel 2010, Office 2010, Outlook 2010 Tagged With: Add-in, disabled items, Enable, Excel 2010, Office 2010, re-enable

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

Enable or disable on mouse click option in PowerPoint 2013 and PowerPoint 2010

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

Filed Under: MS Office, PowerPoint 2010, PowerPoint 2013 Tagged With: Disable, Enable, mouse click, Office 2010, Powerpoint 2010, Slide Show

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.

Filed Under: Excel, Technical Tagged With: Autocomplete, Enable, Google, Google Docs, spreadsheet

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.

Filed Under: Apple, Mac, Mac OS X Tagged With: Date Created, Enable, Finder View, Mac OS, Show View

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

image

When you tap the trash icon.

image

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.

image

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

image

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

image

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

image

Filed Under: iPad Tagged With: Archive Email, Delete Message, Disable, email, email account, Email Messages, Enable, iPad 2

  1. Pages:
  2. 1
  3. 2
  4. »
Next Page »

Primary Sidebar

TwitterLinkedin

Recent Posts

  • How to block keywords in Jio broadband
  • How to disable opening an app automatically at login in Mac
  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy