Tweaking Apps
In this short tutorial we will see how to insert slide number in Keynote on Mac OS X Lion system. Keynote users can insert slide number using the option available as part of the Slide menu.
Click the Slide menu and select Show Slide Number on All Slides. This would display the number at the bottom of the slide. And if you do not want to display the slide number then again click Slide menu and select Hide Slide Numbers on All Slides.
Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list.
This would display the following File Passwords window with different password option.
You can set a password for opening the excel workbook using the Password to open field. Similarly to set a password for modifying the content in the excel workbook, you can use the Password to modify. If you want to make the workbook as readonly then mark the check box labelled as Read-only recommended.
In this tutorial we will see how to recover a deleted folder in Outlook 2010. Let us take the following example to show recovery of deleted folders. Let us say you have deleted a folder named “resources” under Inbox by right clicking on the folder and select Delete Folder from the menu list.
Now to recover the deleted folder, navigate to Deleted Items folder under your email account and expand it. This would display the deleted folder “resources”along with the outlook items.
You can drag and drop the folder to your inbox and restore to place where it was before.
From the right click context menu, if you have selected Delete All menu option then it deletes only the outlook items inside the folder and leaves out the folder. To recover the deleted outlook items, navigate to Deleted Items folder and restore the individual items.
We had already seen how to show gridlines in Word 2010. Similarly there is an option available to display the gridlines in Word for Mac 2011.
Launch Word Mac 2011 and click the Layout menu and then navigate to Grid section.
Now tick the check box with label as Gridlines to display the gridlines in the Word document.
Google Chrome has a feature which when pressing tab highlights the links and form fields. If you are user who heavily uses keyboard tab for navigating between the form fields and you do not want the tab to be highlighted then you can disable this feature using Chrome Preferences.
Click the Chrome menu on the menu bar and select Preferences from the list of available menus.
In the Preferences window, click the Under the hood link.
Navigate to Web Content section available in Under the Hood page.
Now un tick the check box with label as Pressing tab on a webpage highlights links, as well as form fields. This would only highlight the form fields when pressing tabs.
We had already seen brief introduction about using Query function in Google Spreadsheet. Let us see how to limit the number of rows returned using Query Function with the following sample data of batsman with maximum runs in test cricket.
Now if you want to get the top 3 batsman with maximum number of runs scored, then you can use
=QUERY(C3:G13,”select C,G limit 3″)
The limit keyword will reduce the number of results returned to 3.
But say if you want to get the list of top 3 batsman with maximum averages then need to use the Order by clause.
=QUERY(C3:G13,”select C,F order by F desc limit 3″)
The above query would first sort the list using Order by clause and then uses the limit keyword to get the Top results.
This tutorial talks about the Auto Replace feature available in Google Docs. Using this feature, Google Docs users can add abbreviation and their corresponding words. For example, if you want to the entry da to be replaced with digianswers then you can do the following
Click the Tools menu and select Preferences from the displayed menu list.
In the Preferences Window, make sure to mark the check box with label as Automatic substitution.
And type “da” in Replace text box and the corresponding entry “digitalanswers” in With text box. Click OK button which is available at the bottom of the Preferences window to save the changes. Now when you type “da” in the document, it would be replaced with “digitalanswers”
In Google Spreadsheet you can check whether the value entered is a proper email address by creating a data validation rule. This rule does a simple validation and checks for the @ symbol in the entered value. Let us say you have a column in your spreadsheet that needs to accept only email addresses, then you can do the following to add the validation.
Select the Column values, click the Data menu and select Validation from the menu list.
In the Data Validation window, select Text, Contains for the Criteria drop down and specify the value as @
And if you want to display a message to the user then type the message in Help text some thing like “Enter proper email address example [email protected]”. Click on the Save button to save the changes.
Now when you enter a value in the email address column without the @ symbol then it would display the message as shown below.
