Office 2010

Change the default file location in Excel 2013 and Excel 2010

May 28, 2015 By Ravi Shankar 1 Comment

We have already seen the following articles on Microsoft Word 2010 and Microsoft PowerPoint 2010.

How to change default file location in Word 2010.
How to change default file location in PowerPoint 2010.

In this tutorial we are going to see how to change the default file location in Microsoft Excel 2013 and Excel 2010.

Click the File menu on Microsoft Excel and then the options link.

In the Option window, navigate to Save workbooks section under Save option. Windows Vista and Windows 7 operating system will have the default file location set to their users document folder. Now change this to your preferred working folder by making the necessary changes to Default file location property. After making the change, click Ok button to confirm and save the changes.

del.icio.us Tags: Excel 2010,default file location,Change file location

Change undo limit in Excel 2013 and Excel 2010

May 22, 2015 By Ravi Shankar 3 Comments

As per the Excel Specifications and limits the maximum limit for undo in Excel 2010 is set to 100. In the previous version of Excel this was set to 16. The maximum limit value is fixed but you can increase or decrease this limit by modify registry settings.

Please Note:- Changing Registry Settings is not recommended and do this with at most caution while trying these changes.

To change the undo maximum limit, Open Windows Registry Editor and then navigate to the following path

HKEY_CURRENT_USER –> Software –> Microsoft –> Office –> 14.0->Excel->Options

Create a new DWORD value with the key name as UndoHistory

Then modify UndoHistory by setting the Base as Decimal and value as 16. Click the OK button to save the changes.

This would decrease the number of undo same as the previous of Excel. You can also increase the undo limit from 100 to 200 for Excel 2010 by changing the above created Windows Registry key.

Outlook 2013, Outlook 2010 and Outlook 2007 – Clear email addresses in auto complete list

May 21, 2015 By Ravi Shankar 3 Comments

Microsoft Outlook suggest names while typing in To or Cc or Bcc fields. This is useful when you want to quite include already used email address. But there would be scenarios where you would like to disable this feature. Outlook provides option to turn on/off suggestion and also clear Auto-Complete list (available only in Outlook 2013 and Outlook 2010). Listed below are the steps turn off suggesting names in Outlook 2013, Outlook 2010 and Outlook 2007

Outlook 2013 and Outlook 2010

Click File menu then Options followed by Mail tab.

In the Mail Options screen, navigate to Send messages section and un mark the check box with caption as “Use Auto-Complete List to suggest names when typing in the To, Cc and Bcc lines”. If you want to just clear the listed names then click Empty Auto-Complete List option.

Outlook 2007

In order disable this feature in Outlook 2007, navigate to Tools menu and select Options from the menu list. This would display the Options dialog box

And click on the Email Options button and then the Advanced Email Options

This would display the following Advanced E-mail Options dialog box. And by un checking Suggest names while completing To, Cc, and Bcc fields, complete names feature would be displayed.

Also See: Missing BCC field in Outlook 2013

How to change text case in Word 2013 and Word 2010

May 6, 2015 By Ravi Shankar Leave a Comment

Microsoft Word 2013 and Word 2010 allows users to change the CASE of the selected text using the Change Case option available as part of the Home menu. For example if you have the following text in your word document and you want to change the CASE by capitalizing each word.

Then select above the text in the Word document and navigate to Font section in Home menu. Click the drop down arrow below Aa.

This would display the following menu option

Select Capitalize Each Word option from the list of available menus. Similarly the other CASE related options includes changing the selected text to the following

Sentence case
lowercase
UPPERCASE
toGGLE case

Change the page colour in Word 2010 and Word 2013

May 5, 2015 By Ravi Shankar 2 Comments

The standard page colour of a word document is white. But in Word 2013 and Word 2010, you can also change the page colour using the Page Layout menu option. You can do the following to change the word document page colour in Word 2010.

From the File menu, click Page Layout menu option

Navigate to Page Background section.

To change the page colour, click the drop down arrow below the Page Colour option select your desired colour.

If you want to see more colours, then click the More Colours option to launch the Colour Palette.

If you want fill with effects then click Fill Effects menu to bring the Fill Effect dialog box.

Changing column width in excel 2013 and excel 2010

May 4, 2015 By Ravi Shankar 1 Comment

There are different ways for changing the column width of cell in Excel 2010 and Excel 2013. Some of them are listed below

Double Clicking Column Header

The easiest one for adjusting the column width is to double click the Column Header of cell whose width needs to be changed depending on the longest length of text entered in the Cell. The mouse pointer needs to placed on the border line before doing a double click

Using Mouse Drag and Drop

Another way for changing the column width is to use mouse drag and drop feature and adjust the cell column width depending upon the requirement.

Using Format menu option

Excel also provided option for changing the column width by using the Format menu option. In the home menu, navigate to Cells section and click the drop down arrow below the Format menu option.

This would display the following list of available menus.

To Change the column width of the selected cell, select Column Width from the available menus and enter the desired column width for the cell in Column width text box.

And if you want to change the width for all the columns in the Worksheet then select Default Width menu from Format menu option and specify the Standard Width in Standard column width text box.

How to change the Page Size in Word 2010 and Word 2013

May 1, 2015 By Ravi Shankar 9 Comments

Page Layout menu option in Word 2013 and Word 2010 provides users with option for changing the page size. In case if you want to change the page size from the standard A4 size to A3 then you can use this feature.

From the Home menu, navigate to Page Layout menu.

In the Page Layout menu, navigate to Page Setup section.

To change the Page Size for the Word document, click the drop down arrow below the Size menu option and select your preferred size for the Word document.

If you want to change the page size only during the printing of the document, then you can use the Print option for this purpose.

Click the File menu and then the Print menu. Then navigate to the Settings section on the right hand side.

This has an option for setting the page size for a document as shown below.

Find mails older than specified days in Outlook

April 15, 2015 By Ravi Shankar 1 Comment

Outlook 2013 and Outlook 2010 has a feature using which the users can search for mails older than specified days. This is an useful feature if you want to look only in emails that are older than certain time period. This feature available as part of the Mailbox Cleanup options.

To find mails older than N number of days, click File menu and then navigate to Info menu

Click the drop down arrow available below Cleanup Tools option. And then select Mailbox Cleanup from the list of available menus.

In the Mailbox Cleanup window, navigate to find section and select the radio option Find items older than and specify the number of days.

Clicking the Find button would display the list of mails which are older than N number of days.

« Previous Page