Office 2010

Create Search Folder with Criteria in Outlook

July 9, 2015 By Ravi Shankar Leave a Comment

Outlook 2013 and Outlook 2010 have feature known as Search Folder which allows users to create new search folder for displaying messages based on criteria. For example a search folder can be created to include all follow up flags and unread messages.

Click the Folder menu option in Outlook Office Ribbon then navigate to the New section. If you want to create a search folder that would list all the message with text Spam then click the New Search Folder. This would display

the following New Search Folder window. Then navigate to Custom section and select Create a custom Search Folder. To specify the criteria for the search

folder, click the Choose button and enter the name for your Custom Search Folder then Browse and select folder from which the mails will be included for Search Folder.

Note :- This feature can do a search of only one mail account. If you have more than one mail account configured in your Outlook then you will have to create separate Custom Search Folder for individual mail accounts.

Clicking the Criteria button would then display the following Search Folder Criteria window. Enter “Spam” in Search for the word(s) field and click on OK button to save the entered Criteria.

Confirm the action by clicking OK button on Custom Search Folder window and New Search Folder window. Now a new search folder “Spam” will be available in Navigation Pane under the Search Folders with list of message containing the text Spam.

Change default file location in PowerPoint 2013 and 2010

June 22, 2015 By Ravi Shankar Leave a Comment

In PowerPoint 2013 and PowerPoint 2010 the default file location set as C:\Users\<username>\Documents\ in a Windows Vista or Windows 7 Operating System. This is the location that will be shown and used as the default location when a user tries to save a presentation file.

PowerPoint provides users with option for changing this default file location to some other folder of your choice. Listed below are the steps to change the default file location in PowerPoint 2010,

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

Step 2: In PowerPoint options window, navigate to Save options and then to the Save presentations section.

Step 3: In Save presentation section, set the folder of your choice for Default file location. For example if you set it to C:\Projects then the Save or Save As option would now default to the newly set folder location as shown below.

Different page size in the same document in Word 2013 & Word 2010

June 15, 2015 By Ravi Shankar 2 Comments

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

Is it possible to set a different page size, for one page, within a document of another page size. I have a multipage document in A4, I want to insert an A3 page size in the middle in landscape orientation, so I can fit a drawing onto the page.

Word 2013 & Word 2010 allows users to have different page size in the same document using Section. We had already seen how to use Section break for removing page number from selected pages. And now to have A4 and A3 page size, follow the below mentioned steps.

Step 1: Open the Word document for editing.

Step 2 : Navigate to the page below which you want to insert A3 page.

Step 3: Select Page Layout from the menu then click the Breaks option under Page Setup.

Step 4: From the drop down, select Next Page under Section Breaks.

Step 5: After the new page has been inserted, click the Size option under Page Setup and select A3 from the list of available page sizes.

By this way Word 2013 and Word 2010 users can have different page sizes in the same document.

Type fraction numbers in Word 2013 & Word 2010

June 13, 2015 By Ravi Shankar Leave a Comment

If you are preparing any word document that requires you to type fraction numbers then you can use the Insert Equation feature available in Word 2013 and Word 2010. Let us say you want to type the fraction numbers 3/15 + 8/15 = ? then you can do the following Word 2013 or Word 2010

Click the Insert menu and navigate to Symbols section.

Then click the Equation option available under the Symbols section. This should insert the Equation place holder in the document as shown below.

Now type the fraction number in the Equation text box and press Enter. This would display the fraction number in the default format.

If you want to change the fraction format or any complex fraction needs to be entered then you can use the Fraction option available under the Structures section.

Different page size in the same document in Word 2013 & Word 2010

June 11, 2015 By Ravi Shankar

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

Is it possible to set a different page size, for one page, within a document of another page size. I have a multipage document in A4, I want to insert an A3 page size in the middle in landscape orientation, so I can fit a drawing onto the page.

Step 1: Open the Word document for editing.

Step 2 : Navigate to the page below which you want to insert A3 page.

