Office 2013

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.

Quickly print emails and attachments in Outlook

October 10, 2015 By Ravi Shankar Leave a Comment

Outlook 2016, 2013 and Outlook 2010 allow users to quickly print email & attachments using quick print options available as part of context menu. This is quite useful when you do not want to open an email and print the attachments.

Enable default printer

First you need to enable the default printer under Print options. Click File menu –> Print

In the Print screen, click Print Options button and mark the check box with caption as “Print attached files. Attachments will print to the default printer only.”

Quick Print in Outlook 2013 and Outlook 2010

Now you can navigate to the email with attachment. Right click and select Quick Print from the right click context menu.

How to clear the trash folder in Outlook

October 6, 2015 By Ravi Shankar 1 Comment

This is tutorial provides instruction for clearing all the items in Outlook 2016 & Outlook 2013 trash folder.

Step 1: Click the Outlook File menu then navigate to Info section.

Step 2: In the Account Information screen, navigate to Mailbox Cleanup section and click the Cleanup Tools arrow pointing downwards.

Step 3: Select Empty Deleted Items Folder from the Cleanup Tools drop down list.

Step 4: Click the Yes button to permanently delete all the items in the Trash folder.

When you have lots of items in your trash folder and want to clean up on a single click then you can use this feature.

Insert check mark in Microsoft Word

October 2, 2015 By Ravi Shankar 6 Comments

Insert check mark in Word 2010 and Word 2013

This tutorial provides steps required to insert tick or check mark in Word 2010, Word 2013 and Word 2016. The most common method is to use the option available as part of Insert > Symbol. Another alternate way is to change the font type to Windings 2 and use the shortcut key for adding the tick mark.

Insert Symbol

Step 1: In the word document, place the cursor to the position where you want to insert tick mark.

Step 2: Click Insert menu, navigate to Symbols section and click the down arrow available below Symbols

Step 3: Select More Symbols from the dropdown list.

Step 4: Select the tick symbol available under Symbol window.

If you do not see the tick symbol, then change the Font to Windings 2 and select the tick symbol from the list.

Changing font to Windings 2

The quickest way to insert tick mark is by changing the font type of your Word document to Windings 2 and then use Keyboard combination “Shift + P”.

Add line numbers in Word 2013, Word 2010 and Word 2007

September 27, 2015 By Ravi Shankar Leave a Comment

Microsoft Word users can add line numbers to a word document using the options available as part of Page Layout menu. In this tutorial we will see the steps for adding line number in Word 2013 and Word 2011 for Mac.

How to add line numbers in Word 2007, Word 2010, Word 2013 and Word 2011 for Mac

Word 2007 Word 2010 and Word 2013

Word 2010 allows users to add line numbers to a word document. This can be done using the Page Layout menu option. For example if you have the following text in your document and you want insert line numbers for each line then you use this feature.

To add line numbers for above paragraph, from Home menu click the Page Layout menu option and then navigate to Page Setup section.

In the Page Layout section, click the drop down arrow next to Line Numbers menu option. This would display the following menu options.

Now select Continuous from the list available menus and this would insert the line numbers in the Word document as shown below

The other line numbers options includes

Restart Each Page – To restart line numbers after each page.
Restart Each Section – To restart line numbers after each section.
Suppress for Current Paragraph – to remove line numbers for the selected paragraph.

Word 2011 for Mac

Step 1: Open the document for which you want to add line number.

Step 2: Click Layout menu and navigate to Text Layout section.

Step 3: Now click the Line Numbers option under Text Layout. This should display the following drop down list.

Step 4: Select Continuous from the Line numbers drop down list to add line numbers. You can also customise Line numbers by use other options in the list.

If you are looking for advanced line number options then click More Line Numbering.

Display of line number in status bar

If you just want to find out the current line number while editing a document then you can use line number option available as part of status bar for this purpose.

Word 2007, Word 2010 and Word 2013

Microsoft Word 2007 and Word 2010 provides option to display the line numbers in a word document. This would be a useful feature when you want to restrict your content based on the number of lines written in the document. If the status bar does not show the line numbers, then right click on the Status bar and select Line number.

After selecting Line Number option in the Customize Status Bar context menu, the status bar would display the line number as shown below.

Word 2011 for Mac

Word 2011 for Mac does not support the display of line number in status bar. This option is available in Window’s version of Microsoft Word but not in Mac OS X.

Also See: How to auto populate random sentences in Word 2010

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.