• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

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.

increase sheets in Workbook in Excel 2013

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

Excel Options in Excel 2007

Increase worksheets for new workbook in Excel 2007

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

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, Office 2007, Office 2010, Office 2013 Tagged With: Decrease sheets, increase sheets, Workbook, Worksheets Size

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

Customize Keyboard Shortcuts in Microsoft Office

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

Change keyboard shortcut for Repeat Action

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.

Filed Under: Excel, MS Office, Office 2007, Office 2010, Office 2013, Office 2016 Tagged With: Microsoft Office, Office 2007, Office 2010, Office 2013

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.

Save copies of messages in the Sent Items folder in Outlook 2013

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.

Save Sent Item to Outlook 2010

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

Do Not save message Outlook 2013

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.

Select Folder Outlook 2010

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

Save messages in Sent Items folder in Outlook 2007

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

Filed Under: Office 2007, Office 2010, Office 2013, Outlook 2007, Outlook 2010, Outlook 2013 Tagged With: Disable, Message copy, Outlook, Save messages, sent items, trun off

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

Account Settings in Outlook

Navigate to RSS feeds tab and click on New link

Add RSS feeds in Outlook 2013, Outlook 2010, Outlook 2007

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

image

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.

Configure RSS feeds options in Outlook

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

Outlook 2013, Outlook 2010 and Outlook 2007 as RSS Reader

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.

Conext Menu Share This Feed

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.

Office Ribbon - Share This Feed

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

Share This Feed Window in Outlook 2010

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

Filed Under: MS Office, Office 2007, Office 2010, Office 2013, Outlook 2007, Outlook 2010, Outlook 2013 Tagged With: Configure RSS Feed, Outlook 2010, RSS Feed, RSS Reader, Share RSS feed

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 To, Bcc, Cc field suggesting names

Outlook 2013 and Outlook 2010

Click File menu then Options followed by Mail tab.

Turn Off suggesting names in Outlook 2013 and Outlook 2010

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

Microsoft Outlook 2007 E-mail Options

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

Advanced E-mail Options in Outlook 2007

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.

Suggest names while completing To, Cc, and Bcc fields

Also See: Missing BCC field in Outlook 2013

Filed Under: Office 2007, Office 2010, Office 2013, Outlook 2007, Outlook 2010, Outlook 2013 Tagged With: Auto Complete List, bcc, Cc, Microsoft Outlook, Suggesting names, Turn Off

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.

Options in Outlook 2013 and Outlook 2010

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

Compose messages settings in Outlook 2013 and Outlook 2010

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

enable auto spell check in Outlook 2013 and Outlook 2010

Turn on check spelling as you type in Outlook 2007

In Outlook 2007, click Tools -> Options menu

Editor Options Outlook 2007

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.

Outlook 2007 Auto Spell Check

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

Filed Under: Office 2007, Office 2010, Office 2013, Outlook 2007, Outlook 2010, Outlook 2013 Tagged With: Auto Spell, Check spelling as you type, Outlook, Proofing

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.

display date and time in Outlook notes

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

show or hide date and time in Outlook 2013, Outlook 2010 notes

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.

Date and time hidden in Outlook notes  

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.

show time and date for notes in Outlook 2007

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

Hidden date and time in Outlook 2007 notes

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

Filed Under: MS Office, Office 2007, Office 2010, Office 2013, Outlook 2007, Outlook 2010, Outlook 2013 Tagged With: display, hide date and time, Notes, Outlook, show date and time, time and date

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.

Auto format values with hyphen to date

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.

Format Cells in Excel

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

Change format to Text in Excel

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

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, MS Office, Office 2007, Office 2010, Office 2013 Tagged With: Apostrophe, disable date, Format Cells, hyphen

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