Step 3: Select Page Layout from the menu then click the Breaks option under Page Setup.

Step 4: From the drop down, select Next Page under Section Breaks.

Step 5: After the new page has been inserted, click the Size option under Page Setup and select A3 from the list of available page sizes.

By this way Word 2013 and Word 2010 users can have different page sizes in the same document.

Change the default file format in PowerPoint 2013 and PowerPoint 2010

June 1, 2015 By Ravi Shankar Leave a Comment

This tutorial explains how to change the default file format in PowerPoint 2013 and PowerPoint 2010 while saving a Presentation file. This is useful when most of your organization users are still using Office 2003. As the Office 2003 users will have compatibility issues when they open a presentation file created using PowerPoint 2010. To fix the issue you can change the default file format for saving a file to be compatible with Office 2003.

Click the file menu and then the options link. In the PowerPoint options window, navigate to Save options.

In the Save Options screen, navigate to Save presentation section and using the Save files in this format drop down you can set the PowerPoint presentation file to be compatible with Office 2003.

After setting the value to PowerPoint Presentation 97-2003, click Ok to confirm and save the changes.

BuzzNet Tags: PowerPoint 2010,default file format,change file format,Save Presentations

Password protection in PowerPoint 2013 and PowerPoint 2010

May 29, 2015 By Ravi Shankar Leave a Comment

The tutorial explains the different ways to password protect a presentation file in PowerPoint 2013 and PowerPoint 2010. You can password protect a presentation in PowerPoint 2013 and PowerPoint 2010 by the following ways

1. Using Info Menu

Click File menu followed by Info and then navigate to Permission section.

Click the down arrow available below the Protect Presentation option and select Encrypt with Password from the drop down list.

This would display the following Encrypt Document window. Enter the password for protecting the file and click OK to save the changes.

Repeat the same as Encrypt Document window for the Confirm Password window as well.

A password protected presentation will be highlighted as shown below.

2. Using File –> Save As

The other alternate way to protect a presentation file is to use the General Options same as password protection of a PowerPoint 2007 presentation. Click the File mu then the Save As option. In the Save As dialog box, select General Options available as part of tools drop down list.

Using the General Options, you can set password to open as well as password to modify a PowerPoint presentation file. After entering the required details, click OK to confirm and save the changes.

To remove password protection for a presentation, Navigate to Protect Presentation section as discussed earlier and select the Encrypt Password from the list. Now clear the password that was already set for the Presentation then click OK to confirm the changes.

How to recover a workbook in Excel 2013 and Excel 2010

May 29, 2015 By Ravi Shankar 1 Comment

This tutorial explains the auto recover feature available in Excel 2013 and Excel 2010. The auto recover feature regularly takes a backup of the workbook and stores it in a pre defined location. This feature is useful if Excel suddenly crashes and you want to recover the working copy.

Document Recovery

A document recovery pane will be displayed on the left hand side of the Excel worksheet when excel is opened after a crash.This would contain the workbook(s) which were kept open during the crash.

If you want to recover any of the displayed workbook, then select the required file from the available files list.

Change AutoRecover file location

You can specify the path for auto recovery feature using Save workbooks Options. Click the File menu then Options link and then navigate to the Save tab.

Again navigate to the Save workbooks section in Save Options screen. Using AutoRecover file location you can specify the path for automatic backup.

Change AutoRecover Time interval

Using Save AutoRecover information spinner field you can increase or decrease the minutes at which the auto save needs to happen.

Disable AuoRecovery

We have seen the importance of AutoRecovery feature in Excel and by default this is enabled. But Excel also provides option for disabling this feature.

You can disable this by navigating to AutoRecover exceptions section then un tick the checkbox with label as Disable AutoRecover for this workbook only.

Any changes made to this would get reflected after clicking on the OK button available at the bottom of the Save options screen.

del.icio.us Tags: Excel 2010,auto recover,auorecovery,workbook,backup,file location,time interval

« Previous Page