Viewing: display

How to display blank for zero value in Excel 2016 & 2013

Excel 2013 allows user to display blank value instead of zero value for any expression. This is useful when you want the result value for any formula to be left blank instead of displaying zero.Step 1: Click File menu, select Options from the menu list.Step 2: In the Options window, click the Advanced tab.Step 3: […] Read More

Show or hide scroll bars in Word

In this tutorial we are going to see how to show or hide scrollbars in Word 2016, 2013 & 2010. Microsoft Word users can use the settings available as Word Options to show or hide vertical and horizontal bars.Click the File menu –> Options, this would display the Word Options window.In the Word Options window, […] Read More

How to display input message for cell in Excel

Excel 2016, 2013 & 2010 has a feature for displaying input message for a cell which would help users to enter the correct value/data type. This can be achieved using the Data Validation feature available in Excel.For example if you want to show a message to the user that the cell accepts only numbers, then […] Read More

How to hide paste options button in Word

This tutorial is about the steps to be followed for hiding the paste options button in Word 2016, Word 2013 & Word 2010. When you copy and paste content in a word document the following paste options button will be displayed. This button provides different paste options for formatting the pasted content such as Keep […] Read More

Turn off display of hyperlinks in Outlook 2013 & Outlook 2010 messages

Outlook 2013 & Outlook 2010 by default displays any Internet address as hyperlinks. This is pretty useful feature and by clicking the hyperlink would quickly launch the website. But if you want to disable this feature while reading as well as composing mail, then you turn off this feature using Editor Options.Turn Off display of […] Read More

Insert PDF file in to word document in Word 2013 & Word 2010

This tutorial provides the instruction for inserting the content of PDF file in to a word document in Word 2013 & Word 2010. Please note that this feature in Word 2010 has limitation and will insert only the first page of the PDF file in to Word document.Click the Insert menu in Word then navigate […] Read More

Type fraction numbers in Word 2013 & Word 2010

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

How to unhide the formula bar in excel

Microsoft Excel 2013 and Excel 2010 displays the formula details in Formula bar. In case if your excel does not show the Formula bar then you can unhide the formula bar using the View menu. To unhide the formula bar in Excel 2010 and Excel 2013 Navigate to the View menu and then to the […] Read More

How to turn off the People Pane in Outlook

Microsoft Outlook 2010 displays the Social network activities of the contacts below their emails. This is known as the People Pane and would display the social network activities the Outlook Social Connector. The activities can be tracked form different accounts such as Facebook, LinkedIn, Windows Live Messenger, Viadeo. But if you are an Outlook user […] Read More

How to unhide the navigation pane in Word 2010 and Word 2013

Navigation pane in Word 2010 and Word 2013 is quite useful feature as users can do the following this Search document Browse the headings in document. Browse the pages in document. Browse the results from the current search. But in case if your Word application does not show the navigation pane then you can unhide […] Read More

Insert date in Word displays {DATE\@"dd-MM-yyyy"}

We have already seen how to insert current date in Word 2013 and Word 2010 and also the keyboard shortcut for inserting date in Word 2010. And when inserting the Date if it gets displayed as {DATE\@"dd-MM-yyyy"} i.e date format instead of actual date value, then you can use the Advanced Options to fix this […] Read More

How to hide date and time when viewing notes in Outlook

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

How to customize reading pane in

This tutorial is about the steps required to customize the reading pane in Reading pane by default is turned off in and users enable this using the options available as part of the Settings. users can adjust the reading pane to the right or bottom. They can also configure this setting using […] Read More

Turn off tracking of recent documents in PowerPoint 2011

PowerPoint 2011 for Mac provides users with the option to disable the tracking of recently opened documents. If you do not wish PowerPoint to maintain the history of recent presentations then you can turn off this feature using the General Options. Step 1: Launch PowerPoint 2011 and click PowerPoint menu then select Preferences from menu […] Read More

Display and sort emails by size in Mac Mail

The default sort order of emails in Mail App is by received date and also it does not display the size of the emails. You can follow the below mentioned steps to sort and display the mails by size. Display size of the email Click the View menu then navigate to Message Attributes and tick […] Read More

1 2 4

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