Office 2010

Disable conversion of two numbers with hyphen as date in Excel

July 14, 2014 By Ravi Shankar Leave a Comment

Microsoft Excel has a feature that automatically coverts two numbers separated by hyphen in to a date formatted value. For example if you type 6-7 in a cell, Excel would reformat this in to a date value as 7-Jun. But if you do not want to reformat then you can use any of the below mentioned solutions to disable this feature.

Solution 1: Prefixing the values with apostrophe

The simplest solution is to add apostrophe before 6-7. This would display the typed value without reformatting it.

Solution 2: Change format to Text Format

Another alternate solution is to change the formatting of the cell to Text format. Select the cell (or columns), right click and pick Format Cells from the menu list.

In the Format Cells window, select Text Format under Number tab and click OK button to apply the changes.

Also See: How to prefix cell entry with zero in Excel 2013

How to change starting page number in Excel 2010

July 19, 2012 By Ravi Shankar Leave a Comment

This post is in reply to the query posted by a reader that

My footer is starting with zero. Why?
I want it to start with one.

Excel 2010 footer page number by default starts with number 1and you can change the starting page number using the Page Setup option.

Step 1: Click the File menu and navigate to Print option.

Step 2: In the Print screen, click the Page Setup link available at the bottom.

Step 3: This would display the following Page Setup window.

Enter the starting page number for you footer in the First page number field. If you want to have the default behavior then keep the value as auto.

Step 4: Click OK button to confirm and save the changes.

By this way you can customize the starting page number in Excel 2010.

del.icio.us Tags: Excel 2010,starting,page number,first page number,change

How to insert math symbols in Word 2010

March 13, 2012 By Ravi Shankar 2 Comments

Word users can use the insert equation option to add mathematical equation to a document. Similarly to add any Math’s Symbol, you can use Insert –> Symbol feature. This is quite useful when you are preparing Mathematics Questionnaire using Word 2010.

For example, if you want to add non equality operation, then navigate to Insert menu, click the Symbols option and pick non equality symbol from the drop down list.

If you can not find the symbols in the above list then you can click the More Symbols menu option and pick the extended list.

Another alternative way to add mathematic operation in a Word document is by using the insert Object option. Navigate to Text section under Insert menu and click the Object menu option.

Then from the Object window, select Microsoft Equation 3.0 from the Object Type list and click the OK button.

Now you can select the required symbols from the Equation window.

del.icio.us Tags: Word 2010,mathematical,insert symbols,Operation,math equation

How to hide header/footer while typing in Excel 2010

February 7, 2012 By Ravi Shankar Leave a Comment

This is in response to question asked by a reader of this blog related with header and footer in Excel 2010.

how do I make the header / footer not visible on the page while typing?

When you click on the insert header and footer option in Excel 2010, excel would immediately change the view to Page Layout. Hence you would see the newly added header and footer in your worksheet.

After typing the required header and footer details and do not want to see header and footer while typing you excel sheet in the data section then you can change the view to Normal by selecting Normal under the Workbook Views section.

This would temporarily hide the inserted header and footer in the Worksheet and you can always get it back by changing the Workbook view to Page Layout.

del.icio.us Tags: Excel 2010,Header,Footer,Hide,Workbook,Worksheet,Views,Normal,Page Layout

Turn off auto replace of hyphens with dashes in Word 2010

December 14, 2011 By Ravi Shankar 1 Comment

AutoCorrect in Word 2010 has a feature which automatically converts two consecutive hyphens in em dash (__). For example when you have words connected with hyphens like June—December (with two hyphens) will be changed to June—December (with em dashes). This feature is by default enabled on Microsoft Word 2010.

Turn off hyphens with dash feature

Users can turn off the auto replacement of hyphens with dashes using the option available as part of AutoCorrect settings. Click the File menu –> Options link and navigate to Proofing Option screen then click the AutoCorrect Options button in the Proofing screen.

In the AutoCorrect window, click the AuoFormat As You Type tab and navigate to Replace as you type section.

Now unmark the check box with label as Hyphens (–) with dash (—) and click OK button to confirm and save the changes.

del.icio.us Tags: Word 2010,auto,replace,hyphens,dashes,turn off,autocorrect

How to turn off ordinals with superscript in Word 2010

December 12, 2011 By Ravi Shankar Leave a Comment

Microsoft Word 2010 has a feature that automatically replaces ordinals with superscript. But if you do not want this feature then you can turn off using the option provided as part of AutoCorrect settings.

Example of ordinals with superscript

1st displayed 1^st

2nd displayed as 2^nd

Disable ordinals with superscript

Click the File menu then options link. In the Word Options window, navigate to Proofing section and click the AutoCorrect Options button.

Click the AutoFormat As You Type tab in AutoCorrect window and navigate to Replace as you type section. Now to disable ordinals with superscript feature, un mark the check box with label as Ordinals (1st) with superscript and then click Ok button to confirm and save the changes.

del.icio.us Tags: turn off,ordinals,superscript,word 2010,disable,AutoCorrect,proofing

How to recover deleted folders in Outlook 2010

September 29, 2011 By Ravi Shankar 34 Comments

In this tutorial we will see how to recover a deleted folder in Outlook 2010. Let us take the following example to show recovery of deleted folders. Let us say you have deleted a folder named “resources” under Inbox by right clicking on the folder and select Delete Folder from the menu list.

Now to recover the deleted folder, navigate to Deleted Items folder under your email account and expand it. This would display the deleted folder “resources”along with the outlook items.

You can drag and drop the folder to your inbox and restore to place where it was before.

From the right click context menu, if you have selected Delete All menu option then it deletes only the outlook items inside the folder and leaves out the folder. To recover the deleted outlook items, navigate to Deleted Items folder and restore the individual items.

del.icio.us Tags: Outlook 2010,deleted items,recover,deleted folder,Delete All

Find repeated words in Word 2010

August 2, 2011 By Ravi Shankar 2 Comments

Microsoft Word 2010 has a feature that checks for the occurrence of repeated words in a word document. For example if you have typed a word twice continuously then the second word will be highlighted for as shown below.

Also Word provides the user with option for deleting the repeated word. The find repeated word feature is by default enabled and you can turn off this check using the Word Proofing options.

Turn off repeated word check

Click the file menu then the options link. In the Word Options screen, click the Proofing option and then navigate to When correcting in Microsoft Programs section.

Un tick the checkbox with label as Flag repeated words to disable the repeated word check in Word 2010. Click on the OK button available at the bottom of the page to confirm and save the changes.

del.icio.us Tags: Word 2010,Repeated Word,Check,Find,Turn Off,Disable

« Previous Page