Viewing: Office 2010

Disable autocomplete suggestion feature in Excel

Excel Auto Complete features automatically suggests a value based on previous entries. Similar to disabling auto fill feature, Excel provides option for disabling the autocomplete suggestion feature as well. So you turn off auto complete suggestion feature if you find it distracting.Listed below are the steps to disable autocomplete suggestion in Excel 2016, Excel 2013 […] Read More

Prevent users from adding new worksheet in Excel

Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to […] Read More

Change outgoing port for email accounts in Outlook

The outgoing port for an email account configured in Outlook 2016, 2013 and 2010 can be changed using the Change Account options. To change the outgoing port, click File menu then navigate to Account Settings and click the Account Settings dropdown arrowThis would display the following Account Settings window with different E-mail accounts.Now select the […] Read More

Slide Show keyboard shortcuts in PowerPoint

PowerPoint 2016, 2013 and 2010 Slide Show keyboard shortcut will be displayed as part Slide Show help (by pressing F1 during a Slide Show). The different Slide Show Shortcuts available as part of PowerPoint are Advanced to the next slide ‘N’, space, right or down arrow, enter, or page down Return to the previous slide […] Read More

Go To specific page number in Word

In Word 2013 and Word 2010 you can go to specific page in the Word document using the Find and Replace dialog. To display the Find and Replace dialog, Navigate to Home menu and click on the drop down arrow under Find menu. Another shortcut for launching Find and Replace is by pressing Ctrl + […] Read More

Repeat action keyboard shortcut in Microsoft Office

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 […] Read More

Find and change default pst file location in Outlook

PST file - Refers to the .pst (personal storage table) filename extension used by Microsoft products.  The file is a locally-stored copy of any message, task, calendar item, etc. from Microsoft Exchange mailboxes. The default location of archive.pst in Outlook  is C:\Users\<username>\Documents\Outlook Files\archive.pst. You can find the default pst file location in Outlook 2010 and […] Read More

How to do a word wrap in Excel

In Excel 2016, 2013 and 2010 when the typed text is larger than the width of the cell the text entered will appear as single line of text. If you want to align this text to the width of the cell then you can use excel 2010 word-wrap feature. If you want to do the […] Read More

What is a status bar in Word document

Microsoft Word 2016, 2013 and 2010 displays a status bar at the bottom of a Word document. Word status bar displays information such word count, page number, line number, zoom, zoom slider, Language and many more details.These details displayed on the word status bar can be configured by using the Customize Status Bar context menu. […] Read More

How to turn off drag and drop of text in Word

Microsoft Word 2016, 2013 and 2010 has feature using which you can drag and drop the text in a document. But if you do not want drag and drop then you can use Word Options to disable or turn off the feature. Listed below are the steps to turn off drag and drop of text […] Read More

How to create a link between two worksheets in Excel

In this short beginners tutorial let us see the steps for creating a simple link between two worksheets in Excel 2016, 2013 and 2010. In Excel, two worksheets can be linked using the paste options.1. From Sheet1, Copy the cell value which needs to be linked with the other Sheet. This can be done by […] Read More

How to change date system for a workbook in Excel

Microsoft Excel allows users to change to 1904 date system (difference between 1900 and 904 date system) using the Excel Advanced Options. Listed below are the steps to change the date system in Excel 2016, 2013 and 2010Step 1: Click the File menu then select Options link.Step 2: In the Excel Options window, click Advanced […] Read More

How to hide To-Do bar in Outlook

Outlook 2016, 2013 and 2010 by default displays To-Do bar on the right hand side. This contains information such as appointments and To-Do tasks. But if you are not using this feature then you can hide the To-Do bar to get more space for your Outlook Application.To hide the To-Do bar in Outlook 2010, navigate […] Read More

How to add a new page in Word

This is a short tutorial on Adding or inserting a new page in Word 2016, 2013 and 2010. This can be done using the options available as part of the Insert menu Word. To add a new page in a Word 2010 document, point the cursor to the place where you want to insert a […] Read More

How to rebuild search index in Outlook

Do you have problem in searching outlook emails then you can try and see if rebuilding the index fixes the problem. To rebuild the search index in Outlook 2016, 2013 and 2010, click the File menu followed by options link. In the Outlook Options window, navigate to Search section and click the Indexing Options button.In […] Read More

1 2 8

Get your free copies of the following tech guides by joining the Digital Answers mailing list.