Office 2007

How to increase number of worksheets Excel

March 18, 2016 By Ravi Shankar Leave a Comment

Microsoft Excel by default contains 3 worksheets while creating a new Workbook. For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain. This can be modified using Excel Options. Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013, Excel 2010 and Excel 2007

In Excel 2013 and Excel 2010 –> Click on File menu and then Options.

In Excel 2007 –> Click on Excel Options and then Popular menu.

Under When creating new workbooks section there is include this many sheets fields. This can be used for increasing the number worksheets while creating a new workbook. The minimum value is 1 and the maximum is 255. Check out the below video demo to increase worksheets size in Excel 2013

Also See: How to move or copy worksheets in Excel 2013

Repeat action keyboard shortcut in Microsoft Office

November 18, 2015 By Ravi Shankar Leave a Comment

Microsoft Office Applications such as Word and Excel, last action can be repeated using keyboard shortcuts. For example if you have formatted a word with specific style and you want to repeat/apply the same format for other words then you can press F4 or Ctrl + Y or Alt + Enter. This can be used for copying drawings or formatting excel cells thus reducing the steps and saves time.

Change the keyboard shortcut for Repeat Action

Microsoft Office users can change the keyboard shortcut associated for Repeat action using Settings. Let us see these steps in Word 2016 & 2013

Step 1: Click File menu then Options and navigate to Customize Ribbon

Step 2: In the Customize Ribbon screen, click Customize button available next to Keyboard shortcuts.

Step 3: In the Customize Keyboard window, select All Commands under Categories and pick EditRedoOrRepeat under Commands. You should be able to see the keys that are currently associated with Repeat action.

Step 4: Navigate to Press new shortcut key option and enter the keyboard shortcut.

Step 5: Click Assign to confirm and apply your changes.

Save messages in sent items folder in Outlook

August 12, 2015 By Ravi Shankar 7 Comments

Microsoft Outlook automatically saves the sent messages in sent items folder. But if you do not want to automatically save the sent messages then you can turn off this feature using Outlook Options. Listed below are steps to enable or disable saving copies of messages in Sent Items folder in Outlook 2013, Outlook 2010 and Outlook 2007.

Outlook 2013 and Outlook 2010

Click the File menu –> click the Options link . In the Options window select the Mail tab and scroll down to Save Messages section.

You can turn off or disable the save sent messages sent items folder by un marking the checkbox with label as Save copies of messages in the Sent Items folder.

Save message in Sent Items for single message in Outlook 2013 and Outlook 2010

The above settings would affect all the message but if you want to specify only for selected messages then you can use the options available as part of Message window.

In the message window, navigate to Options menu then to the more options section.

Click the down arrow available below the Save Sent Item To menu option.

The different options that are available are

Use Default Folder – This would save the sent messages in the default sent items folder.

Other Folder – This allows users to specify the folder where this messages needs to be saved.

Do Not Save – This will not save the sent messages to any folder.

Outlook 2007

In Outlook 2007 to enable or disable “Save copies of messages in Sent Item folder”, Click Tools ->Options -> Email Options

Under Message Handling section, by checking Save copies of messages in Sent Items folder, messages that are being sent would be saved to Sent Items folder.

Also See: How to automatically save messages in Outlook 2010

How to use Outlook as a RSS reader

July 23, 2015 By Ravi Shankar 9 Comments

There are lot of RSS readers available but if you have already installed Microsoft Outlook (Outlook 2013, Outlook 2010 and Outlook 2007) then you can use that as a RSS reader. Listed below are the steps to add and read RSS feeds In Outlook 2013, Outlook 2010 and Outlook 2007

In Outlook 2013 and Outlook 2010, Click the File menu –> Info and click on the Account Settings

In Outlook 2007, Click the Tools menu and select Account Settings

Navigate to RSS feeds tab and click on New link

Enter the RSS feed of a blog or a website. In this example, I am going to enter this tech blog RSS feed.

Click on the Add button to add the RSS feed. The following RSS Feed Options dialog box would be displayed and if you want to change the delivery location of the RSS feed then click on the Change Folder button and specify the desired location. Click Ok to confirm the changes.

Navigate to RSS Feed delivery location, this would display the RSS feeds from the configured tech blog

How to share RSS feeds in Outlook 2013, Outlook 2010 and Outlook 2007

If you want to quickly mail the configured RSS feed to your email contacts then you can follow the below mentioned steps.

You can share the feed using the Share This Feed option available as part of Context menu or using Office Ribbon

Context menu – Right click on the any one feed post and select Share This feed option from the menu list.

Office Ribbon – Select the feed that you want to share then navigate to RSS section under Home menu and click the Share This Feed option.

This would launch the following Share RSS Feed window where you can enter the recipients email address and email them the feed details.

Also See: How to configure RSS feeds from YouTube channel in Outlook 2013

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 enable auto spell check in Outlook 2013, 2010, 2007

October 12, 2014 By Ravi Shankar Leave a Comment

Microsoft Outlook provides auto spell check similar to the auto spell feature available in Word. Listed below are the steps to enable spell check feature as you type message in Outlook 2013, Outlook 2010 and Outlook 2007.

Enable auto spell check as you type in Outlook 2013 and Outlook 2010

Click File menu and select Options from the list.

In the Outlook Options window, click Editor Options under Compose messages section in Mail tab.

Navigate to “When correcting spelling in Outlook section” and make sure to enable check box with caption as “Check spelling as you type”

Turn on check spelling as you type in Outlook 2007

In Outlook 2007, click Tools -> Options menu

Under Mail Format click on the Editor Options button. This would display the Editor Options window. Click on the Proofing section and tick the check box Check spelling as you type under When correcting spelling in Outlook section. This would enable the auto spell check in Outlook 2007.

Also See: How to enable automatic spell check in Microsoft Word

How to hide date and time when viewing notes in Outlook

October 12, 2014 By Ravi Shankar Leave a Comment

Microsoft Outlook notes displays the date and time at the bottom of the note. And outlook also provides option for displaying as well as hiding the date and time information.

Listed below are the steps to turn of display of date and time when viewing notes in Outlook 2013, Outlook 2010 and Outlook 2007.

Outlook 2013 and Outlook 2010

To turn off the display of date time in Outlook 2013, Outlook 2010 notes, Click on the File menu –> Options. Navigate to Notes and Journal tab and under Notes options

un tick the check box Show date and time that the Note was last modified. Click Ok to save this change. Now the notes will be displayed with out the last modified date and time as shown below.

Disable display of date and time in Outlook 2007 notes

In Outlook 2007, this option is available under Tools –> Options –> Other tab –> Advanced Options.

In Advanced Options window under Appearance options, a check box “When viewing Notes, show time and date” is available. By selecting this checkbox, the time and date will be displayed when viewing notes.

If the checkbox is unselected then time and date information will not be displayed when viewing the notes

Also See: How to change notes colour, size and font in Outlook

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